Importing from Excel to Outlook contacts

Topic

New Reply

I am very new at this so please bear with me. I have a “database” in Excel and want to import into Outlook. Everything imports fine except the formatting of the phone numbers and the zipcodes. I have tried changing the cell format in Excel from special zip and special phone to text, number, and general. In all instances the phone numbers look similar to this: 13621483.000. If anyone could tell me how to correct this problem or what it is that I’m doing wrong I would be greatful.

Reply | Quote

Replies

Are you exporting as a CSV? If so, formatting should not come into it.
From memory, export as a CSV then import using the Comma Separated Values (Windows) option.

Reply | Quote

I saved the Excel file as a .csv and that seemed to do the trick. Thank you

Reply | Quote