Go Back  DVD Talk Forum > Archives > Archives > DVD Talk Archive
Reload this Page >

Do you use Excel spreadsheets to organize your DVD collection?

Community
Search

Do you use Excel spreadsheets to organize your DVD collection?

 
Thread Tools
 
Search this Thread
 
Old 06-02-04 | 12:04 PM
  #26  
DVD Talk Gold Edition
 
Joined: Jul 2002
Posts: 2,517
Received 4 Likes on 4 Posts
From: Hawkeye Country
Originally posted by marty888
I toss my new purchases onto DVDAF (yakes maybe 5 minutes a week total).

Then I actually watch my DVDs.
Wow! You actually watch your DVD's? I am too busy messing with my Excel Spreadsheet, DVD Profiler, and buying DVD's to actually watch any of them
Numes is offline  
Old 06-02-04 | 12:30 PM
  #27  
Defiant1's Avatar
DVD Talk Gold Edition
 
Joined: Mar 2003
Posts: 2,456
Likes: 0
Received 3 Likes on 3 Posts
I thought I was the only one who used Excel for this kind of stuff. It's good to know others do too!
Defiant1 is offline  
Old 06-02-04 | 12:49 PM
  #28  
Senior Member
 
Joined: Oct 2001
Posts: 395
Likes: 0
Received 0 Likes on 0 Posts
From: Great White North, eh?
I use both MS Excel and DVDaf for my DVDs. I've been tracking my CDs on a MS Word document for years and had always thought it would be cool to track more data. When I jumped into the DVD fray back in 2000, I started tracking purchase date, price, store, etc., right from day one.

Okay, so maybe it wasn't that cool... but it builds character.
Damage is offline  
Old 06-02-04 | 02:10 PM
  #29  
DVD Talk Platinum Edition
 
Joined: Jun 2001
Posts: 3,208
Likes: 0
Received 1 Like on 1 Post
From: Boston
Years ago I was using Acess database, but my computer crased. I've been using the 3 in my signiture ever since. I'm happy with them.
mikewendt is offline  
Old 06-02-04 | 02:10 PM
  #30  
Cool New Member
 
Joined: May 2004
Posts: 33
Likes: 0
Received 0 Likes on 0 Posts
What the world needs is another DVD collection organizer right? Check out my own DVD collection using my own website I created.

http://www.dvdspot.com/member=Croy

It allows you to export your collection into CSV/Excel format. Tomorrow I am releasing the ability to import a titles/upc's in text or csv format.
Easley is offline  
Old 06-02-04 | 02:51 PM
  #31  
Member
 
Joined: Jan 2004
Posts: 130
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by whatever
There is a great program from http://www.collectorz.com called Movie Collector also. I highly recommend it.

This does the job for me and covers all my LD and ...gasp...VHS movies too.
TBFL is offline  
Old 06-02-04 | 03:01 PM
  #32  
Senior Member
 
Joined: Mar 2004
Posts: 290
Likes: 0
Received 0 Likes on 0 Posts
From: my own little world
EXCEL rocks.

Most casual users don't realize just how powerful a tool it is. I use the spreadsheet to track my DVD collection as it is easily customizable. True, the drawback is that you have to enter all the data manually for whatever you want to track, but the process is fairly quick unless you're entering the entire synopsys of the movie as well. Given the slow load times as well as the time spent on selecting the exact version of the DVD that you own when using DVDaf and other online programs, I don't think it's that much quicker / easier thank EXCEL. IMO, the primary benefit of the online organizers would have to be that it can be easily shared with others.


-NHN
NoxHaveN is offline  
Old 06-02-04 | 03:36 PM
  #33  
Member
 
