Read from Excel sheet and wirte to CSV File

Hi All,

I need to convert excel sheet into CSV File.
Based on some filter conditions in excel sheet , i need to copy the filtered data from the excel sheet and paste it in the CSV File.
Please suggest me how can i move forward.

Use Read Range to get the data, then use the Write to CSV activity to write the data to a CSV file.

UiPath makes this as simple as a sequence of 2 activities.

but write to csv file takes datatable. we are filtering the data based on datatable only. then how can we write the filtered excel sheet data to csv. please suggest

Read range pulls the data into a datatable, which would then be transferred to the CSV in the Write to CSV activity.

1 Like

You can use below activities in the following order:

  1. Read Range activity-
  2. Filter Data table activity
    UiPath Tutorial | How to Use Filter Data Table in UiPath | ExpoHub - YouTube
  3. Read CSV activity.
    Screenshot is below:

    https://www.youtube.com/playlist?list=PL41Y-9S9wmyKbV0spfeG-TiM3LyTG6mLY

Thanks for the reply

Thanks for the reply and it worked

1 Like