CSV - no delimiter at end of line

C

cats_five

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
 
J

Jacob Skaria

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top