Read csv and then change it into an excel file

i have tried using the read csv and then move file to change the csv from .csv to .xlsx but it does not work. i need to convert it to .xlsx to remove duplicate and do some data ordering.

Hi @clumsily
You can do the removal of duplicates using datatable itself and then save it to excel file


  1. Read the csv file using read csv file activity and store in dt1

  2. Use Remove duplicates to remove the duplicates

  3. after other operations with datatable, use write range to write the datatable to excel file

Hope it helps

Mark it as solution if it resolves ur query

Nived N
Happy Automation

Hi @clumsily

Use read CSV file activity → You will save the data as DataTable. Then you can use Write Range to write your data in an Excel file.
See these videos about csv.
Video 1: UiPath | Read CSV File | Add Column to CSV File | How to read CSV File and Add Data Column to CSV - YouTube
Video 2: UiPath | Convert Text File to CSV File | Get Data from Text File into CSV File | Create CSV File - YouTube

Best regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.