| Author |
 Topic  |
|
|
Valued Member
United States
293 Posts |
All, Is there a way to download the PCGS price guides to an Excel spreadsheet. For example, I am looking at the Peace dollar PCGS Price guide at this link: https://www.PCGS.com/prices/pricegu...+dollarI would like to download this whole table to an Excel spreadsheet. Anyone know a way to do that? Regards, Michael |
|
|
|
Valued Member
Canada
390 Posts |
Just click the right mouse button within the price list and "Export to Microsoft Excel". It takes a minute to load but works great for me.
|
|
Valued Member
United States
293 Posts |
Unfortunately, I don't see that option when I right-click the mouse. I only see "Back", "reload", "Save", "Print", "Adobe" and a few other strange things. But no "Excel" option. Is that perhaps a special option on Macs (I'm on Windows) or from some other software?
Michael
|
|
Valued Member
Canada
390 Posts |
Sorry for the large screen shot but this is what my options look like. You can always highlight the fields you want and copy and paste, just do not use "Keep Source Formatting" or it will turn into a mess, you want the data only.  |
|
Moderator
United States
66597 Posts |
I believe Microsoft Office integrates with IE to allow that. Not going to work with Firefox or Chrome.
|
|
Pillar of the Community
United States
1378 Posts |
"Export to Excel" looks like it's only in Internet Explorer.
The closest I could come is:
* Click "Print" at upper right. That will show the price guide in a new page without all the graphics.
* On this page, do "Select All" (Ctrl-A, or pick that from the Edit menu) then "Copy" (Ctrl-C, or from the Edit menu)
* Go to Excel, and "Paste" (Ctrl-V, or from the Edit menu) into a new spreatsheet
You'll have to do a lot of manual cleanup in Excel, but all the numbers are there.
Working on: Peace dollars (two to go), US type (early Bust era), Indian quarter eagles, Chinese pandas, and San Francisco tokens. "Fear is the enemy of will. Will is what makes you take action; fear is what stops you, and makes you weak." -- Sinestro to ( my avatar) Hal Jordan, "Green Lantern" (2011) |
|
Moderator
United States
66597 Posts |
I would just stoop to doing the export in IE since it allows it.  |
|
Valued Member
Canada
390 Posts |
Quote:
I believe Microsoft Office integrates with IE to allow that. Not going to work with Firefox or Chrome. Good to know, I didn't realize other providers didn't offer such a thing, thanks for clearing that up!
|
|
Moderator
United States
66597 Posts |
You are welcome. Microsoft makes both Office and Internet Explorer. I would be shocked if they did not integrate this way.  Chrome and Firefox may have had an Office plugin at one time, but they have both deprecated their API that would have allowed it (too many security issues). For what it is worth, I opened up the PCGS page in IE and I have those options.  |
|
Pillar of the Community
United States
1460 Posts |
Couple different options. If you just want to save the data as a reference, you can "save as PDF" using the PRINT icon on the top right of the PCGS screen. If you are not using Explorer browser, but have Office 2013 or above, you can just do copy & paste.   Edited by Coconutjoe
01/18/2018 1:40 pm
|
|
Bedrock of the Community
United States
15719 Posts |
Copy paste is pretty easy, and allows transfer to your own table. You can pick just what you want, rather than the whole table.
|
|
Pillar of the Community
United States
799 Posts |
Quote:
Microsoft makes both Office and Internet Explorer. I would be shocked if they did not integrate this way. Well .... Microsoft makes the Edge browser as well and it can't import the webpage data into Excel. I suspect this "feature" was eliminated due to potential security flaws.
|
| |
Topic |
|
Shop Coin Community Members on eBay
Posted 01/18/2018 10:19 am
