How to Convert CSV to Excel in Power Automate?

In this Power Automate tutorial, we will learn how to convert CSV to Excel in Power Automate.

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

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.

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

The screenshot below displays the output after importing CSV 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).

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.

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.

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.

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.

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.

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:

• Convert UTC to Local Time Zone in Power Automate
• Create an HTML Table from Microsoft Form in Power Automate
• How to Create an HTML Table from an Array in Power Automate?

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.