User Tag List

Results 1 to 9 of 9

Thread: Dumping My Collections into excel. Having issues..

  1. #1
    Senior Member klute14's Avatar
    Join Date
    Dec 2008
    Location
    Maine
    Posts
    3,172
     klute14
     klute14
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Dumping My Collections into excel. Having issues..

    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?

  2. #2
    Member
    Join Date
    Sep 2008
    Location
    Stroudsburg, PA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

    Quote Originally Posted by klute14
    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.
    2002 Topps 206 Master Set: 1852/2523 -- 73.4%
    2003 Topps 205 Set: 2148/2634 -- 81.5%
    2004 E-X Autos and Patches
    Andy Pettitte

  3. #3
    Senior Member uniquebaseballcards's Avatar
    Join Date
    Nov 2008
    Posts
    6,783
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

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

    "Topps does not, in any manner, make any representations as to whether its cards will attain any future value."

  4. #4
    Senior Member klute14's Avatar
    Join Date
    Dec 2008
    Location
    Maine
    Posts
    3,172
     klute14
     klute14
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

    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.

    Quote Originally Posted by uniquebaseballcards
    You can also select 'paste special' and then 'text' to avoid all the images.

  5. #5
    Senior Member tonsofcommons's Avatar
    Join Date
    Aug 2008
    Location
    Iowa
    Posts
    6,096
    Mentioned
    56 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

    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.
    Eddie

  6. #6
    Senior Member klute14's Avatar
    Join Date
    Dec 2008
    Location
    Maine
    Posts
    3,172
     klute14
     klute14
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

    I am not sure that would work with multiple years.

    Quote Originally Posted by tonsofcommons
    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.

  7. #7
    Member
    Join Date
    Sep 2008
    Location
    Stroudsburg, PA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

    Did you try adblock? That's what I used and can copy/paste just like before images.
    2002 Topps 206 Master Set: 1852/2523 -- 73.4%
    2003 Topps 205 Set: 2148/2634 -- 81.5%
    2004 E-X Autos and Patches
    Andy Pettitte

  8. #8
    Senior Member klute14's Avatar
    Join Date
    Dec 2008
    Location
    Maine
    Posts
    3,172
     klute14
     klute14
    Mentioned
    41 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

    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.
    Quote Originally Posted by ronzo
    Did you try adblock? That's what I used and can copy/paste just like before images.

  9. #9
    Member
    Join Date
    Sep 2008
    Location
    Stroudsburg, PA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Dumping My Collections into excel. Having issues..

    Quote Originally Posted by klute14
    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.
    Quote Originally Posted by ronzo
    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.
    2002 Topps 206 Master Set: 1852/2523 -- 73.4%
    2003 Topps 205 Set: 2148/2634 -- 81.5%
    2004 E-X Autos and Patches
    Andy Pettitte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •