View Single Post
  #1   Report Post  
One-eyed-Ian
 
Posts: n/a
Default When converting an .xls file to .csv I get too many commas at the.

When attempting to convert an .xls format to .csv format using Excel to do
the conversion process, I am getting too many commas at the end of a number
of lines (where there is NO data at all). It may be linked to some preview,
I see some resemblance between 'web page preview' and the resultant output.
Would like to just save a file with variable numbers of (and items of) data
on separate lines of the same file, and for the .csv file to have the correct
number of commas per line. How can this be achieved?