Skip to main content ↑ ↓

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Topic: Exporting playlist to a spreadsheet (Read 6601 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Exporting playlist to a spreadsheet

Is there any way to export a playlist as a csv file, or anything else that I can import to a spreadsheet?

Tagscanner was recommended to me, but it doesn't recognise .fpl files.

Exporting playlist to a spreadsheet

Reply #1 –
You can do this in foobar.

Text Tools component (Preferences > Tools > Text Tools, then Utils > Text Tools > Advanced...), or the deprecated Copy command (Preferences > Advanced > Display > Legacy title formatting scripts, then Utils > Copy Names).

IIRC there is also foo_utils.
I'm on a horse.

Exporting playlist to a spreadsheet

Reply #2 –
foobar's playlists let you export whatever info (field) you want to spreadsheets in .csv.

foo_textool is most handy as syntetic soul mentioned

use for example:

%artist%,%date%,%album%,%discnumber%,%tracknumber%,%title%,%genre%,%comment% and so on.
In Calc (openoffice.org's excel) you can paste the clipboard into a page and there you go, splitted values!

Exporting playlist to a spreadsheet

Reply #3 –
Quote from: Synthetic Soul on
You can do this in foobar.

Text Tools component (Preferences > Tools > Text Tools, then Utils > Text Tools > Advanced...), or the deprecated Copy command (Preferences > Advanced > Display > Legacy title formatting scripts, then Utils > Copy Names).

IIRC there is also foo_utils.


Preferences > Tools just gives me the message "please select a subpage"

With the other method I get as far as the 'Legacy title' bit, but then I can't see Utils etc.

Downloaded Utilities (foo_utils) 0.6.2 beta 6, but have now got a dll file I don't know what to do with.

Sorry

Exporting playlist to a spreadsheet

Reply #4 –
Quote from: Mar2zz on
foobar's playlists let you export whatever info (field) you want to spreadsheets in .csv.


Could you possibly tell me how? I'm afraid I don't understand a word of the rest of your post, sorry.

Exporting playlist to a spreadsheet

Reply #5 –
Maybe Text Tools is an optional part of the foobar install.

If you select all relevant files and right-click to view context menu, you would see "Utils > Copy Names".

The DLL should go in your "components" folder (most likely "C:\Program Files\foobar2000\components").  Drop it in there with foobar closed, open foobar and it will be active.  foo_utils ("Playlist Tools") will create the "Tools > Text tools" dialogue in Preferences.  It can then be used from the context menu, using "Text Tools > Copy Text".

Edit: Ah, I see Text Tools is actually an additional foobar component, available from the foobar download page.
I'm on a horse.

Exporting playlist to a spreadsheet

Reply #6 –
texttools lets you export fields (tags or metadata) to clipboard. You can define fields to be exported yourself, make sure you put a "," comma between al fields you need (see my example).

Then, if you really want a .csv file, open up notepad after you used texttools, paste (CTRL+V) into notepad and save the file as nameofchoice.csv.
Go to excel or whatever spreadsheet-program you use (I recommend the free Calc from Openoffice.org) and open the file.

Saving to a file is not really necessary, as you can paste it into a new spreadsheet too, but I don't know if excel will split the values automatically, Calc does this for sure, as I tested it).

Exporting playlist to a spreadsheet

Reply #7 –
Thanks to you both - that's done just what I'm looking for 
 

Re: Exporting playlist to a spreadsheet

Reply #8 –
Quote from: Mar2zz on
foobar's playlists let you export whatever info (field) you want to spreadsheets in .csv.

foo_textool is most handy as syntetic soul mentioned

use for example:

%artist%,%date%,%album%,%discnumber%,%tracknumber%,%title%,%genre%,%comment% and so on.
In Calc (openoffice.org's excel) you can paste the clipboard into a page and there you go, splitted values!

Good morning,
I can't do this manipulation.
I created a 'custom column' called "duration2" with the pattern %length_seconds_fp%
The field Duration2 is OK in Foobar2000..
My end goal is to get a CSV file like this:
audio_file_name_1, duration_1
audio_file_name_2, duration_2
audio_file_name_3, duration_3
etc (with duration expressed with milliseconds)

I go in Preference / Advanced, and I modify the field "COPY COMMAND" :
[%list_index%. ][%duration2% - ]['['%album%[ CD%discnumber%][ #%tracknumber%]']' ]%title%

Unfortunately, when I do a copy / paste in NotePad++ for example, it never give me the duration2 values....

EDIT : I found the solution.
In COPY COMMAND : [%title%, ][%length_seconds_fp%]