I'm currently calling an office script
to convert a csv file to xlsx it works perfectly on a csv with 15k rows however it times out after around 15 minutes on a larger (1 million rows) csv. Is there anyway I can get this to work?
I have this template that can convert a CSV to Excel without Office Scripts: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-To-New-Excel-Table/td-p/1826096
But it would likely max out at the maximum action data size limits of like 200MB, somewhere between 100000 and 200000 rows.
You’d probably need to split the CSV into batches of like 100,000 rows and adjust the flow to add new rows to an existing table instead of to an entirely new Excel workbook & table.
#1
WarrenBelz
146,708
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,030
Most Valuable Professional
Share
Report
All responses (
Answers (
