How can I import my contacts from Excel into Gmail?

Question

I have tried saving as a .csv file, but Gmail says it cannot recognise the file format. All I have is one coloumn with email addresses running down the rows.

Any ideas?

Answer 1

To import the csv file to Gmail, the csv file must follow the format of csv  produce by either Outlook express or Ms Outlook.

First get the contact form/template that outlook would take for import

1. if you're not already have address on outlook, add at least 1 address to it,

2. if you already have address, go to menu, File, import and export, export to a file, comma separated value, then export the address(es).

Use the csv file just export as a blank form, cause it got all the column titles for outlook

1. cut and past from your own record/file or simple add your own addresses to the respective column

2. check for some special character which might cause error in the process of import, like apostrophe(') or comma(,) etc delete/change them

3. after the entries and edit, save it in csv format

Then you got the file that meet the compliance of Gmail for importing, follow the step in this link for the import

http://email.about.com/od/gmailtips/qt/e...

If you use outlook express, use this http://email.about.com/cs/oetipstricks/q...

to get your csv template instead of the above.

Hope this helps.