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

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

Re: Copying from iTunes to Excel

Show all headers | View raw

On 2014-01-12, Michael Vilain <vilain@NOspamcop.net> wrote:
> In article <bje5q5F7vefU1@mid.individual.net>,
>  Jolly Roger <jollyroger@pobox.com> wrote:
>
>> On 2014-01-11, 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?
>> >
>> > System 10.6.8, iTunes 10.7
>> 
>> Works for me with Mac OS X 10.9.1, iTunes 11.1.3, and Excel 14.3.9
>> (Office 2011).
>
> I was able to select all songs in a playlist but could not paste them 
> into Numbers or Excel.  The list isn't delimited by tabs, just spaces. 
> It's not even fixed width.

Without knowing more details about your setup, can't help you.

> When I pasted into BBEdit, it was just a list of songs with lots of 
> spaces between them.  There doesn't seem to be a way to add a delimiter.

Not here. Here, when I paste into TextWrangler, each song is on a single
line, and the columns are tab-delimited (not spaces).

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

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