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:
Considering the ‘Convert Excel‘ action covers these prevalent file format conversion scenarios, with example configurations depicted below:
The ‘Convert Excel‘ action determines the input file format from 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 manually type the input filename for ease of reading:
The following example converts an XLS document to XLSX format:
The following example converts a CSV document to XLSX (Excel) format:
The following example converts an XLSX document to CSV format:
The following example converts an 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.
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 ‘New Orders‘ from an XLSX document to a PDF document.
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.
We hope you’ve found this helpful guide. As ever, please share any feedback or comments. All are welcome!
UPDATE: We’re excited to announce some significant updates to Flowr for Power Automate! As of October 2024, we’ve improved by updating action names and splitting Flowr’s central Power Automate connector into nine specialized connectors. These changes will make your workflow faster, smoother, and more efficient. The new action names are more precise and intuitive, saving you time, while the focused connectors enhance performance and flexibility. This update also helps future-proof the platform for even more powerful features. Check out our updated action names blog.
Managing Director