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
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
╳Discussions
💬 Home🔎 Search📅 LatestGroups
EducationOpen discussion area.Fakes & FraudsOpen discussion area.Field CollectingOpen discussion area.FossilsOpen discussion area.Gems and GemologyOpen discussion area.GeneralOpen discussion area.How to ContributeOpen discussion area.Identity HelpOpen discussion area.Improving Mindat.orgOpen discussion area.LocalitiesOpen discussion area.Lost and Stolen SpecimensOpen discussion area.MarketplaceOpen discussion area.MeteoritesOpen discussion area.Mindat ProductsOpen discussion area.Mineral ExchangesOpen discussion area.Mineral PhotographyOpen discussion area.Mineral ShowsOpen discussion area.Mineralogical ClassificationOpen discussion area.Mineralogy CourseOpen discussion area.MineralsOpen discussion area.Minerals and MuseumsOpen discussion area.PhotosOpen discussion area.Techniques for CollectorsOpen discussion area.The Rock H. Currier Digital LibraryOpen discussion area.UV MineralsOpen discussion area.Recent Images in Discussions
GeneralCorrect forum? Mineral List in .csv or .xlsx format?
8th Jun 2017 16:58 UTCScott Braley
Thanks,
Scott
9th Jun 2017 16:25 UTCDonald B Peck Expert
9th Jun 2017 17:58 UTCJeff Weissman Expert
Attachments
You need to be logged in to view attachments.9th Jun 2017 18:00 UTCJeff Weissman Expert
9th Jun 2017 21:45 UTCScott Braley
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
10th Jun 2017 01:05 UTCScott Braley
10th Jun 2017 04:54 UTCJohn A. Jaszczak Expert
10th Jun 2017 08:01 UTCScott Braley
10th Jun 2017 17:20 UTCJohn A. Jaszczak Expert
11th Jun 2017 01:27 UTCScott Braley
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!
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
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