In this guide you’ll learn how to convert a CSV file to a Excel (XLSX) file using a Power Automate. We support converting a large number of different file formats through Power Automate (see file formats we support).
Steps to convert your CSV to Excel (XLSX) using Power Automate:
- Create a flow in Power Automate
- Define your action (Convert to XLSX)
- Create File (define were your file will be created)
- Publish your workflow
It’s also important to note that in this example we are using Power Automate to convert a CSV file to a Excel file in SharePoint. You can easily save your Excel file to another destination like Dropbox, Google Drive, OneDrive, or any platform supported by Power Automate. You can also extend our example by adding additional automation like sending the converted file as email.
Before we start building the workflow, ensure all prerequisites are in place:
- Muhimbi PDF Converter for Power Automate full or free trial subscription.
- Appropriate privileges to create Power Automate(Flow).
This example takes you through converting a CSV document to MS Excel (XLSX) format. Our Flow actions also support the conversion of MS SharePoint Online pages. From a high-level perspective, the workflow will look as follows:
The steps to create are as follows:
1: Create a new flow in Power Automate
Create a new Flow and use the SharePoint Online trigger ‘When a file is created or modified (properties only)’. Fill out the Site Address, Library Name, and Folder.
2: Convert CSV to PDF
Insert Muhimbi's ‘Convert Excel document’ action and fill it out as per the screenshot displayed below. Naturally, you will need to substitute the Source file name and Source file content with suitable values.
3: Create a file
Insert a ‘Create File’ action to write the converted file back to SharePoint Online (or Dropbox, OneDrive, or Google Drive, or send the XLSX via email).
4: Publish the workflow
Publish the workflow and create or update a CSV file to the specified document library. After a few seconds, the Flow will trigger and an MS Excel (XLSX) file will be generated.