"Export" playlists, songs, etc. into Excel

Heelllpp! For years I've been able to copy and paste iTunes lists into Excel in order to organize them. But now when I paste the information, the column breaks disappear leaving the information "spread" across cells in Excel. So frustrating! Thanks for any help you can offer!!!

MacBook Pro 15″, macOS 10.13

Posted on May 25, 2021 5:43 AM

Similar questions

In iTunes for PC, I wish to add two extra info columns to my library. How do I add these as data input lines/spaces/info fields in the "Get Info" box? In iTunes for PC I have a large library of music. When I want to change or add the same piece of information to several Songs (e.g. Composer's name) I highlight all those Songs and open the "Get Info" box. I can then add the piece of information to the "Composer" data input space just once and it is automatically added to each Song in the "Composer" column in the Library. I have added an extra Info column to my Library from the selection list, "Work", so I can input Catalogue info such as Opus number. But the "Work" column doesn't come up as a data input space in the "Get Info" data box. That means that I have to add the info to every Song individually, in the Library screen, even if it is the same for many Songs. This is significant in a Library of almost 15,000 Songs. How can I add Columns as data input lines/spaces to the "Get Info" data box?
622 6
iTunes Column Alignment/Justification Hi there ~ noticed a funny thing about the columns in iTunes today. In my iTunes, I have some standard columns visible (track #, name, time, artist, album, year, comment, disc #), but of those columns, track #, time, and disc # are all aligned (or justified) to the right of the column, whereas with all of the other columns, they are aligned left. I would like to align ALL of the columns to the left, but couldn't figure out how to. The reason I'd like to do this, is that when you have a right-aligned column followed by a left-aligned column, no matter how wide you make either of those columns, the information from those two columns will be right next to each other, making it visually cluttered. It appears this is something that can't be fixed: that iTunes doesn't give you the option to change the default alignment of the various columns. But if anyone knows how to do this I would really appreciate knowing how. Thanks so much in advance!
553 5
Moved from Itunes to "Music" In my playlist view, where I can see all of the songs in my playlist - I used to be able to drag the slide between the top column of artist and album and genre so I could see more information on the screen. Now I can not adjust the columns, nor can I get genre to show up in the column. Can anyone help me find out how to adjust width to my columns and how to get the genre title back into a column?
526 4

1 reply

ed2345

Level 9

63,584 points

May 25, 2021 11:38 AM in response to MsA96

MsA96,

For me it is working as usual, with columns preserved. In Music, start in songs view, then highlight and copy. In Excel, paste.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

"Export" playlists, songs, etc. into Excel

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up