Forum Discussion
Excel CSV and Extra Commas
I'm exporting transposed data into a CSV file. When I open that CSV data in Notepad there's a bunch of extra commas. How can I get the file to open without the commas?
Hi Charla74, I did not copy paste into notepad. I opened the csv file in notepad. This is something I've always done and the additional comma issue is a new issue.
Oh, I see - Could be where columns have been deleted but Excel still considers the empty columns as part of the data range....following link may be of use:
https://support.clever.com/hc/s/articles/218518698?language=en_US
https://support.clever.com/hc/s/articles/218518698?language=en_US