CSV - no delimiter at end of line
 

If I have a spreadsheet like this:

fred joe harry

And I save it as a CSV I get this:
fred,joe,harry

Now I want to import the file into a database that requires this e.g. there
is a delimiter after the last field:
fred,joe,harry,

Can I make Excel do this without using a dummy column?
The dummy column solution: e.g.
fred joe harry dummy

CSV - no delimiter at end of line
 

Try putting a space (hit the space bar once) in the last column first row and
copy down the same...before saving to csv

--
Jacob


"cats_five" wrote:

If I have a spreadsheet like this:

fred joe harry

And I save it as a CSV I get this:
fred,joe,harry

Now I want to import the file into a database that requires this e.g. there
is a delimiter after the last field:
fred,joe,harry,

Can I make Excel do this without using a dummy column?
The dummy column solution: e.g.
fred joe harry dummy