Log InRegister
Quick Links : The Mindat ManualThe Rock H. Currier Digital LibraryMindat Newsletter [Free Download]
Home PageAbout MindatThe Mindat ManualHistory of MindatCopyright StatusWho We AreContact UsAdvertise on Mindat
Donate to MindatCorporate SponsorshipSponsor a PageSponsored PagesMindat AdvertisersAdvertise on Mindat
Learning CenterWhat is a mineral?The most common minerals on earthInformation for EducatorsMindat ArticlesThe ElementsThe Rock H. Currier Digital LibraryGeologic Time
Minerals by PropertiesMinerals by ChemistryAdvanced Locality SearchRandom MineralRandom LocalitySearch by minIDLocalities Near MeSearch ArticlesSearch GlossaryMore Search Options
Search For:
Mineral Name:
Locality Name:
Keyword(s):
 
The Mindat ManualAdd a New PhotoRate PhotosLocality Edit ReportCoordinate Completion ReportAdd Glossary Item
Mining CompaniesStatisticsUsersMineral MuseumsClubs & OrganizationsMineral Shows & EventsThe Mindat DirectoryDevice SettingsThe Mineral Quiz
Photo SearchPhoto GalleriesSearch by ColorNew Photos TodayNew Photos YesterdayMembers' Photo GalleriesPast Photo of the Day GalleryPhotography

GeneralCorrect forum? Mineral List in .csv or .xlsx format?

8th Jun 2017 16:58 UTCScott Braley

I've been attempting to find a reasonably current mineral listing + formulas in .csv or .xlsx format, something I can use for my mineral catalog. IMA has a nice .pdf, but that isn't exportable to a useful format, and I'm not planning to retype it! IMA also has a database that can theoretically be exported but it times out and fails when I try even a single mineral. At a stretch I could code up a parser to extract what I want but that would be tedious, and I'm sure someone has done it already. Even a "most common minerals" would be useful - say the top 750 or so (I have some oddball stuff). Can anyone help?


Thanks,

Scott

9th Jun 2017 16:25 UTCDonald B Peck Expert

Scott, Not sure what you are trying to do, but . . . I do use mindat when building my catalog, which is in Microsoft Access. I use the mineral page and the site page, both open; and simply move back and forth between them and my catalog page. I copy the name, formula, and location details and paste them into Access. My only complaint, and it is a minor one, is that the subscripts in the formula do not remain "subscripted".

9th Jun 2017 17:58 UTCJeff Weissman Expert

Here is a reasonably up-to-date list, the formulas may not strictly correspond to the IMA or MINDAT ones. I cannot attach a *.csv file, here is a pdf - you will have to parse the two sets (names, followed by compositions) and check alignment after converting into two columns

Attachments

You need to be logged in to view attachments.

9th Jun 2017 18:00 UTCJeff Weissman Expert

I notices some special characters did not get converted correctly, they got replaced by '?', so some massaging is in order.

9th Jun 2017 21:45 UTCScott Braley

Thanks, mindat, for not retaining my lengthy post when I click on "Log In."


Not retyping all that.


I want to put a dropdown into my mineral catalog with correct (and formatted) chemical formulae.


Thanks for the .pdf, Jeff.


Donald - I have an absurd collection of >10000 specimens - no copy/paste or typing here, picklists are the way to go.

10th Jun 2017 00:55 UTCDonald B Peck Expert

Scott, I get it !!!! 10,000 specimens is a lot of typing.

10th Jun 2017 01:05 UTCScott Braley

The nice thing about Excel is autocomplete - at least there's not a lot of other minerals that start with "Q" so Quartz is just one keystroke!

10th Jun 2017 04:54 UTCJohn A. Jaszczak Expert

You can download frequently updated (from IMA) lists of minerals with formulae, references, etc. at http://rruff.info/ima/

10th Jun 2017 08:01 UTCScott Braley

Couldn't get export to work the other day, no matter what I tried. Today it worked just fine. Thanks John, I had given up on the rruff page.

10th Jun 2017 17:20 UTCJohn A. Jaszczak Expert

Our IT people here were able to write a script for Microsoft Word that translates the subersript and subscript code from the rruff data and have it present correctly in Microsoft Word documents!

11th Jun 2017 01:27 UTCScott Braley

What I did that worked:

From the rruff page, I select the option in the bottom left corner "IMA Chemisty (plain)"

Then select the "view in table format" button.

This brings up a new window with a table with two columns, mineral name and formatted chemical formula.

Select all, copy, and paste.


Worked fine in both Word 2016 and Excel 2016, automatically created a table in Word and dropped neatly into cells in Excel. Preserved all the formatting of the chemical formulae.


Thanks for the tip!
 
and/or  
Mindat Discussions Facebook Logo Instagram Logo Discord Logo
Mindat.org is an outreach project of the Hudson Institute of Mineralogy, a 501(c)(3) not-for-profit organization.
Copyright © mindat.org and the Hudson Institute of Mineralogy 1993-2024, except where stated. Most political location boundaries are © OpenStreetMap contributors. Mindat.org relies on the contributions of thousands of members and supporters. Founded in 2000 by Jolyon Ralph.
Privacy Policy - Terms & Conditions - Contact Us / DMCA issues - Report a bug/vulnerability Current server date and time: May 14, 2024 18:03:28
Go to top of page