Results 1 to 15 of 15

Thread: Anyone using Google Spreadsheets for their collection lists?

  1. #1
    Pac-Man (Level 10) ianoid's Avatar
    Join Date
    Jul 2002
    Location
    Austin TX
    Posts
    2,198
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default Anyone using Google Spreadsheets for their collection lists?

    I was about to upload all of my collection inventories to Google Spreadsheets so that I don't have to wait until I get home to look at them (and determine if I possess something).

    Anyone try using Google for their lists?

  2. #2
    Apple (Level 5)
    Join Date
    Aug 2006
    Posts
    1,110
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    2
    Thanked in
    2 Posts

    Default

    Any good? I never tried it. I usually just use Lotus (Excel).

  3. #3
    Pac-Man (Level 10) ianoid's Avatar
    Join Date
    Jul 2002
    Location
    Austin TX
    Posts
    2,198
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    It seems basic, but since it's online, I don't have to deal with posting them to the web, and I can access them anywhere with web. And I wouldn't have to move them around the computers in my house (basement, laptop, etc) with a flash drive or deal with networking them.

    I'll try to post a link when I get some going here.

  4. #4
    Pac-Man (Level 10) briskbc's Avatar
    Join Date
    Jul 2002
    Location
    BC Canada
    Posts
    2,400
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    I started messing with this after reading your thread. I never new it existed. This is pretty cool and is sort of what I was looking for. If only it had more than 100 rows. My current spreadsheet has at 384 rows so I will no have to resort my categories and add worksheets. I'm going to play around with it and see if it works for me.

    Thanks for pointing this out.

  5. #5
    Banned

    Join Date
    Jul 2002
    Posts
    6,165
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    1
    Thanked in
    1 Post

    Default

    Why not just upload the Excel (or whatever) files to an e-mail account?

  6. #6
    Pac-Man (Level 10) ianoid's Avatar
    Join Date
    Jul 2002
    Location
    Austin TX
    Posts
    2,198
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    More limitations:

    50000 cells and 20 worksheets. I've already divided one of my lists into two sets of less than 20 worksheets and now I'm not sure how to figure out the cells issues. I hope it's not counting empty cells? I believe it's smarter than that.

    This could take a while. It would suck if I had to make individual files for each system rather than using worksheets.

  7. #7
    Pac-Man (Level 10) briskbc's Avatar
    Join Date
    Jul 2002
    Location
    BC Canada
    Posts
    2,400
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    There is a solution to the # of rows on one worksheet. You can select 10 rows (for example) and go to the insert button and choose the "10 rows above/below" choice. I stopped at the 400 rows I needed. You can do the same with columns.

  8. #8
    Insert Coin (Level 0) The-Bavis's Avatar
    Join Date
    Apr 2005
    Location
    NET, Texas
    Posts
    159
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts
    Xbox LIVE
    ChuckleFutz

    Default

    This sounds like a lot of hassle to mess with the Google limitations for what you want. To make your Excel available online (I'm assuming it's while you're at work or something), just save it as HTML and load it into some crummy free web site like geocities just for your own use.

    Or you could take the time to input your data into IGN "My Collection" or something similar.
    The-Bavis

  9. #9
    Avoiding OT Vectorman0's Avatar
    Join Date
    Dec 2004
    Location
    CT - USA
    Posts
    4,398
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts
    Xbox LIVE
    Vectorman0
    PSN
    Vectorman0

    Default

    I use it to keep track of my want list, and games I have for the select systems I have trouble remembering. It works well for these smaller lists, and come in handy when I am away from home.

    The big downside is that you can't share it with anyone, unless you put their email address (gmail required I assume) in a list to approve them.


  10. #10
    Pac-Man (Level 10) ianoid's Avatar
    Join Date
    Jul 2002
    Location
    Austin TX
    Posts
    2,198
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    The joy of this, if I go through the trouble, is that I don't have to worry about being anywhere to modify the sheets. They are accessible from home (various computers), work, wherever. It will prevent me from redundant purchases and stuff.

    I haven't messed with it since I discovered I couldn't just import my 2meg worksheets in. I may yet import each individually.

    ian

  11. #11
    Strawberry (Level 2) NES_Rules's Avatar
    Join Date
    May 2006
    Location
    Northeast Ohio
    Posts
    511
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    I never knew Google had anything like this. But I just use the collection tools on this website and at RFGeneration.com

  12. #12
    Kirby (Level 13) cyberfluxor's Avatar
    Join Date
    Aug 2005
    Location
    Chesapeake, VA
    Posts
    5,560
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Quote Originally Posted by NES_Rules
    RFGeneration.com
    I need to get on there sometime and put some more lists on there. It just seemed so redudant and boring plus time consuming to find all the titles I wanted. Their search feature to add just takes so long. This is the type of reason why I try to stay away from databases located on websites instead just put everything in a TXT and update whenever you can. I try every several months to do an inventory check to be sure I have every game uploaded here and every game I own is still in my collection. It's sometimes hard to keep it all tracked and good.
    [Website] [Gallary] [Games List] [DP Feedback]

  13. #13
    Great Puma (Level 12) captain nintendo's Avatar
    Join Date
    Apr 2003
    Location
    El Mirage, Arizona
    Posts
    4,408
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Quote Originally Posted by cyberfluxor
    Their search feature to add just takes so long.
    You must being doing it wrong? Adding one game at a time? I "add games", then go through the system I need to add games for. "checking" the box next to every game I needed to add.

    I added like 500 NES games to my collection profile over at RF Generation in under 5 minutes, by simply checking the boxes and uploading

    And I would looking into the google spread sheet, but who am I kidding? Like I want to do yet another spread sheet :P
    (however this google thing does look promising)

    "until all are one" - Optimus Prime
    Link to collection:
    http://www.rfgeneration.com/cgi-bin/...der=Collection


    R.I.P. Michael "Nepenthean" Collins
    You will not be forgotten.

  14. #14
    Cherry (Level 1) ClassicGameTrader's Avatar
    Join Date
    Jan 2005
    Location
    Detroit
    Posts
    341
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts
    PSN
    stillgetmine199

    Default

    Forget Google, use Gametz.com for your collection listing, it is soooo much better than the options listed here.
    'Why should I lie when I can dramatize?"

  15. #15
    ServBot (Level 11)
    Join Date
    Oct 2004
    Location
    Columbus/OHIO
    Posts
    3,070
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default hmmm...

    I use GameCollector. I can output my list to a .txt file which I can import onto my PSP using CNReader (text reader). Has limitations, but works for me...

    Later,
    Trebuken

Similar Threads

  1. Replies: 14
    Last Post: 05-21-2009, 07:44 AM
  2. Your Personalized Collection Lists on DP!
    By digitalpress in forum Classic Gaming
    Replies: 115
    Last Post: 02-15-2005, 09:41 PM

Posting Permissions

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