Modify CSV file using UiPath

Question

How can I update or modify a CSV file using UiPath let's say by adding an additional column to the existing sheet.

Answer 1

Hi @Praharsh,

You can add columns to an existing csv file in UiPath using following steps:

1. Open the CSV file using 'Read CSV' activity and save the output into a datatable.

2. Now use 'Add Data Column' to add the additional column into the datatable (output of csv file).

3. Then use 'For Each Row' activity to go through each row of datatable. Here, in this step you can add whatever data you wish to add for each row into that additional column. 

4. Finally, use 'Write CSV' to rewrite or update the existing file by giving the file location of existing file.

Comments

Hi,

I have a dummy csv file and I want to place the current date and time per row. I followed the above steps, but the output only shows the header "Date sent". 

This is how my for-each activity looks like, see attached.