| Author |
 Topic  |
|
|
Valued Member
United States
288 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 |
 Newly listed items on eBay by einstem. View all einstem's items on eBay.
 |
|
Valued Member
Canada
388 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
288 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
388 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
62351 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
1184 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 (Bust era), 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
62351 Posts |
I would just stoop to doing the export in IE since it allows it.  |
|
Valued Member
Canada
388 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
62351 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
1453 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
643 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 |
|
Posted 01/18/2018 10:19 am
1955 DS JEFFERSON NICKEL PCGS MS64 FREE SHIP
2015P EISENHOWER PRESIDENTIAL DOLLAR CHRONICLES REVERSE PROOF ANACS RP69
1955 BUGS BUNNY SILVER FRANKLIN HALF DOLLAR NGC MS63
