Dumping My Collections into excel. Having issues..

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?

Click to expand...

uniquebaseballcards said:

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

Click to expand...

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.

Click to expand...

ronzo said:

Did you try adblock? That's what I used and can copy/paste just like before images.

Click to expand...

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.

Click to expand...

Click to expand...