CSV Editing in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When i open a CSV file in Excel and edit it and then save it. Excel removes
the text qualifiers onwards from the line 14 when the last two or three
columns of my csv are empty. Also i am using double qouts for the
qualification of my data
so that each column has data wraped inside " marks.
 
You may be able to create your CSV file correctly by filling those empty cells
with a place holder. I'd use a formula:

=""

The cell will look empty, but should be processed ok.

If you want more control...

Saved from a previous post:

This might describe the problem of too many commas in CSV files:

http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text

(It actually describes missing delimiter, but if some are "missing", maybe the
ones appearing are "extra".)

(But a lot of programs (excel included) don't care about those extra columns.
Maybe you don't have to care, either???)

Maybe you could write your own exporting program that would behave exactly the
way you want:

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(or maybe you could build your own formula and copy|paste into Notepad.)
 
Back
Top