Forum Discussion

jd1234310's avatar
jd1234310
Copper Contributor
May 23, 2022

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?  
excel
Charla74's avatar
Charla74
Iron Contributor
May 24, 2022
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.
  • jd1234310's avatar
    jd1234310
    Copper Contributor
    May 24, 2022
    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.
    • Charla74's avatar
      Charla74
      Iron Contributor
      May 24, 2022
      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

Resources