How to Convert CSV to Excel in Power Automate?

Are you aware of how to convert CSV to Excel in Power Automate? No, then don’t worry!

Follow this Power Automate tutorial to learn how to convert CSV to Excel using Power Automate.

CSV in Power Automate usually refers to Comma-Separated Values, a plain text format used to represent tabular data.

How to Convert CSV to Excel in Power Automate

Let’s see how to import CSV to Excel using Power Automate. To work around this, follow the steps below.

For this, I have created a CSV file named ‘Employee Data’ with a few columns such as Employee ID, Employee Name, and Employee Email ID.

Convert CSV to Excel using Power Automate

We have created a SharePoint document library to import the CSV file that we have created.

Convert CSV to Excel in Power Automate

The below screenshot displays the output after importing CSV to Excel using Power Automate.

Convert CSV file to Excel using Power Automate

1. Navigate to https://make.powerautomate.com in your browser to open the Power Automate home page; click on + Create -> Select the Instant cloud flow -> Provide the flow name and choose the trigger’s flow (Manually trigger the flow).

Power Automate convert CSV to Excel

2. To directly retrieve tables from Excel files, add the ‘Get tables’ flow action and set the required fields as:

  • Location: Select the location of the SharePoint Site.
  • Document Library: Select the document from the SharePoint document library.
  • File: Select an Excel file through the file browser.
How to convert CSV to Excel using Power Automate

3. Add the ‘List rows present in a table’ flow action to retrieve data from a specific table within an Excel workbook. Set all the required details as shown below.

  • Location: Provide the location of the SharePoint site.
  • Document Library: Select the document from the SharePoint document library.
  • File: Select an Excel file through the file browser.
  • Table: Select the name of the table from the dropdown.
Using Power Automate convert CSV to Excel

4. Next, add the ‘Create CSV table’ flow action and set the required fields as shown below.

  • From: Here, I have selected value from the Dynamic content of List rows present in a table flow action.
  • Columns: Select the type of columns to display the value as shown below.
HeaderValue
EmployeeID
EmployeeName
EmployeeEmailID
Select value from the dynamic content under List rows present in a table.
Import CSV to Excel using Power Automate

5. Now, add the ‘Apply to each’ flow action -> Here, I have Selected an output from previous steps i.e. value.

6. Add the ‘Create file’ flow action to create a new file in a specified location and set all the required fields.

  • Site Address: Provide the SharePoint site address.
  • Folder Path: Select the path of the folder.
  • File Name: Select the name from the dynamic content with the extension .csv.
  • File Content: Here, I have given the Outputs of the Apply to each flow action from dynamic content.
How CSV to Excel import in Power Automate

7. Now it’s time to Save and Test. Then test it Manually -> Open the SharePoint list and click on the item that reflects from the CSV. Then, it redirects to the Excel spreadsheet, as shown below.

CSV to Excel import using Power Automate

This is how to import CSV to Excel using Power Automate.

Conclusion

I hope this Power Automate tutorial taught the step-by-step procedure to import CSV to Excel using Power Automate.

Also, you may like some more Power Automate tutorials: