Excel 2016 - saving a worksheet as CSV gives extra commas when looking at the CSV in Notepad


I've several spreadsheets which need to be saved as CSV files ready for being input elsewhere.

I copy the worksheet to a new book, either Save As or Export as CSV with a new name. 

If I then open in up in Notepad, there are lots of commas at the end of each line which are nothing to do with the records.  For example:


Notes is the last column, there shouldn't be all those commas at the end.

I've tried deleting and hiding the unwanted columns and it's worked on some files and not on others. It seems a bit hit and miss.

Any ideas?

You might find the following article explaining what could cause the scenario described

Understanding Excel rows – “Clear Contents” vs “Delete”
Karl Timmermans [Outlook MVP 2012-2018]

1 person found this reply helpful


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.


Question Info

Last updated May 20, 2020 Views 1,001 Applies to: