Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

0 points

Compilation discs > iTunes > iPod

I want to import 100 compilation discs to iTunes so I can load them on my iPod.
Naturally the track names and artists don't come in on the import.
I have the track and artist information for each disc in EXCEL files and in "Surething" disc labeling files.
+*Is there a way to use either of theose file types to populate track and artist information in iTunes after the import completes?*+
Typing the information or cutting and pasting individual track information from Excel to iTunes is not appealing.

iPod 160G Classic, Windows 7

Posted on Mar 29, 2010 9:39 AM

17 replies

turingtest2

Level 10

272,881 points

Apr 2, 2010 6:30 AM in response to likeisaid

In Excel you need a formula along the lines of:

="Track(" & ROW(A2)-1 & ")=""" & A2 & "\" & B2 & """"

assuming the first Track Name is in cell A2 and the first Artist is in B2. The -1 corrects the index number and can be changed if your first cell is on another line, or you can pick up this number from a track number column if you have one. Once the first cell is correct replicate down to generate equivalent formulae for each row. This text should then copy & paste easily into TagFromTable.

tt2

jadamasa

Level 1

8 points

Apr 25, 2010 6:01 AM in response to turingtest2

I dont want to shanghai this thread, but if someone would kindly take the time to have a look at my question about MusicBrainz Picard and the Cover Art Download plugin I would really appreciate it.

Thanks in advance:)

Message was edited by: mabaraska

Compilation discs > iTunes > iPod