converting m3u files to excel or word

[meddlecascade]

hi --

i'm a newbie here, so forgive me if this is a repeat but couldn't find this question addressed anywhere on the site or elsewhere online.

can anyone tell me if it's possible to export an m3u playlist into something readable like an excel or word/RTF format?

my specific situation is that i've made about 20 discs of music for an ongoing dance event, and i want to be able to:

1. look at all the songs i've used at a glance so that i don't repeat myself on upcoming mixes

2. print out track lists for the CDs so that i know what's on them


any thoughts are greatly appreciated.


cheers -- meddle

[Sawg]

M3U files are just text files. You can open them in Word and then pretty them all up (just don't save it as a M3U again)

[meddlecascade]

Originally posted by Sawg
M3U files are just text files. You can open them in Word and then pretty them all up (just don't save it as a M3U again)

thanks so much for the kind tip. don't i feel silly...:igor:

[j7n]

If I had a really long playlist, and I wanted to analyze it in Excel with graphs and sorting, here's what I would probably do:

- load the list in a plain text editor with search & replace capability and regular expressions
- apply seach & replace so that the file ends in CSV (comma separated values) format with time, artist, title, and file path each separated by a comma, and each string enclosed in quotes
- load it in Excel
- if need be, convert the length in seconds to H:M:S format using =TIME(0,0,SOURCE)

[homes32]

or you could just load it into the playlist editor and <CTL-ALT-G> to have Winamp make you a nice pretty HTML playlist that can be printed or exported to Excel (via right click menu) or a program of your choosing.