Joined: Apr 2001
Posts: 135
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by Drexl
I'm considering using Access to do it, but it will take a while.
I use a home brewed Access database (dubbed dvdbase) to keep track of my DVD purchases. But I am way behind on updating the information (actors, directors, features, year, # of discs, category, rating, etc...). I'm seriously thinking of moving to one of the online sites.
dvdbase is offline  
Old 06-02-04 | 06:12 PM
  #34  
eau
DVD Talk Hall of Fame
 
Joined: May 2000
Posts: 9,379
Likes: 0
Received 0 Likes on 0 Posts
I use Excel too
eau is offline  
Old 06-02-04 | 06:23 PM
  #35  
Mok
DVD Talk Platinum Edition
 
Joined: Nov 2002
Posts: 3,530
Likes: 0
Received 0 Likes on 0 Posts
From: WPB FL
Excel works great for me I sort everything by genre.
Mok is offline  
Old 06-02-04 | 06:52 PM
  #36  
Thread Starter
Member
 
Joined: Dec 2003
Posts: 182
Likes: 0
Received 0 Likes on 0 Posts
From: Indiana
Originally posted by JuryDuty
I use DVDAF for my friends to see and for PDA use.

I use Excel for me because I can be more detailed. Here is a link to look at my Excel sheet.

Man, Get Me Coffee, I LOVE your charts and graphs! Is there an easy way to set those up? I have columns very similar to yours, but can't figure out how to break them down so it counts (for instance) how many PG movies I have.
Cool, I think I'm going to make a spreadsheet similar to yours. Simple, yet it gives everything you need to know about the movie right there. Thanks for posting yours

BTW if you don't mind me asking, how do you get so much free stuff from Amazon.com? (Indiana Jones set, 24 seasons, Freaks and Geeks, etc?)
OREOSpeedwagon is offline  
Old 06-02-04 | 09:03 PM
  #37  
DVD Talk Gold Edition
 
Joined: Mar 2000
Posts: 2,782
Likes: 0
Received 0 Likes on 0 Posts
From: Smallville
Originally posted by NoxHaveN
EXCEL rocks.

Most casual users don't realize just how powerful a tool it is. I use the spreadsheet to track my DVD collection as it is easily customizable. True, the drawback is that you have to enter all the data manually for whatever you want to track, but the process is fairly quick unless you're entering the entire synopsys of the movie as well. Given the slow load times as well as the time spent on selecting the exact version of the DVD that you own when using DVDaf and other online programs, I don't think it's that much quicker / easier thank EXCEL. IMO, the primary benefit of the online organizers would have to be that it can be easily shared with others.


-NHN
could you post a copy of your excel worksheet so i can model mine after your. thanks
the_dude8 is offline  
Old 06-02-04 | 10:05 PM
  #38  
JuryDuty's Avatar
DVD Talk Limited Edition
 
Joined: Oct 1999
Posts: 6,717
Received 61 Likes on 48 Posts
From: Lost in Texas
Originally posted by OREOSpeedwagon
BTW if you don't mind me asking, how do you get so much free stuff from Amazon.com? (Indiana Jones set, 24 seasons, Freaks and Geeks, etc?)
Look no further than Yahoo! VISA! I put EVERYTHING on my Yahoo! VISA, then pay it off monthly. Meanwhile, I get points every month for those purchases, and then can turn them in for Amazon or Barnes and Noble Gift Certificates. More than half the new stuff I get, I get that way, through $50 GC's each month or so. I love it because it allows me to justify my DVD habit with my family since most of them are free.

But be careful, if you don't pay it off each month, it could get very expensive!
JuryDuty is offline  
Old 06-02-04 | 10:06 PM
  #39  
DVD Talk Special Edition
 
Joined: Feb 2003
Posts: 1,271
Likes: 0
Received 1 Like on 1 Post
From: Bluegrass State
Originally posted by atari2600
i use excel to keep track of my want list...organize by want level (ie. 1 to 5), their columbia house status (enrollment, fullfillment, not available, etc) and their status (ordered, shipped, etc).
This is EXACTLY what I do. The only difference is I rank my want list from 1-5 then sub-catagorize by alphabet. I can spend hours organizing DVDs I don't even have yet. What fun!!!
cajun_junky is offline  
Old 06-02-04 | 11:48 PM
  #40  
Thread Starter
Member
 
Joined: Dec 2003
Posts: 182
Likes: 0
Received 0 Likes on 0 Posts
From: Indiana
Originally posted by JuryDuty
Look no further than Yahoo! VISA! I put EVERYTHING on my Yahoo! VISA, then pay it off monthly. Meanwhile, I get points every month for those purchases, and then can turn them in for Amazon or Barnes and Noble Gift Certificates. More than half the new stuff I get, I get that way, through $50 GC's each month or so. I love it because it allows me to justify my DVD habit with my family since most of them are free.

But be careful, if you don't pay it off each month, it could get very expensive!
Damn, too bad I'm only 16 Yahoo! Visa will be the first CC I apply for when I turn 18 though
OREOSpeedwagon is offline  
Old 06-02-04 | 11:51 PM
  #41  
mdc3000's Avatar
DVD Talk Hall of Fame
 
Joined: Nov 2001
Posts: 9,921
Likes: 0
Received 0 Likes on 0 Posts
From: Guelph, Ontario
I use Excel... just to keep track of all my titles, their running times, ratings, aspect ratio and case type (as well as disc number)... nothing fancy... just in case anything happens, I'll have a nice list (and my collection is numbered according to excel)... also use Guzzlefish though.

MATT
mdc3000 is offline  
Old 06-03-04 | 06:07 AM
  #42  
DVD Talk Gold Edition
 
Joined: Oct 2000
Posts: 2,349
Likes: 0
Received 0 Likes on 0 Posts
From: Seattle
I posted mine for anyone who wants to look at it. I deleted all the pricing info from it though, so some of the other stuff off to the side probably doesn't work properly. I've been meaning to spruce it up for a while now, but I hope to get around to making it look nicer when school's done. Either that or I'll just give in and start using DVDProfiler
FatTony is offline  
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.