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

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

Re: Copying from iTunes to Excel

Show all headers | View raw

In article <bje9nqF8k9cU1@mid.individual.net>,
 Jolly Roger <jollyroger@pobox.com> wrote:

> 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).

I'm running 10.8.5 with iTunes 11.1.3 and Excel 14.3.9.  Pasting into 
Excel worked.  Pasting into Numbers 2.3 did not work.

I'm not the OP, just verifying behavior they might see.

-- 
DeeDee, don't press that button!  DeeDee!  NO!  Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]

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