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 / Excel / New Users / December 2006

Tip: Looking for answers? Try searching our database.

quirks with csv files

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
The alMIGHTY N - 07 Dec 2006 15:46 GMT
Hi all,

I have an application that spits out a comma-delimited csv file. The
file is plain text without any strange characters that can't be read by
say Notepad.

When I open this file in Excel, it converts to a spreadsheet format
with each field in its own cell, just as I imagine it should.

When our client opens this file in Excel, there is only one column of
cells, each of which contains the entire row's worth of data with the
comments mixed in... it basically includes the commas as content for
the cell.

Is this just a matter of some option being different in the two Excel
installations? Is there any other reason, aside from different versions
or different configurations of the application, why the file would open
differently?

Thanks,

N
David McRitchie - 07 Dec 2006 16:01 GMT
Is your client in the same country,  more to the point is their
delimiter set up the same as your in your  "Windows" Control Panel.

If the extension is  ".CSV"  then  Excel kind of remembers what
was done before with  a  .CSV  file.   It would be better to use
".txt"  as the extension then open the file and choose delimited
then  choose  comma   on the next panel.

Since the client has the data all in one column they can do the
same as the above by selecting Column A,  then  Data, Text to Columns.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> Hi all,
>
[quoted text clipped - 18 lines]
>
> N

Rate this thread:






 
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.