Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2006

Tip: Looking for answers? Try searching our database.

CVS doc to import into gmail address book

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
margaret.hartmann@gmail.com - 16 Nov 2006 17:44 GMT
I am trying to convert an Excel Document into a CVS document so that I
can import it into my gmail address book.

The file has two columns one for names and the other for emails.  I
saved it as a CVS document and excel told me that I might have a
problem with the document... but didn't tell me why or how to fix it.

Then when I tried to import it into gmail... It told me that my file
was corrupt.

any ideas?
thanks
margaret
Peter Jamieson - 16 Nov 2006 18:30 GMT
This group isn't about either Excel or gmail, but
a. when you Save As from Excel to a .csv format, the chances are that Excel
will
   - warn you that a multi-sheet Excel workbook can't be saved as a .csv .
In other words, you can only export the data from a single sheet - probably
what you expect.
   - warn you that some of the data may not export successfully into .csv
formt. That could be for a variety of reasons, but in essence Excel is
saying "Excel format is richer than .csv format". So again,that message may
not be telling you anything particularly significant in this case.
b. you should be able to open the .csv file in a plain text editor such as
Notepad. if you also have a description of what gmail expects to be in a
.csv file (I don't know), you should be able to work out from that what is
going wrong. It could be that your data has delimiter characters such as
commas, carriage returns, or double-quote characters in it.

Peter Jamieson

> I am trying to convert an Excel Document into a CVS document so that I
> can import it into my gmail address book.
[quoted text clipped - 9 lines]
> thanks
> margaret
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.