You’re offline. This is a read only version of the page.
Announcements
3
Hello,
I would like to convert a CSV file (,) into a XLSX file, with a power automate flow.
And if possible, modify this new XLSX file by the way (add column, pivottable,...).
Can i do this with power automate?
Thanks
There is this template for CSV to XLSX
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191
However, considering you are also looking to edit columns & stuff in Excel you will want to look into Office Scripts/Run script options for each requirement.
CSV- https://youtu.be/9J6ThPWGaG0
Pivot Tables- https://docs.microsoft.com/en-us/javascript/api/office-scripts/excelscript/excelscript.pivottable?view=office-scripts
You could also look into using Power BI instead for these things.
Share
Report
All responses (
Answers (
