Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CSV file for inporting contact list from Hotmail to Gmail using Ex
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. |
#2
|
|||
|
|||
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 Jesterzone Wrote: 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. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=397430 |
#3
|
|||
|
|||
Bryan, Thank you very much. You are the man.
"Bryan Hessey" wrote: 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 Jesterzone Wrote: 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. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=397430 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recent File List Check Box Greyed out | Excel Discussion (Misc queries) | |||
List folders to file | Excel Discussion (Misc queries) | |||
How do you open a template at startup? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) |