Convert CSV files to Excel in Power Automate Flow

In this article, we’ll show how to convert CSV files to Excel XLSX in Power Automate Flow (Microsoft Flow) using Csv to Excel action from Plumsail Documents connector.

Let’s say we have a folder with CSV files and want to convert newly added CSV files to XLSX and store them in another folder.

Our source CSV files have to be stored somewhere. Power Automate (Microsoft Flow) has a lot of connectors for different systems.

Here are just a few of them:

  • SharePoint

  • Salesforce

  • Box

  • OneDrive

  • Google Drive

  • Dropbox

  • SFTP

  • File System

You can store your files anywhere. In this example, we will store our source CSV files and the resulting Excel files in SharePoint folders, but you can get data from any other sources.

You can download the CSV demo file here.

This is how our flow looks:

Csv to Excel flow

Below is a step-by-step description of the flow.

Flow details

The flow starts when a new CSV file is uploaded to a CSV folder on the SharePoint site.

Csv to Excel flow

Then, I use the Documents action Csv to Excel.

Csv to Excel flow

You can change the advanced options Delimiter and Use first line as headers if it’s needed.

Finally, I save the resulting Excel spreadsheet to another SharePoint folder.

Csv to Excel flow

Conclusion

That is all, the flow is configured. Now you know how to convert CSV files into Excel XLSX in Power Automate Flow.

Check out another article explaining how to read CSV and batch generate HTML and PDF files in Power Automate (Microsoft Flow) and Azure Logic Apps.