I am converting an excel file to CSV. I have 65 rows of data, with ~ 7 rows
that contain data from column A to J. For the remaining rows of data I do not
have data in columns B to J however I still need to export commas for all
columns. For the next 6 rows I have commas for each column however the
remaining data in the file converted file only shows commas up to column D.

Try putting something in those empty cells.

I like to use a formula that makes the cell look blank:
=""



David Rivera wrote:

I am converting an excel file to CSV. I have 65 rows of data, with ~ 7 rows
that contain data from column A to J. For the remaining rows of data I do not
have data in columns B to J however I still need to export commas for all
columns. For the next 6 rows I have commas for each column however the
remaining data in the file converted file only shows commas up to column D.

--

Dave Peterson

This is a known Excel issue.

http://support.microsoft.com/kb/77295

If the solution in the article is not viable I think you'd have to use a
macro to create the CSV file.

--
Jim
"David Rivera" wrote in message
...
|I am converting an excel file to CSV. I have 65 rows of data, with ~ 7 rows
| that contain data from column A to J. For the remaining rows of data I do
not
| have data in columns B to J however I still need to export commas for all
| columns. For the next 6 rows I have commas for each column however the
| remaining data in the file converted file only shows commas up to column
D.

This is fixed in Excel 2007.

--
Jim
"Jim Rech" wrote in message
...
| This is a known Excel issue.
|
| http://support.microsoft.com/kb/77295
|
| If the solution in the article is not viable I think you'd have to use a
| macro to create the CSV file.
|
| --
| Jim
| "David Rivera" wrote in message
| ...
||I am converting an excel file to CSV. I have 65 rows of data, with ~ 7
rows
|| that contain data from column A to J. For the remaining rows of data I do
| not
|| have data in columns B to J however I still need to export commas for all
|| columns. For the next 6 rows I have commas for each column however the
|| remaining data in the file converted file only shows commas up to column
| D.
|
|

Thank you both Jim and Dave. Dave's solution worked and the information Jim
followed up with was very informative and answered why this was happening.

Thank you,

Dave

"Jim Rech" wrote:

This is fixed in Excel 2007.

--
Jim
"Jim Rech" wrote in message
...
| This is a known Excel issue.
|
| http://support.microsoft.com/kb/77295
|
| If the solution in the article is not viable I think you'd have to use a
| macro to create the CSV file.
|
| --
| Jim
| "David Rivera" wrote in message
| ...
||I am converting an excel file to CSV. I have 65 rows of data, with ~ 7
rows
|| that contain data from column A to J. For the remaining rows of data I do
| not
|| have data in columns B to J however I still need to export commas for all
|| columns. For the next 6 rows I have commas for each column however the
|| remaining data in the file converted file only shows commas up to column
| D.
|
|