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

Groups > comp.sys.mac.system > #54587 > unrolled thread

Copying from iTunes to Excel

Back to article view | Back to comp.sys.mac.system

Contents

  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

#54587 — Copying from iTunes to Excel

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

[toc] | [next] | [standalone]

#54589

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.

It's not greyed out on my system; I can copy it and paste it into
Numbers.  iTunes 11.1.3

[toc] | [prev] | [next] | [standalone]

#54591

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

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

[toc] | [prev] | [next] | [standalone]

#54596

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.

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.

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

[toc] | [prev] | [next] | [standalone]

#54598

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

[toc] | [prev] | [next] | [standalone]

#54606

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]

[toc] | [prev] | [next] | [standalone]

#54607

In article <vilain-52245A.20105111012014@news.individual.net>, Michael
Vilain <vilain@NOspamcop.net> wrote:

> 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 running 10.9.1 with Tunes 11.1.3, and Numbers 3.0.1.  It works with
this version of Numbers:

<https://www.dropbox.com/s/gf2939rxgxoahdr/iTunes%20export.pdf>

[toc] | [prev] | [next] | [standalone]

#54609

On 2014-01-12, Michelle Steiner <michelle@michelle.org> wrote:
> In article <vilain-52245A.20105111012014@news.individual.net>, Michael
> Vilain <vilain@NOspamcop.net> wrote:
>
>> 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 running 10.9.1 with Tunes 11.1.3, and Numbers 3.0.1.  It works with
> this version of Numbers:
>
><https://www.dropbox.com/s/gf2939rxgxoahdr/iTunes%20export.pdf>

It should import into any spreadsheet application that accepts
tab-delimited data.

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

[toc] | [prev] | [next] | [standalone]

#54619

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

> On 2014-01-12, Michelle Steiner <michelle@michelle.org> wrote:
> > In article <vilain-52245A.20105111012014@news.individual.net>, Michael
> > Vilain <vilain@NOspamcop.net> wrote:
> >
> >> 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 running 10.9.1 with Tunes 11.1.3, and Numbers 3.0.1.  It works with
> > this version of Numbers:
> >
> ><https://www.dropbox.com/s/gf2939rxgxoahdr/iTunes%20export.pdf>
> 
> It should import into any spreadsheet application that accepts
> tab-delimited data.

When I select and copy the selected tracks to a text editor like BBEdit 
and look at the pasted text, it's delimited by spaces, not tabs.  If I 
paste the contents of the clipboard into Excel, it works fine.  If I 
paste into the first cell of Numbers, it displays the text of the first 
line of the paste buffer in the first cell, but that's it.

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

[toc] | [prev] | [next] | [standalone]

#54620

In article <vilain-18C395.22362811012014@news.individual.net>, Michael
Vilain <vilain@NOspamcop.net> wrote:

> When I select and copy the selected tracks to a text editor like BBEdit 
> and look at the pasted text, it's delimited by spaces, not tabs.  If I 
> paste the contents of the clipboard into Excel, it works fine.  If I 
> paste into the first cell of Numbers, it displays the text of the first 
> line of the paste buffer in the first cell, but that's it

When I paste it into TextWrangler, Pages, or TextEdit (in plain text
mode), the pasted text is tab delimited.  When I paste it into TextEdit
(in RTF mode) or mail.app (in either text or RTF mode), the tracks
themselves are pasted, and can be played from within the document.

[toc] | [prev] | [next] | [standalone]

#54622

In article <120120140012444284%michelle@michelle.org>,
 Michelle Steiner <michelle@michelle.org> wrote:

> In article <vilain-18C395.22362811012014@news.individual.net>, Michael
> Vilain <vilain@NOspamcop.net> wrote:
> 
> > When I select and copy the selected tracks to a text editor like BBEdit 
> > and look at the pasted text, it's delimited by spaces, not tabs.  If I 
> > paste the contents of the clipboard into Excel, it works fine.  If I 
> > paste into the first cell of Numbers, it displays the text of the first 
> > line of the paste buffer in the first cell, but that's it
> 
> When I paste it into TextWrangler, Pages, or TextEdit (in plain text
> mode), the pasted text is tab delimited.  When I paste it into TextEdit
> (in RTF mode) or mail.app (in either text or RTF mode), the tracks
> themselves are pasted, and can be played from within the document.

I'm on 10.8.5.  I just tried it again with a different playlist.

This selection of 158 songs came out as tab delimited in BBEdit.
Pasting into Numbers 2.3 allowed for the first field of the first line 
to paste into the first cell.

Opening the BBEdit tab-separated txt file into a new sheet worked in 
Numbers 2.3.

I have no idea what the OP is struggling with. It "works for me".

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

[toc] | [prev] | [next] | [standalone]

#54602

On 2014-01-11 23:25:52 +0000, Don Tuttle <Don@noplace.net> said:

> 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

Are you just trying to get a formatted printout of a play list, or do 
you have a specific reason for importing into Exel?

If I need a printable format of a playlist to share I highlight the 
first song in the list, select all (command+A) then print as a "Song 
list" and choose the "Save as PDF option.
That will get me this sort of result.
< https://dl.dropbox.com/u/1295663/FileChute/Road%234.pdf >

-- 
Regards,

Savageduck

[toc] | [prev] | [next] | [standalone]

#54630

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

[toc] | [prev] | [next] | [standalone]

#54631

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

[toc] | [prev] | [next] | [standalone]

#54633

On 2014.01.11, 18:25 , Don Tuttle 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?

No problem here.

iTunes 11.1.3 (8) (Mac OS X Mavericks)
Excel 12.3.3 (Office 2008 for Mac)

-- 
“Everybody has a plan until they get punched in the face.”
                                                   - Mike Tyson

[toc] | [prev] | [standalone]

Back to top | Article view | comp.sys.mac.system

csiph-web