Convert Excel file into CSV format with Power Automate | XLSX to CSV
In this video we show how to use Power Automate and Office Scripts to convert Excel files to CSV format and store in SharePoint.
This approach only requires a few lines of code in the Office Script.
This is leveraging standard connectors (no license required) and it doesn't use any third-party app
0:00 - 1:19 Use case and solution description
1:20 - 5:30 Create Office Script
5:31 - 6:39 Move Office Script out of OneDrive and upload to SharePoint library
6:40 - 13:30 Test Office Script
13:31 - 17:36 Use Create CSV action and map columns, Create file
17:37 - 22:42 Testing and troubleshooting issues with modern editor (it doesn't recognize hidden line breaks)
22:43 - 23:25 Final notes and good bye
Follow Graciela on Linkedin: / maria-graciela-martinez-865a758a
Follow us on Linkedin: / power-gi
Our website: https://powergi.net/