Looking for mintage figure for all US coins, in Excel format

Geoman

I am wondering if anyone here happens to have a spreadsheet or MS Word document that lists US coins and series by their mintage figures. I have typed in the mintages for all the Morgan Dollars and mint marks last summer. I would like to compose a list for all US coins by series of mintages (as part of a way to start learning key dates, etc).

Does someone have this typed in already that would be willing to email it to me? Thanks in advance.

Also, if you have something like this, but only one series, I still would be interested in it. I am eventually going to put a master list together, including prices, etc. I just don't want to sit down for 2 days copying the Red Book.

dbldie55

I would be interested in this as well. A while back, one of the software programs had mintages. I exported the data to an access db and got it into excel, but it was not complete (and had some errors).

Here is a zipped copy of the file. It is listed by the PCGS series and coin number (but also lists year, mint, denomination etc). There are some missing entries and some errors. Let me know if it helps.


Link to file

19Lyds

PM Me your email. I have some figures to get you started but is no where near complete.

carl

I never thought of adding that to my spread sheets on coins. The one that was linked here is bit confusing. I did not get a heading so what each col represented was just guesswork. Denomination, date and amount minted was clear but not sure of other columns. On the spread sheet I use in Excel I have a different page for each denomiation and type. In other words 1 sheet for Lincoln Cents with a heaading that states Set #1, #2, etc. One sheet for each set. Then a col for date, grade, approx values per Red Book, Grey sheet, My Guess. Now I never added mintages due the availability in so many other books or places. Not only that but it would accomplish very little. However, it would help indicate values based on amounts minted. Going through books, mag's, the internet I've found numerous coins of low mintages with low values. High mintage coins with high cost. Made no Cents to me. Great example is the 31D Mercury Dime with 4th lowest mintage and not much in the way of value.

dbldie55

Added the column info to my post.

Geoman

Thanks to all who replied, I have a good starting point. One more request, and I'll work on the master list this weekend. And post a link to the file on Monday.