CSV File google.csv not correctly opened in Microsoft Excel 2007

Asked By Patrick Doeswell 10 points N/A Posted on - 08/31/2011

Hello Guys,

I want to edit some contacts in my Gmail account. Rather than edit them online, I try to work offline. So I export my contact to a CSV file. A feature from Gmail contacts allow me to do that. But what’s happen next is that I could not open the CSV file correctly in my Microsoft Excel 2007. Each field does not place in a cell, but like a continuous text. Do I need to do something before I can open this CSV file or maybe there are different standard of CSV file from Microsoft and Google.

I wish somebody have a solution for this.

• Status: Open
• Question Views: 2736
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Peter franklin

Go To Solution

Answered By LINDA B 0 points N/A #120129

CSV File google.csv not correctly opened in Microsoft Excel 2007

Patrick Doeswell

Hi,

You can edit the googlecontacts.csv files by right clicking and opening it using the EDIT option.

The file will open in NOTEPAD, where a editing is little bit easier.

However, for working on the contact in offline mode, the CSV file should be downloaded (exported) in the outlook.csv format instead of google.csv format (refer attached pic). This file can be easily uploaded in Google contacts again.

Regards,

About LINDA B

Questions
1

Answers
18

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 08/31/2011
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Peter franklin 10 points N/A #120130

CSV File google.csv not correctly opened in Microsoft Excel 2007

Hi,

It looks like that the file you have is in the Google only supported format which can not edit offline. In order to be able to edit it online you should first save the file as a Microsoft outlook supported file. You can do this when exporting your file from Gmail. There you will have the option to export it as a Outlook CVS format and then open it in outlook and it should wok fine. I hope this helped.

Regards,

Peter franklin

About Peter franklin

Questions
0

Answers
102

Best Answers
35

• Vote Up 0 Vote Down

• Posted on - 12/06/2012
• Question Category: MS Excel