Change text format to excel /csv format

Hey all,

I need your help please, can we extract text file format to csv or excel format in uipath ? thanks in advance

If the text file is already comma-delimited, you only need to change the extension of the file to .csv. Excel will be able to read the file.

1 Like
  1. Take a Copy File Activity and properties as

Source : “path/file.txt”
Destination : “path/file.csv”

  1. Take a read csv activity and read “Path/file.csv” created above with correct delimiter in properties. Get output in a datable say dt_Output.

3.Take a Excel Write range and write the datable dt_output created above to this Excel.