How to add column to a csv file?

[happygal321]

I have a CSV file that opens in excel. It has 5 columns, but i want to another column after the 5th one.

How is this achieved?

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @happygal321,

Have you tried updating your csv directly?

You can modify your csv file like any other file. Just use the same format/delimiter used to separate other columns and you should be good to go.

Regards
Sonali

[gabrielribas4 (Gabriel Ribas)]

Hi happygal!

I think you can follow the following steps:
–> Use the read CSV activity and save it to a datatable variable
–> Now use the ADD DATA COLUMN activity to add a new column to the datatable
→ Perform the operations you want and save this new csv

I hope it helps!

[happygal321]

i tried this, but it didnt work. could you show an example?

[sonaliaggarwal47 (Sonali Aggarwal)]

Hi @happygal321,

Please refer below link for solution on this:

Adding New Column in CSV

I am trying to add a new column named description in which takes the scraped data from each news article and assigns it into the description corresponding to the correct Article. I have tried data column also but that doesn’t seem to work either. [image] [image] [image] Any suggestions would be great

Also you can check this documentation link from UiPath, it also has sample project for same:

Activities - Append To CSV

Regards
Sonali

[NIVED_NAMBIAR (NIVED N)]

@gabrielribas4 method works for you @happygal321
check this workflow
process1.zip (4.2 MB)

regards,
Nived N
Happy Automation