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.
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 (http://foosion.foobar2000.org/components/?id=utils&version=0.6.2+beta+6).
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!
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 (http://foosion.foobar2000.org/components/?id=utils&version=0.6.2+beta+6).
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
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.
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 (http://www.foobar2000.org/?page=Download).
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).
Thanks to you both - that's done just what I'm looking for
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%]