Excel to csv.


I have an Excel file with 12 email addresses separated by commas and one space, in one row. I have to get this in to a website in the csv format. I'v e done this a few times, in different ways. and it is always seen, by the site as a single entity, instead of 12 email addresses. The emails are all from craigslist; .org. Is there an approach that will work dependably?


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Katie PierceCommented:
Do you mean they're all in one cell?
pubbuddyAuthor Commented:
Katie PierceCommented:
Highlight cell, click the Data tab at the top, click Text to Columns, select Delimited and choose the comma as the separator. This should put each entry into a different column.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

If Katie's technique doesn't work for you, please post some sample data.  You might need to get rid of the space characters after the commas before you do the text-to-columns operation.
Jerry PaladinoCommented:
Perhaps the web site you are uploading to needs the email addresses on separate lines.  If so, try these steps:
1.  Replace all space characters in the string of emails addresses as aikimark suggests
2.  Use DATA / "Text to Columns" as Katie suggests above to put the email addresses in 12 separate cells
3.  Highlight the 12 cells and Copy
4.  A row down, Paste Special Transpose to put the values in 12 rows
5.  Delete the original row so you are only left with the 12 rows of emails
6.  File Save As CSV
pubbuddyAuthor Commented:
O. K.
If I start off, in Excel, with each email in its own cell, followed by a comma, and save it as a comma delimited csv file, should that do it?

Katie PierceCommented:
No comma, just the email address.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.