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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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
 
Back
Top