Guardar archivo csv como excel

hola a toda la comunidad, estoy descargando un archivo csv, pero necesito guardarlo como xlsx

me podrian decir una forma de hacerlo sin manejar con click el archivo en si

muchas gracias!

Hi,

To convert CSV to XLSX without opening the file, you can just read the .csv file and write it into an excel (.xlsx) file.

Refer: (1) RPA - UiPath - Convert CSV to Excel (xls) - YouTube

Cheers!

1 Like

Hi @mively

Here is how you can save a CSV as Excel:

Input:

The Workflow:

  1. Read the CSV file from the folder it is downloaded:

  2. Use Write Range Workbook to save it as xlsx. (The Sheet name and Path is upto you to decide)

  3. Delete the CSV File from the Download Path (to save space)


The Output:

  1. The excel data:
  2. The CSV file is deleted as you can see:

If this solves your question, Do Mark it as a solution
Happy Automation :star_struck:

1 Like

Hello @mively

Use can you read CSV activity and Write Range Workbook activity to accomplish this

Make sure you click on Add headers property in Write Range Workbook activity.

Hope this helps!

1 Like

Hi @mively

Can you try this

Regards,

1 Like

Hey @mively
1-use read csv activity save their output.
2-use write range and pass the output variable of read csv.

using these 2 activity help you to write your csv data into excel file.

cheers

1 Like