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 the Csv to Excel action from the 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.

This is how our flow looks:

Csv to Excel flow

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

Flow trigger

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

Csv to Excel flow

Convert CSV to Excel XLSX

Convert CSV to Excel XLSX is an action from the Plumsail Documents connector.

Csv to Excel flow

If this is your first time using the Plumsail Documents connector, Power Automate will request the Connection Name and API Key.

Create connection in Power Automate flow

You can type any name for the connection, for example Plumsail Documents.

Once the connection name is filled out, create an API key in your Plumsail Account, copy and paste it into the Access Key field, and then click Create.

Copying an API key from the account

The action ‘CSV to Excel’ has one required field - the conten of thhe CSV file you’d like to convert to Excel. We inserted the trigger output into this field. Also, you can change the advanced options Delimiter and Use first line as headers if it’s needed.

Create file

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 to Excel XLSX in Power Automate Flow.