Welcome to our community

Be apart of something great, join today!

Dumping My Collections into excel. Having issues..

klute14

New member
Dec 4, 2008
3,175
Maine
Before Beckett added images, I could dump my collection into excel and manipulate.
With the images, it's duplicating the cards on the same line.
Annoying.
Anyone else have this same problem?
 

ronzo

Member
Sep 8, 2008
596
Stroudsburg, PA
klute14 said:
Before Beckett added images, I could dump my collection into excel and manipulate.
With the images, it's duplicating the cards on the same line.
Annoying.
Anyone else have this same problem?
You need to get firefox and download adblock, then right click one of the images and you should have an option to block beckett images.
 

klute14

New member
Dec 4, 2008
3,175
Maine
I try that and this is how it looks:

Item image of 2002 Fleer Premium Star Ruby #32 Ben Grieve 2002 Fleer Premium Star Ruby #32 Ben Grieve
Item image of 2002 Fleer Premium Star Ruby #94 Terrence Long 2002 Fleer Premium Star Ruby #94 Terrence Long
Item image of 2002 Fleer Premium Star Ruby #98 Rondell White 2002 Fleer Premium Star Ruby #98 Rondell White

It duplicates the card.

uniquebaseballcards said:
You can also select 'paste special' and then 'text' to avoid all the images.
 

tonsofcommons

Active member
Aug 20, 2008
6,098
Iowa
What I would do is save it as CSV file, open that file in notepad, do a replace and replace " 2002" (make sure there is a space before "2002) with ", 2002". Save.

Then open that same file in Excel, that should give you 3 separate columns, "Item image of" and then 2 columns with the card information. Then you can delete the columns you don't want.
 

klute14

New member
Dec 4, 2008
3,175
Maine
I am not sure that would work with multiple years.

tonsofcommons said:
What I would do is save it as CSV file, open that file in notepad, do a replace and replace " 2002" (make sure there is a space before "2002) with ", 2002". Save.

Then open that same file in Excel, that should give you 3 separate columns, "Item image of" and then 2 columns with the card information. Then you can delete the columns you don't want.
 

klute14

New member
Dec 4, 2008
3,175
Maine
Thanks for the heads up.
I must be doing something wrong because I block the images.
The images are now gone, however when I highlight and click copy and paste special "text" in excel, this is the result:

Item image of 1998 Flair Showcase Row 0 #102 J.T. Snow 1998 Flair Showcase Row 0 #102 J.T. Snow
Item image of 1998 Flair Showcase Row 0 #104 Wilson Alvarez 1998 Flair Showcase Row 0 #104 Wilson Alvarez
Item image of 1999 Pacific Omega Copper #205 Gary Matthews Jr. 1999 Pacific Omega Copper #205 Gary Matthews Jr.
Item image of 2002 Diamond Kings Silver Foil #53 Paul Lo Duca 2002 Diamond Kings Silver Foil #53 Paul Lo Duca
Item image of 2002 Donruss Originals Power Alley #4 Luis Gonzalez 2002 Donruss Originals Power Alley #4 Luis Gonzalez
Item image of 2002 Donruss Originals Power Alley #9 Mike Piazza 2002 Donruss Originals Power Alley #9 Mike Piazza
Item image of 2002 Fleer Premium Star Ruby #32 Ben Grieve 2002 Fleer Premium Star Ruby #32 Ben Grieve
Item image of 2002 Fleer Premium Star Ruby #94 Terrence Long 2002 Fleer Premium Star Ruby #94 Terrence Long
Item image of 2002 Fleer Premium Star Ruby #98 Rondell White 2002 Fleer Premium Star Ruby #98 Rondell White

I don't get it.
ronzo said:
Did you try adblock? That's what I used and can copy/paste just like before images.
 

ronzo

Member
Sep 8, 2008
596
Stroudsburg, PA
klute14 said:
Thanks for the heads up.
I must be doing something wrong because I block the images.
The images are now gone, however when I highlight and click copy and paste special "text" in excel, this is the result:

Item image of 1998 Flair Showcase Row 0 #102 J.T. Snow 1998 Flair Showcase Row 0 #102 J.T. Snow
Item image of 1998 Flair Showcase Row 0 #104 Wilson Alvarez 1998 Flair Showcase Row 0 #104 Wilson Alvarez
Item image of 1999 Pacific Omega Copper #205 Gary Matthews Jr. 1999 Pacific Omega Copper #205 Gary Matthews Jr.
Item image of 2002 Diamond Kings Silver Foil #53 Paul Lo Duca 2002 Diamond Kings Silver Foil #53 Paul Lo Duca
Item image of 2002 Donruss Originals Power Alley #4 Luis Gonzalez 2002 Donruss Originals Power Alley #4 Luis Gonzalez
Item image of 2002 Donruss Originals Power Alley #9 Mike Piazza 2002 Donruss Originals Power Alley #9 Mike Piazza
Item image of 2002 Fleer Premium Star Ruby #32 Ben Grieve 2002 Fleer Premium Star Ruby #32 Ben Grieve
Item image of 2002 Fleer Premium Star Ruby #94 Terrence Long 2002 Fleer Premium Star Ruby #94 Terrence Long
Item image of 2002 Fleer Premium Star Ruby #98 Rondell White 2002 Fleer Premium Star Ruby #98 Rondell White

I don't get it.
ronzo said:
Did you try adblock? That's what I used and can copy/paste just like before images.
When I get home ill double check and post how to do it.
 

Latest posts

Top