I have an excel file with 5 columns and about 20 rows. The first row
contains header information need by another program which this file will be
imported into. Only the first 3 columns contain data, but the last two need
to be represented in the .csv file. My problem is that after saving the file
in .csv format and opening it in notepad, the first 16 rows are formated
properly, i.e x,x,x,, From row 17 on it is just x,x,x. The last two columns
do not have place holders. Why is this happening?

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".)

Maybe you can just fill the empty cells with your own placeholders.

I'd use a formula like this:
=""



CoyB wrote:

I have an excel file with 5 columns and about 20 rows. The first row
contains header information need by another program which this file will be
imported into. Only the first 3 columns contain data, but the last two need
to be represented in the .csv file. My problem is that after saving the file
in .csv format and opening it in notepad, the first 16 rows are formated
properly, i.e x,x,x,, From row 17 on it is just x,x,x. The last two columns
do not have place holders. Why is this happening?

--

Dave Peterson

Thanks for the reply and solution. The KB article described the exact
problem I was having.

"Dave Peterson" wrote:

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".)

Maybe you can just fill the empty cells with your own placeholders.

I'd use a formula like this:
=""



CoyB wrote:

I have an excel file with 5 columns and about 20 rows. The first row
contains header information need by another program which this file will be
imported into. Only the first 3 columns contain data, but the last two need
to be represented in the .csv file. My problem is that after saving the file
in .csv format and opening it in notepad, the first 16 rows are formated
properly, i.e x,x,x,, From row 17 on it is just x,x,x. The last two columns
do not have place holders. Why is this happening?

--

Dave Peterson