Visit our other dedicated websites
Asha Bhonsle Geeta Dutt Hamara Forums Hamara Photos Kishore Kumar Mohd Rafi Nice Songs Shreya Ghoshal
Hamara Forums

Welcome Guest ( Log In | Register )

Exporting Playlists From Itunes

 
 
Reply to this topicStart new topic
> Exporting Playlists From Itunes
deewani
post Jan 18 2008, 06:51 AM
Post #1


Dedicated Member
Group Icon

Group: Members
Posts: 3784
Joined: 10-April 05
From: away
Member No.: 2053



A copy of a previous post, folks using other methods and other software are welcome to post their methods.

HOW TO EXPORT PLAYLISTS FROM ITUNES:

I found that you can just copy and paste straight from iTunes now!! biggrin.gif No need to export lists in iTunes and delete extra columns. Just make a new playlist of the stuff you want put in the spreadsheet, exclude columns you don't want right in iTunes, select all, go to edit - copy, and then open a blank workbook in Excel and paste. Exact same fields will be copied there.

If you have older versions of iTunes installed then you can also do it the old way:

iTunes
1. Go to the playlist you want to save in iTunes, highlight it in the "Source" box.
2. File --> Export Song List, in the "Save As" window, you will see the name of your playlist, and you want to save as type: .txt.
You now have a text file of your playlist, however, it contains all the columns available in iTunes by default, and you probably only want a few of them. So next step is Excel.


Excel
1. Launch Excel.
2. File --> Open, change the drop down menu for "Files of Type" to "All Files", browse to the playlist you just saved and "Open."
3. The "Text Import Wizard" window will open, click "Next" on Step 1, 2, and and then click "Finish" on Step 3. This will open the iTunes columns in the spreadsheet.
4. Clicking on the letter of a column will highlight the entire column. We are now going to delete all the columns we don't need, this can be done in one step like this: Highlight the first column you don't want (example "Genre" column), now while holding the CTRL key down, go click on the rest of the columns you don't want. Then right click with the mouse on the highlit columns and choose DELETE.
5. If desired, you can move the remaining columns around by inserting extra columns, copying and pasting the the columns you want in the appropriate slots. (You can also, for example, make an entire column (like the album names) show up in bold if that's what you want. I usually insert an extra column in front of and in back of the Year column to space it.
6. File --> Save As, under the drop down menu for "Save as Type", choose Web Page, this saves it as html and you now have a published playlist, from which you can copy and paste, or you can create a screenshot of it to share. DONE!

So that's it - that gives me a list, someone had asked me how I make it look like the one in my playlist thread - well, I just take a screenshot of the list, throw in photoshop, crop it, reduce the size a bit and host it on an image hosting site.









---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Some hints for Excel:

Auto Column Width: Double-click the boundary to the right of the column heading tab (this also works inside the iTunes program itself)
To do this for all the columns on the worksheet, click the Select All button, and then double-click the boundary to the right of ANY column heading tab.

Numbering A List:
Unlike other Microsoft Office programs such as Microsoft Word, Microsoft Excel does not provide a button to automatically number data. However, you can easily add sequential numbers to rows of data by filling a column with a series of numbers or by using the ROW function.
INSERT BLANK COLUMN FIRST to the left of your current first column (Insert --> Column).

Fill a column with a series of numbers
Note: These numbers are not automatically updated when you add, move, or remove rows. You can manually update the sequential numbering by selecting two numbers that are in the right sequence, and then dragging the fill handle to the end of the numbered range.
1. Select the first cell in the range that you want to fill.
2. Type the starting value for the series.
3. Type a value in the next cell to establish a pattern. How?
For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4.
4. Select the cells that contain the starting values.
5. Drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer
changes to a black cross.) Selected cell with fill handle across the range that you want to fill.
To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.
Is the fill handle missing?
To display the fill handle on a selection of cells, click Options on the Tools menu, click the Edit tab, and then select the Allow cell drag and drop check
box.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------







Getting Album List Only from iTunes
This from a genius poster at iLounge

iTunes
1. Go to the playlist you want to save in iTunes, highlight it in the "Source" box, in this case highlight your library.
2. File --> Export Song List (not Export Library) in the "Save As" window, you will see the name of your music library, and you want to save as type: .txt.
You now have a text file of your entire music library, however, it contains all the columns available in iTunes by default, so next step is Excel.

Excel
1. Launch Excel.
2. File --> Open, change the drop down menu for "Files of Type" to "All Files", browse to the library list you just saved and "Open."
3. The "Text Import Wizard" window will open, click "Next" on Step 1, 2, and and then click "Finish" on Step 3. This will open the iTunes columns in the spreadsheet.
4. Clicking on the letter of a column will highlight the entire column. We are now going to delete all the columns except for the Album Name column: this can be done in one step like this: Highlight the first column you don't want (example "Genre" column), now while holding the CTRL key down, go click on the rest of the columns you don't want. Then right click with the mouse on the highlit columns and choose DELETE.
5. Data --> Filter --> Advanced Filter. In the Advanced Filter window, choose the Album Column as the List Range (in other words, once this window is open, go highlight your Album Column with the mouse. Now check the "Unique Records Only" box. Click OK.
6. Highlight the Album Column now, and then Edit --> Copy (we are gonna copy the list into a new worksheet).
7. File --> New (blank workbook), then Edit --> Paste.
8. Save file as an excel file and you have a list you can play with, or publish it (see instructions above for playlists).


Doston, Apna Tau Yeh Imaan Hai
Jo Bhi Jitna Saath De, Ehsaan Hai
Umr Ka Rishta Jodne Waale
Apni Nazar Mein Deewane Hai

Thanks for the memories HF. Bye Bye.
deewani is "permanently away"





User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:


 



- Lo-Fi Version | Disclaimer | HF Guidelines | Be An Angel Time is now: 29th March 2024 - 08:20 PM