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.
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,
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
