Does anyone know how to import or download PCGS Population report to Spreadsheet?

jt88

I tried to follow this guide to import the data but it was stuck at verify you are human. It kept asking me to verify. Does anyone know how to do it?

https://forums.collectors.com/discussion/679884/a-how-to-guide-for-importing-the-pcgs-price-guide-to-microsoft-excel

Goldbully

My how quickly 17 years flies by.

I don't see the import data menu button/tab based on that tutorial.

Coins3675

I would like to be able to do that too.

Old_Collector

It's a simple copy and paste exercise followed by some editing of the Excel document. Select the series you want in comprehensive and then at the bottom select all rather than 100 or other choices.
Then make a new Excel spreadsheet that is as many columns wide as the data and at least as many rows as the date (leave it open), but you can have a lot more and cut them later. Then just paste into the Excel document and trim the extra bottom line that are unused.
I just did it to insure it worked and it does. But it is a bit time consuming compared to just looking up specific items when you need them as it will give you RD/RB/BN for each Lincoln for example and it will give you all the other miscellaneous stuff like Shop with Affiliates in each second box above the date and color.

Not sure if our host minds people doing this for personal use, but definitely they would disapprove for any commercial use. This method can be used for any data on almost any website that is presented in table form.

jt88

@Old_Collector said:
It's a simple copy and paste exercise followed by some editing of the Excel document. Select the series you want in comprehensive and then at the bottom select all rather than 100 or other choices.
Then make a new Excel spreadsheet that is as many columns wide as the data and at least as many rows as the date (leave it open), but you can have a lot more and cut them later. Then just paste into the Excel document and trim the extra bottom line that are unused.
I just did it to insure it worked and it does. But it is a bit time consuming compared to just looking up specific items when you need them as it will give you RD/RB/BN for each Lincoln for example and it will give you all the other miscellaneous stuff like Shop with Affiliates in each second box above the date and color.

Not sure if our host minds people doing this for personal use, but definitely they would disapprove for any commercial use. This method can be used for any data on almost any website that is presented in table form.

Yes. Cut and paste worked but it is very time consuming. I can do the pint page as PDF to get the same result. I want to save a copy for this year and check back in two to three years to see how much the population expand. When the series getting hot the population will expand. That way you know which series is hot.

MetroD

@pcgs_education

Hi Abby,

Any tips here from PCGS?

Thanks.

lilolme

@jt88 said:

@Old_Collector said:
It's a simple copy and paste exercise followed by some editing of the Excel document. Select the series you want in comprehensive and then at the bottom select all rather than 100 or other choices.
Then make a new Excel spreadsheet that is as many columns wide as the data and at least as many rows as the date (leave it open), but you can have a lot more and cut them later. Then just paste into the Excel document and trim the extra bottom line that are unused.
I just did it to insure it worked and it does. But it is a bit time consuming compared to just looking up specific items when you need them as it will give you RD/RB/BN for each Lincoln for example and it will give you all the other miscellaneous stuff like Shop with Affiliates in each second box above the date and color.

Not sure if our host minds people doing this for personal use, but definitely they would disapprove for any commercial use. This method can be used for any data on almost any website that is presented in table form.

Yes. Cut and paste worked but it is very time consuming. I can do the pint page as PDF to get the same result. I want to save a copy for this year and check back in two to three years to see how much the population expand. When the series getting hot the population will expand. That way you know which series is hot.

If you are not needing it in an excel spreadsheet to use the numbers in formulas or otherwise and just want the numbers, then when you have the population report open on your Browsere to what you want (including All) one can go to the Browser - File and then down to Export as PDF and select the folder to place the .pdf file into. It should drop a .pdf file into that folder that has all the information that was on the Browser Pop Report screen but the links and + to expand are not operational/active in the .pdf.

I just tried and it worked.

jt88

@lilolme said:

If you are not needing it in an excel spreadsheet to use the numbers in formulas or otherwise and just want the numbers, then when you have the population report open on your Browsere to what you want (including All) one can go to the Browser - File and then down to Export as PDF and select the folder to place the .pdf file into. It should drop a .pdf file into that folder that has all the information that was on the Browser Pop Report screen but the links and + to expand are not operational/active in the .pdf.

I just tried and it worked.

I did not get what you meant by "one can go to the Browser - File and then down to Export as PDF". I don't see the file tab on my browser but I guess it is the same as print to PDF or cut and paste. Ok. Under US coins there are about 14 items there then under those 14 items there are many more items. If you use cut and paste or print screen as PDF then you have to go to each of them to do it which can take hours. I want to just do a download and get all the data.

nencoin

@jt88 Is something like this what you're looking for? It took about a minute. If so, let me know and I'll tell you what I did.

lilolme

@jt88 said:

@lilolme said:

If you are not needing it in an excel spreadsheet to use the numbers in formulas or otherwise and just want the numbers, then when you have the population report open on your Browsere to what you want (including All) one can go to the Browser - File and then down to Export as PDF and select the folder to place the .pdf file into. It should drop a .pdf file into that folder that has all the information that was on the Browser Pop Report screen but the links and + to expand are not operational/active in the .pdf.

I just tried and it worked.

I did not get what you meant by "one can go to the Browser - File and then down to Export as PDF". I don't see the file tab on my browser but I guess it is the same as print to PDF or cut and paste. Ok. Under US coins there are about 14 items there then under those 14 items there are many more items. If you use cut and paste or print screen as PDF then you have to go to each of them to do it which can take hours. I want to just do a download and get all the data.

Yes the Print to PDF and Export as PDF are probably the same if it drops a file into a folder.

I see what you are asking now and this is not what the link in the OP was doing as it was for a particular series (looks like it was doing the wheat cents) and not a complete download of all of the US coin data. There is a thread on the Forum where some were using an entire database (don't recall which ones but maybe pricing) to process data. I forget what it is called. @yosclimber might have been in that thread(s) but not sure. You need access to that I believe.

yosclimber

There is a PCGS Public API which can be used to get a few fairly specific things from their database.
It does not include getting population data.

jt88

@nencoin said:
@jt88 Is something like this what you're looking for? It took about a minute. If so, let me know and I'll tell you what I did.

Thanks a lot. I want to download or export the whole population report or at least for a country like US or UK or China.

jt88

Maybe PCGS should sell that data for download or population report book in PDF every year. that's a way for them to get some money.