Create a playlist from list of song titles?

[sean]

Would it be possible to somehow create a playlist from a csv file that contains song titles only?
I know all the songs are in the library, but the csv doesn't contain the absolute paths.

[sean]

I just accomplished this using Google Sheets.

I put all the titles of the tracks I want in my playlist in column A. I put the paths of all my available tracks in column C.

In column B, I put =VLOOKUP("*"&A1&"*", C:C, 1, FALSE).

This gave me a list of the full paths of all the tracks I wanted based on the titles in col A.

[MattTown]

Creating a playlist from an import file requires that the import file list the absolute file paths of the songs (eg E:\10cc\Bloody Tourists\Dreadlock Holiday.mp3). I routinely do this by getting path text for the library files from a report via:

• selecting the files I want paths for then

• getting a report via Menu > File > Reports > File list and making sure that the Path column is included in the report. I use the CSV option to make this report easy to suck into Excel for selection processing.

• The net result of my selection processing in Excel is a text file (eg newplaylist.txt) which just lists the text of the path for each song intended for the playlist, one path per line.

• I rename this text file to have a .m3u file extension (eg newplaylist.m3u), which MM can recognise as a playlist format.
  In MM, I use Menu > File > Add/Rescan files to the Library and constrain the process to look only at the location where the .m3u file is located (just so MM doesn't waste a bunch of effort rescanning places that don't need it).

• MM then finds the .m3u file, and adds the songs referenced by the paths to a new playlist with the name of the .m3u file (eg newplaylist). The post-import message can be a bit misleading, but if you look closely it will say "one file imported".

• MM puts the new playlist into a top level playlist folder called "Imported Playlists", so open that to find your new playlist and use drag and drop to relocate it wherever you want in your MM playlist hierarchy.

Cheers
Matt