PopTodd Posted March 15, 2016 Share Posted March 15, 2016 Finished yesterday.Now... this is albums only, not individual tracks because:A. Albums are mostly what I care about.B. Individual tracks would be an even bigger pain in the ass. I attached the file to this thread just for fun, if you find that kind of thing fun. It's an accomplishment of sorts, so I thought that I would share.File (read only) here:https://drive.google.com/file/d/0ByQbh_hBkluQUW5wZzZHSG00c2M/view?usp=sharingEDIT:For the record:It's only things that I have imported or downloaded into my iTunes library (many of which I also have on CD or vinyl—guessing about 3/4).It takes up 1851 rows of an Excel file... each row being an album. Quote Link to post Share on other sites
remphish1 Posted March 15, 2016 Share Posted March 15, 2016 Neat..I am a big list guy..I have a list of every show I have ever seen, the openers and the venue in a word file and an excel file with every band I saw and how many times. Thankfully I started this list in 1996! It is overwhelming and scary when I see how many shows and bands I have seen but I appreciate having the list at my fingertips! Quote Link to post Share on other sites
Hixter Posted March 15, 2016 Share Posted March 15, 2016 The board probably denies Excel files because they can contain dangerous macros. Maybe it'll allow posting if you zip the file first? Or you could save it as a Google document and share a read-only link. Quote Link to post Share on other sites
PopTodd Posted March 15, 2016 Author Share Posted March 15, 2016 The board probably denies Excel files because they can contain dangerous macros. Maybe it'll allow posting if you zip the file first? Or you could save it as a Google document and share a read-only link.Tried zipping it, but that's not upping either.I'll see if I can do that Google thing, although I've never done it before. So, I'll try to figure it out. And, if and when I do, I'll post the link. Quote Link to post Share on other sites
PopTodd Posted March 15, 2016 Author Share Posted March 15, 2016 Okay... I got it onto a Google drive so you all can see it and read it. Link in the first post.Thanks for the tip, Hixter! Quote Link to post Share on other sites
Hixter Posted March 15, 2016 Share Posted March 15, 2016 Thanks for the tip, Hixter!Happy to help! I don't use it very much, but you inspired me to post the contents of my iTunes library, too. I just viewed my library by song, selected everything and then copied and pasted into Excel and uploaded it to Google Docs. It's most of my CD collection (as of a few years ago) and there are some glaring typos, some of which were caused by attempting to automatically batch rename files and tags, which didn't work so well. The Billboard Top 100 albums were compiled by someone else, but they're a lot of fun to play over the outdoor speakers while socializing with the neighbors. I just let everyone pick songs via my iPhone; we're obviously suckers for cheesy 70s songs. If you sort the library by the number of iTunes plays you'll discover which song we traditionally play at the beginning of every boozy neighborhood gathering. Here are my 31,000 songs: https://docs.google.com/spreadsheets/d/1iuREAy_UAJ1-q5ZSn0VQ6VZIrK8mWEH5azZqeqEy490/edit?usp=sharing Quote Link to post Share on other sites
Lammycat Posted March 15, 2016 Share Posted March 15, 2016 EDIT:For the record:It's only things that I have imported or downloaded into my iTunes library (many of which I also have on CD or vinyl—guessing about 3/4).It takes up 1851 rows of an Excel file... each row being an album. Well played.... Quote Link to post Share on other sites
i'm only sleeping Posted March 15, 2016 Share Posted March 15, 2016 For the record:It's only things that I have imported or downloaded into my iTunes library (many of which I also have on CD or vinyl—guessing about 3/4).It takes up 1851 rows of an Excel file... each row being an album. Which amouns to 5 albums a day to hear them all in a year, with no repeats...So many records and so little time...Frustrating! Anyway, nice list, thanks for sharing it Quote Link to post Share on other sites
LouieB Posted March 15, 2016 Share Posted March 15, 2016 I need to do this. I was looking through stuff last night to find something I couldn't find (and then found it exactly where it should be) and realized I had lots of records I didn't know I had. LouieB Quote Link to post Share on other sites
John Smith Posted March 16, 2016 Share Posted March 16, 2016 I did this quite a while ago. Ill have to look for the list and do some updating. Maybe a rainy day project. Quote Link to post Share on other sites
Cam Jones Posted March 16, 2016 Share Posted March 16, 2016 need more Floyd Quote Link to post Share on other sites
Sir Stewart Posted March 16, 2016 Share Posted March 16, 2016 Happy to help! I don't use it very much, but you inspired me to post the contents of my iTunes library, too. I just viewed my library by song, selected everything and then copied and pasted into Excel and uploaded it to Google Docs. It's most of my CD collection (as of a few years ago) and there are some glaring typos, some of which were caused by attempting to automatically batch rename files and tags, which didn't work so well. The Billboard Top 100 albums were compiled by someone else, but they're a lot of fun to play over the outdoor speakers while socializing with the neighbors. I just let everyone pick songs via my iPhone; we're obviously suckers for cheesy 70s songs. If you sort the library by the number of iTunes plays you'll discover which song we traditionally play at the beginning of every boozy neighborhood gathering. Here are my 31,000 songs: https://docs.google.com/spreadsheets/d/1iuREAy_UAJ1-q5ZSn0VQ6VZIrK8mWEH5azZqeqEy490/edit?usp=sharingAccording to that, you've listened to Have You Never Been Mellow far more often than any other song in your collection. Quote Link to post Share on other sites
PopTodd Posted March 16, 2016 Author Share Posted March 16, 2016 need more Floyd meh.I heard all that stuff so much when I was a kid that it's okay if I never hear it again. Quote Link to post Share on other sites
Hixter Posted March 16, 2016 Share Posted March 16, 2016 According to that, you've listened to Have You Never Been Mellow far more often than any other song in your collection.Yep. My neighbor insists that it's the first song played when we hang out by his pool, etc. Quote Link to post Share on other sites
Sir Stewart Posted March 16, 2016 Share Posted March 16, 2016 Sweet tune, all told. Quote Link to post Share on other sites
Sir Stewart Posted March 16, 2016 Share Posted March 16, 2016 I made an albums one:https://docs.google.com/spreadsheets/d/1FayWq-lKIJfyP3ogW6TEZrOoQ85DzVNskFy21B47XmE/edit?usp=sharing Quote Link to post Share on other sites
anthony Posted March 19, 2016 Share Posted March 19, 2016 I recently did this for my vinyl on Discogs. Quote Link to post Share on other sites
Vacant Horizon Posted March 20, 2016 Share Posted March 20, 2016 Do y'all import entire albums no matter what, or do you leave out tracks that aren't your favorites? Quote Link to post Share on other sites
PopTodd Posted March 20, 2016 Author Share Posted March 20, 2016 Do y'all import entire albums no matter what, or do you leave out tracks that aren't your favorites?Entire albums, no matter what. Quote Link to post Share on other sites
Vacant Horizon Posted March 20, 2016 Share Posted March 20, 2016 Entire albums, no matter what. Can I ask your reasoning? For me, I always err on the side of 'potentially/eventually' liking the tunes I skip over. Every time I've left off a tune or two, I end up putting it back because I'm wondering about it. As a side note, the whole digital/ipod revolution has really thrown me for a loop. All the formats, players, digital stores that don't have everything, the rise of vinyl. Not sure which direction to go. I've been ruminating on this for years. I'm basically back to CDs only, but also use my iPod to stream stuff via bluetooth in the house. It's hard to argue with the convenience. Luckily, lots of older discs are so cheap these days. Unfortunately, shipping has doubled. Quote Link to post Share on other sites
tinnitus photography Posted March 20, 2016 Share Posted March 20, 2016 I recently did this for my vinyl on Discogs. nice. i have started to do this, but it will take a long time (esp my 7" singles collection...)here it is as a work in progress:https://www.discogs.com/user/narlus/collection Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.