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

Asked By 10 points N/A Posted on -
qa-featured

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.

could not open the CSV file correctly in Microsoft Excel 2007
SHARE
Best Answer by Peter franklin
Answered By 0 points N/A #120129

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

qa-featured

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.

Working on the contact in offline mode the CSV file should be downloaded exported in the outlook.csv format instead of google.csv format

Regards,

Best Answer
Best Answer
Answered By 0 points N/A #120130

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

qa-featured

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

Login/Register to Answer

Related Questions