Skip navigation

can you import an excel list of songs as a playlist?

1281 Views 15 Replies Latest reply: Jul 19, 2013 10:46 AM by turingtest2 RSS
1 2 Previous Next
townerboy Calculating status...
Currently Being Moderated
Jul 15, 2013 6:36 AM

hi

i have a list of songs, currently in excel, that i woudl like to import into iTunes, and have them show up as a playlist.  does anyone know if thsi is possible?

 

i can convert the list into word, text etc, and i suppose i can convert them into a format that itunes woudl understand, I jsut don't know how to.the backgound is that i have tracklists for a dj set that I want to recreate as a playlist.  also I know that I have all of the thsese tunes in my iTunes, but it woudl be quite a job to actually go through and locate them

 

thanks!

  • christopher rigby1 Level 4 Level 4 (2,070 points)

    Unfortunately not. iTunes uses its own internal Library files to create and monitor playlists - it's a kind of database of its own, which it links to all your music etc.

     

    I had this problem once, when all my music was catalogued in FileMaker Pro, and when I started using iTunes extensively I wanted to get all that data in there. But in the end I had to swallow the pill and do it all manually.

  • turingtest2 Level 8 Level 8 (43,860 points)

    Hmm... this ought to be possible if the spreadsheet contains the full paths to the files in a column called Location. Try making a small test playlist, exporting as text, then importing it again. I'm new to Mac and playing around with Numbers I can't quite seem to get an edited and reexported playlist in quite the right layout for iTunes to be happy reimporting but I suspect I stripped out too much or need to tweak the export to text options.

     

    tt2

  • Chris CA Level 9 Level 9 (73,360 points)

    Save the file as a .csv and import into iTunes and see what happens.

  • Chris CA Level 9 Level 9 (73,360 points)

    turingtest2 wrote:

     

    Hmm... this ought to be possible if the spreadsheet contains the full paths to the files in a column called Location. Try making a small test playlist, exporting as text, then importing it again. I'm new to Mac and playing around with Numbers I can't quite seem to get an edited and reexported playlist in quite the right layout for iTunes to be happy reimporting but I suspect I stripped out too much or need to tweak the export to text options.

     

    tt2

    I'll have a go at it out later tonight.

  • Chris CA Level 9 Level 9 (73,360 points)

    I exported a playlist as plain text.

    Opened it in Numbers and everything is there.

    I saved it out as .CSV but alas, it would not open.

    Looks like it needs to be a TAB separated values.

     

    I copied the table, then open TextEdit and pasted it into a blank document.

    Saved as plain text and it then imported into iTunes just fine.

     

    Looks like you need all the column names from iTunes as the column header.

    Name, Artist, Composer, Album, Location, etc.

    Export a playlist from iTunes and copy the first row then paste in your spreadsheet.

  • Chris CA Level 9 Level 9 (73,360 points)

    but the lsit I have  isnt in the standard playlist form. it only has name,artist, album all within the same cell on Excel.

    To do anything with this list, you will need to break this info up into individual cells.

     

    Do you have these songs already in iTunes?

    If not, you can create a regualr playlist, then drag the songs from the Finder window directly to the playlist name. This adds them to iTunes and the playlist at the same time.

  • turingtest2 Level 8 Level 8 (43,860 points)

    I doubt you need to fill in the details, but it seems you must have the correct headings in place if iTunes is going to import it. I don't have time to test it myself just now, but blank columns apart from the location would, I assume, not stop it working, nor edit the tags of the imported tracks.

     

    tt2

  • turingtest2 Level 8 Level 8 (43,860 points)

    Ah right, yes, you have to have the location as minimum information. Assuming unique song names it ought to be possible to export the current contents of the library, create a lookup table for song name to location, and then merge that data back into your original list. Likely there are at least some duplicate song names which will make it a bit harder to get right, but it should stil be possible.

     

    tt2

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.