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:
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.
Convert CSV to Excel XLSX
Convert CSV to Excel XLSX is an action from the Plumsail Documents connector.
If this is your first time using the Plumsail Documents connector, Power Automate will request the Connection Name and API Key.
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.
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.
Conclusion
That is all, the flow is configured. Now you know how to convert CSV files to Excel XLSX in Power Automate Flow.