Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.system > #54631

Re: Copying from iTunes to Excel

Show all headers | View raw

On 2014-01-12 14:37:25 +0000, Don Tuttle <Don@noplace.net> said:

> In article <110120141825525328%Don@noplace.net>, Don Tuttle
> <Don@noplace.net> wrote:
> 
>> Seems to me I used to be able to click on a tune in an iTunes playlist,
>> Select All (with Command-A), Copy, and Paste the playlist into Excel.
>> Now I cannot Select All either with the keyboard command or from the
>> menu. If I select the first tune in the playlist, then Shift-Click on
>> the last tune, then try to Copy, the Copy command is greyed out, so I
>> can't copy.
>> 
>> How can I get an iTunes playlist into Excel? Or is this possible?
>> 
>> Help appreciated. Thanks.
>> Don
>> 
>> 
>> 
>> System 10.6.8, iTunes 10.7
> 
> I am OP. Thanks for all help and comment. What happened seems not to
> have had anything to do with iTunes or Excel. In what I was trying to
> do, Select All just quit working, and Copy didn't work either. I
> restarted, both functions resumed their normal operation, and the
> playlist pasted into Excel.
> 
> Thanks Savageduck for suggestion to obtain formatted printout of
> playlist by printing as a "Song list" and choosing the "Save as PDF"
> option, which will come in handy in the future.
> 
> Re do I have a specific reason for importing into Excel, I want to
> create a document which, for a particular artist, lists albums only,
> not individual tunes. I used to know how to do that in Excel and hope
> to remember, now that my playlist has been pasted into Excel.
> 
> Don

If you select the "print album list" from iTunes what you will get is 
the album cover, the artist, and a list of the songs from that album 
found in the play list. There is no option to drop the songs. So it 
will look like this:
< https://dl.dropbox.com/u/1295663/FileChute/Road%20%234%20A.pdf >


-- 
Regards,

Savageduck

Back to comp.sys.mac.system | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Copying from iTunes to Excel Don Tuttle <Don@noplace.net> - 2014-01-11 18:25 -0500
  Re: Copying from iTunes to Excel Michelle Steiner <michelle@michelle.org> - 2014-01-11 17:22 -0700
  Re: Copying from iTunes to Excel Jolly Roger <jollyroger@pobox.com> - 2014-01-12 00:26 +0000
    Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 16:53 -0800
      Re: Copying from iTunes to Excel Jolly Roger <jollyroger@pobox.com> - 2014-01-12 01:33 +0000
        Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 20:10 -0800
          Re: Copying from iTunes to Excel Michelle Steiner <michelle@michelle.org> - 2014-01-11 21:22 -0700
            Re: Copying from iTunes to Excel Jolly Roger <jollyroger@pobox.com> - 2014-01-12 04:50 +0000
              Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 22:36 -0800
                Re: Copying from iTunes to Excel Michelle Steiner <michelle@michelle.org> - 2014-01-12 00:12 -0700
                Re: Copying from iTunes to Excel Michael Vilain <vilain@NOspamcop.net> - 2014-01-11 23:32 -0800
  Re: Copying from iTunes to Excel Savageduck <savageduck1@{REMOVESPAM}me.com> - 2014-01-11 18:31 -0800
  Re: Copying from iTunes to Excel Don Tuttle <Don@noplace.net> - 2014-01-12 09:37 -0500
    Re: Copying from iTunes to Excel Savageduck <savageduck1@{REMOVESPAM}me.com> - 2014-01-12 07:53 -0800
  Re: Copying from iTunes to Excel Alan Browne <alan.browne@FreelunchVideotron.ca> - 2014-01-12 11:11 -0500

csiph-web