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

3 Replies

Sort By
  • 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