How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Jason Jones Your Own Question
Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 16040
Experience:  Over 10 years work experience.
Type Your Microsoft Office Question Here...
Jason Jones is online now
A new question is answered every 9 seconds

importing a list of e-mails from word (a single word doc with

Resolved Question:

importing a list of e-mails from word (a single word doc with every email separated by a comma) and i need to make a CSV file.

Importing to Excel makes each email a new column, not a new row
need it in rows (one column) for a CSV to import to mail chimp/

Submitted: 3 years ago.
Category: Microsoft Office
Expert:  Jason Jones replied 3 years ago.

Hello and thank you for your question today. My name is Jason. I look forward to helping you today.

May I take a look at the data that you have so that I can create the spreadsheet for you and upload it back?

Please, be forewarned that the site is not secure:
- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Customer: replied 3 years ago.

sure. thanks!

please also tell me how it is done so next time i come along with this problem, I will understand it.


Customer: replied 3 years ago.
  • File ID: 311614


Expert:  Jason Jones replied 3 years ago.

Thank you.

Without using some fancy addon, a lot of code, or something like that, this is difficult.

What I did was open the text in notepad, do a replace all changing all the commas to
and saving it as an HTML file. Then I opened the html file in an Internet Browser and did a simple copy and paste from the browser to Excel.

Here it is finished:

Jason Jones and 4 other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.
WWow 1
Expert:  Jason Jones replied 3 years ago.

Thank you Steve.

If you ever need any help in the future, please, let me know.

- Jason

Related Microsoft Office Questions