Convert from XLS to CSV 2

[PAWelch]

I have little experience with Excel. Boss needs a list of email addresses but with commas so he can cut and paste a slew of addresses into email address box and shoot out a meeting announcement.

I've got all the email addresses in one column of an Excel spreadsheet. I tried to SAVE AS a csv file but it still looks like an Excel sheet.

What am I doing wrong? Thanks!

 

[SkipVought]

NOTHING! That's exactly what to do.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[PAWelch]

I need it to come back like:

joejones@marny.com,suzyq@marny.com,pbrain@marny.com....

But this thing looks just like a spreadsheet. So where are the commas? I've searched the forum here, MS Help... argh!

 

[SkipVought]

open your csv in NOTEPAD and see.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[PAWelch]

I opened it up using NOTEPAD and "all files" as only choices are that and .txt. It looks like a list, no commas.

 

[SkipVought]

One Column or Multiple Columns.

It is the COLUMNS that are separated by COMMAS, in a csv.

The ROWS are separated by carriage return/line feed.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[PAWelch]

All email addresses are in one column. Which now explains why it's in "list" formation. (I really need less coffee in my day...)

Any suggestions on what to do when all the data is in one column?

I appreciate your grace with my lack of knowledge. Thank you.

 

[HarleyQuinn]

This solution sounds a bit too easy but here goes anyway. Open it in Excel, tag a comma on the end of each row but the last (using a formula, copy and then paste values so you get the actual data you want) and then just copy all the addresses in the column and paste into the To: box, seems to work for me.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

Oops, forgot to say to replace comma's with semi-colons in your formula if you're using outlook or it won't like it...

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[xlbo]

If all the data is in one column, seperated by commas:

Highlight Column
Data>Text to Columns
Choose "," as delimeter

This will split the data into individual columns

THEN:

File>Save As> .csv

THEN open in Notepad to check

That should do ya !

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnotherHiggins]

I think this is what you're looking for:

[tab]- In Excel, copy the column of addresses.

[tab]- Right click in Row 1 of another, empty, column. Paste Special > Transpose.

[tab]- Delete column A.

[tab]- SaveAs .csv.

Note: unless you have Excel 2007, Excel only 256 columns. If you have more addresses than that, you will need to break it up in multiple rows.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

WOW! Lookit all the good suggestions you got!

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[PAWelch]

Both suggestions look doable for my not-so-nimble brain. Thank you so much!

 

[HarleyQuinn]

*cough* three suggestions...

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[SkipVought]

Three, but all within the space of 8 minutes!!! Like a gatlin gun, they roared in!!!!

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[HarleyQuinn]

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PAWelch]

Yessir! Three! You had #3 up there before I could finish my "thank you". Quick on the draw! Thank you, Harley.

 

[SkipVought]

PA,

Don't forget to thank Harley with one of them there purply, pointy thangs.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[Gavona]

You can of course just select the cells containing the email addresses in excel. Copy. Then paste into outlook.

Is there really a business need for your CSV file?



Gavin

 

[HarleyQuinn]

Thanks for the star, and thanks Skip

Gavin, that's pretty much exactly what I said 4 hours previously...

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.