Forum Discussion

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 colu...

excel

Formulas and Functions

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?