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?
3 Replies
- CSV stands for comma separated values - anywhere you see the 'extra' commas indicates a blank cell in Excel. Perhaps copy paste only populated cells rather than the whole row will work better.
- 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
