Skip navigation

Export or Copy/Paste list of iPad apps from iTunes?

11498 Views 4 Replies Latest reply: Mar 22, 2014 6:03 PM by kolblj RSS
Billbillbill Calculating status...
Currently Being Moderated
Oct 1, 2010 10:42 AM
Hello,

Could someone please tell me how to export or copy (for pasting) to an excel spreadsheet? I can't seem to be able to do either.


Here's what I've done so far:

After ensuring that I've got copies of my iPad purchased/downloaded apps on iTunes on my PC (by right-clicking on the iPad icon in the library and selecting "Transfer Purchases"), I then can see the entire list by selecting Library/Apps. Two things I've tried are:

1. Menu/Edit/Select All. Unfortunately the 'copy' command on that same menu is greyed out for some reason.

2. Menu/File/Library/Export Library... Anything I've read on this says that I should be able to export to a text file. Unfortunately, the only option I'm given is to export as an .xml file, which is unreadable in that form by Excel. I am using iTunes version 10, so maybe I lost the ability to export to text when I upgraded, I don't know.

In any case, I'd like to be able to get my current list of ipad apps onto my excel spreadsheet so that I can keep track of other things that aren't available to me from within the iTunes program.

Can someone please help?

Thanks
iPad
  • KumbiaKid Level 1 Level 1 (0 points)
    You didn't say what type of computer you're using. If you're using a Windows PC, you can get a list of apps suitable for import into Excel by setting up a text only printer and setting it to print to a file. See Windows help or search the net for steps. If you can't find the steps, let us know what operating system you're using and I'll see if I can give you step-by-step instructions for setting it up.

    Once you've got the printer set up, go to iTunes and display your apps in list format. You can choose the columns you want and the order you want them in (within limits -- you won't have complete freedom to choose). Then select print from the File menu and in the Print "Apps" dialog, select "Song Listing" (yes, it's weird to select "Songs" when you're printing apps, but that's what's there). Then in the "Theme" drop-down, select "Custom". Then click the "Page Setup" button and select Landscape (otherwise you'll get lots of unnecessary word wrapping). Next, click “OK” in the Print “Apps” dialog which will take you to the normal Windows print menu. In that menu, select the text-to-file printer you set up before and click “OK”. You’ll be prompted for a file name for the output file. I suggest you use “.txt” as the extension (e.g., “applist.txt”). Click “OK” and your app list will be created. Where the file goes depends on how you set up your text-to-file printer – mine goes to the desktop. These steps are with WinXP – steps may vary a bit if you’re using another version of Windows. If you’re using a Mac, I can’t help. Good Luck!
    Windows XP Pro
  • mdevarasetty Calculating status...
    Currently Being Moderated
    May 15, 2012 10:22 AM (in response to KumbiaKid)

    Posting an easier solution, in case any one needs it in future.

     

    Find the directory path where the App's IPA file is stored and simple go to command prompt and list (ls in MAC and dir in windows) pipe the output to text file.

     

    on my MAC:

    ls "/<userhome/Music/iTunes/iTunes Music/Mobile Applications"/ > Appslist.txt

  • SusanCnett Calculating status...

    Thanks for this! It pasted nicely into Word and Excel.

     

    One slight difference... on my MAC the path is:


    "/<userhome/Music/iTunes/Mobile Applications"/ > Appslist.txt

  • kolblj Calculating status...

    I highlight, clicked print, selected songs, and saved as .pdf.

    Thanks for the help!

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.