CSV file for inporting contact list from Hotmail to Gmail using Ex

G

Guest

I opened a Gmail account and I am trying to import my contact list from
Hotmail to Gmail. I was told to copy the list from Hotmail and paste it onto
an Excell spreadsheet and save it as a CSV ( Comma Separated Value) file,
before importing it to Gmail. My problem is that when I try to paste the
list onto excell, it puts all of the data into one column instead of
separated columns with the headers and the information. Is anyone familiar
with the process? and if so, is there something I need to setup or format in
Excell to be able to automatically accept the data in separated columns.
 
B

Bryan Hessey

Just select the column (A) and then chose Data, Text-to-Columns, tick
Delimited, and select the correct delimiter to separate the text into
the required columns.

Then save as a .csv file
 
G

Guest

Bryan, Thank you very much. You are the man.

Bryan Hessey said:
Just select the column (A) and then chose Data, Text-to-Columns, tick
Delimited, and select the correct delimiter to separate the text into
the required columns.

Then save as a .csv file
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top