INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Copying Artist/Album to Excel or other spreadsheet  (Read 1564 times)

okvaal

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 399
  • Appreciate your life
Copying Artist/Album to Excel or other spreadsheet
« on: July 24, 2013, 04:58:52 am »

is that possible? The reason why I want to do this, is that I'd like to make a complete list of all the music I've got, vinyl, CD and mp3s.
Logged

csimon

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 1686
Re: Copying Artist/Album to Excel or other spreadsheet
« Reply #1 on: July 24, 2013, 04:45:39 pm »

I'm sure this is possible and seen references to it before, try searching in the forums for "export to excel".  There is also this Wiki article: http://wiki.jriver.com/index.php/Export_Playlists

And I've also quickly tried it myself via Windows copy-and-paste, i.e. you get a file listing in the content pane with the columns that you require, select them all, then CTrl-C. You can then paste that into a text file and it becomes tab-delimited, which you can then import into a spreadhseet.
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Copying Artist/Album to Excel or other spreadsheet
« Reply #2 on: July 24, 2013, 04:55:29 pm »

You can paste directly into the spreadsheet - no middleman required.
Logged
The opinions I express represent my own folly.

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Copying Artist/Album to Excel or other spreadsheet
« Reply #3 on: July 24, 2013, 06:11:05 pm »

You can start with creating a smartlist that shows only the necessary data.

Here is what I use for creating an album list:

.

[Media Type]=[Audio] ~limit=-1,1,[Filename (path)] ~sort=[Album Artist (auto)],[Date],[Album]

The rule shows only a single track from each album (it works correctly when each album is in a separate folder.)

I have set the list to show only three relevant columns. Only these fields are included when I copy the list to a spreadsheet ( click the list pane > Ctrl+A > Ctrl+C > switch to Excel > Ctrl+V ):




Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

Arindelle

  • Citizen of the Universe
  • *****
  • Posts: 2772
Re: Copying Artist/Album to Excel or other spreadsheet
« Reply #4 on: July 25, 2013, 04:05:17 am »

+1 Alex B, I do the same thing.

For info you can also create a smart list like this then export it in csv or html for other uses.

Can't find the post, but there is a good one if you dig a bit to create dummy entries for your vinyls which you could then also export in this manner and/or have them catalogued through MC

EDIT: was just under my "nose" http://yabb.jriver.com/interact/index.php?topic=82202.0
Logged

okvaal

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 399
  • Appreciate your life
Re: Copying Artist/Album to Excel or other spreadsheet
« Reply #5 on: July 25, 2013, 05:07:24 am »

Thanks a lot to all of you. Yes, I was pretty sure I had seen this topic too, but couldn't find what I was looking for. This was even better!  :)
Logged

Arindelle

  • Citizen of the Universe
  • *****
  • Posts: 2772
Re: Copying Artist/Album to Excel or other spreadsheet
« Reply #6 on: July 25, 2013, 05:59:41 am »

Code: [Select]
[Media Type]=[Audio] [File Type]=[fla],[flac] ~nodup=[Album Artist /(auto/)],[Album] ~sort=[Album Artist (auto)],[Album Artist],[Album],[Groupings],[Genres] ~limit=-1,1,[album]
@okvaal - might want to look at mine too. I tried Alex B's smartlists on my library and I have too many multiple CDs in subfolders -- I'm using Album and not path/ plus this removes possible dupes.

you have to remove the File Type= .... if you want all formats in your library
Logged

okvaal

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 399
  • Appreciate your life
Re: Copying Artist/Album to Excel or other spreadsheet
« Reply #7 on: July 25, 2013, 06:05:12 am »

Thanks, Arindelle. I'll have a look at this this afternoon. (Summer holiday, and it's too hot to think right now. In Norway, that is  :P )
But I definitely seem to be getting what I want/need know. I'll try these solutions and your File Type notification will probably be of some use.
Thanks again.
Logged
Pages: [1]   Go Up