Forum Discussion

Glen_Sz's avatar
Glen_Sz
Copper Contributor
Dec 18, 2019

Need to know how to add Comma at start of each row in CSV file

I have a CSV file that is missing a comma in front of each row. I found a link somewhere a few weeks ago that worked great, now I can't find it again. It said to open up CSV file with excel, add column in front of column A. Then type a formula or something into box A1. Then when saving to CSV, that column would then be recognized as a delimited column. Hope this makes sense to somebody. It worked perfectly. Quick and simple.

excel
Formulas and Functions

1 Reply

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Dec 18, 2019

    Hello Glen_Sz,

     

    First, import the CSV file:

    In the data tab, "From Text/CSV"

     

    Once imported, insert a new column to the left of column A. In cell A1, type the formula:

    =","&B1

    Copy down as necessary.

     

    Is this what you're looking for?

Resources