Convert CSV to Excel using Power Automate

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:

  1. Create a flow in Power Automate
  2. Define your action (Convert to XLSX)
  3. Create File (define were your file will be created)
  4. 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.

Prerequisites

Before we start building the workflow, ensure all prerequisites are in place:

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.

convert csv to excel

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.

create a new flow

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).

convert csv to pdf

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.

Have a Question?
We’re Always Happy to Help.

© Muhimbi Ltd. 2008 - 2023
This website uses cookies to ensure you get the best experience. Learn more