| Author |
 Topic  |
|
|
Valued Member
United States
261 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
387 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.
Memberships: O.N.A & R.C.N.A
South Wellington Coin Society
|
|
Valued Member
United States
261 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
387 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.  Memberships: O.N.A & R.C.N.A
South Wellington Coin Society
|
|
Moderator
United States
55813 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
849 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: Franklin halves (now complete!), Peace dollars (62-63, four to go), US type (Bust era). What next...? "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
55813 Posts |
I would just stoop to doing the export in IE since it allows it.  |
|
Valued Member
Canada
387 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!
Memberships: O.N.A & R.C.N.A
South Wellington Coin Society
|
|
Moderator
United States
55813 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
1222 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.   "Wisdom is not a product of schooling but of the lifelong attempt to acquire it." - Albert Einstein If you SEE a post milestone, 250, 500, 1000, 2500, 5000, 10K+, click below. http://goccf.com/t/316031#2688706Edited by Coconutjoe
01/18/2018 1:40 pm
|
|
Bedrock of the Community
United States
14659 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.
|
|
Valued Member
United States
398 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
