We recently released a new action ‘Convert Excel‘ which provides the capability to convert a multitude of different spreadsheet file formats to the following file formats a PDF, XLSX, HTML, CSV or TXT. 

The supported input file formats are:

  • xls
  • xlsx
  • xltx
  • xlsb
  • csv
  • tabdelimited
  • ods
  • spreadsheetml

Considering, the ‘Convert Excel‘ action covers these very common file format conversion scenarios, with example configurations depicted below:

The ‘Convert Excel‘ action determines the input file format from on the ‘Filename‘ value provided, i.e. by checking the file extension. Typically, you would pass filenames via dynamic data, for example; 

However for these examples we’ll simply manually type the input filename for ease of reading: 

Converting XLS to XLSX with Power Automate

The following example converts a XLS document to XLSX format: 

Converting CSV to XLSX with Power Automate

The following example converts a CSV document to XLSX (Excel) format:

Converting XLSX or XLS to CSV with Power Automate

The following example converts a XLSX document to CSV format:

Converting XLSX to HTML with Power Automate

The following example converts a XLSX document to HTML format:

Any images contained within the source XLSX file would be converted to dataUri’s and embedded within the resulting HTML document. 

Convert a specific Excel worksheet to PDF with Power Automate

The ‘Convert Excel‘ action provides several advanced options. The ‘Worksheet Name‘ option enables you to target a specific worksheet inside an Excel workbook, where only the contents of the targetted worksheet would be used in the conversion operation. 

The following example converts the worksheet named ‘New Orders‘ from and XLSX document to a PDF document.

Final thoughts…

Hopefully this post has provided a high level overview of the capabilities of our new ‘Convert Excel‘ action, if you have any technical queries please visit our customer support portal.