You’re offline. This is a read only version of the page.
Hi,
Is it possible to convert CSV to Excel using Power automate? Limitation of rows?
Thanks
I realize this has been answered and it was years ago. But using the desktop version:
Launch Excel action, choose the csv file
Close Excel action and choose save as and change the extension to xlsx and it works.
You can now try automatically converting most CSVs to a new Excel table with the same column names as the CSV headers with this template:
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-New-Excel-Table/m-p/1826096#M964
@KF0318 My input csv data was the same and I got the same results using Office Excel Script example.
Try the update below, add after this section:
Share
Report
All responses (
Answers (
// Remove the preceding comma.
row.forEach((cell, index) => {
row[index] = cell.indexOf(",") === 0 ? cell.substr(1) : cell;
});It will remove all double quotes from the cells, this works for my data, hope it works for you too!
Add this:
// Remove all double quotes
row.forEach((cell, index) => {
row[index] = cell.replace(/"/g,"");
});
Just followed this tutorial, unfortunately all the text in the resulting excel file is wrapped in double quotes. [Cocom, Marta] becomes ["Cocom, Marta"]. Would you know of anything I could add to fix this? Maybe an extra line or two to add to the Office Script to get of these?
There is also a way to convert a CSV-File to an Excel-File using Office-Scripts
Please see Convert CSV files to Excel workbooks - Office Scripts | Microsoft Docs
@toadmyster @Anonymous @awalker
I created a free CSV to JSON template for these types of scenarios. It only uses the built-in actions and it can handle several of the common parsing errors, even in large files.
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191
I realize you are talking about doing this in a cloud flow but Power Automate Desktop can do this if you have the option of using PAD in your environment. Convert a CSV file into an Excel spreadsheet - Power Automate | Microsoft Docs
Ah..ok. I use the Web version and I'll have to do the same as well. Quiet frustrating.
Did you get this sorted ?
#1
stampcoin
79
#2
Michael E. Gernaey
70
Super User 2025 Season 1
#3
David_MA
48
Super User 2025 Season 1
