Importing CSV Results in Error

Question

Greetings...

Attempting to import a single contact to Outlook. I am trying to copy a contact from Google Contacts into Outlook Contacts. I export the contact from Google, and it asks me for a specific CSV format. Outlook is one of the choices, so naturally I choose that. Then I go into Outlook, and select File -> Open & Export -> Import/Export ->Import from another program or file -> Next -> Comma Separated Values -> Next -> Replace Duplicates -> Next -> Contacts (This computer only) -> Next -> BZZZT! FAIL! I get the following error message:

![](https://learn-attachment.microsoft.com/api/attachments/739b927d-d331-4511-be36-ce0f8d742738?platform=QnA

Answer 1

Hello imspy

Hi, I'm Karl and will be happy to help you today.

You're not doing anything wrong - it's a problem related to the CSV file created by Google

Steps you need to follow to resolve the problem are

#1 - Open the CSV file in Excel

#2 - Deleted the first <blank> column (col CK is memory serves be correctly)

#3 - Save the corrected worksheet as a CSV file

#4 - Import the newly saved CSV file

Answer 2

PS: What a strange anomaly. A blank column beyond the end of the database. Whodathunk?

Answer 3

Hello imspy

Hi, I'm Karl and will be happy to help you today.

You're not doing anything wrong - it's a problem related to the CSV file created by Google

Steps you need to follow to resolve the problem are

#1 - Open the CSV file in Excel
#2 - Deleted the first <blank> column (col CK is memory serves be correctly)
#3 - Save the corrected worksheet as a CSV file
#4 - Import the newly saved CSV file

Compliance.

Success.

Gratitude.

Closure.