| Author |
 Replies: 11 / Views: 11,733 |
|
|
Valued Member
United States
314 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
414 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
314 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
414 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
189199 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
2023 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.
|
|
Moderator
United States
189199 Posts |
I would just stoop to doing the export in IE since it allows it.  |
|
Valued Member
Canada
414 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
189199 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
1475 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
|
|
Rest in Peace
United States
17900 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
1375 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. |
| |
Replies: 11 / Views: 11,733 |
|
Posted 01/18/2018 10:19 am
