Share via

Convert CSV to Excel with Power Automate- CSV file includes a column as description with large text

Aida Vatankhah 1 Reputation point
2022-06-07T13:46:49.047+00:00

Hi,

I have used the following link to create a flow to convert the CSV file to Excel and it works fine for a sample normal csv file! This document uses a Microsoft script for doing so.

https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv?source=docs#power-automate-flow-create-new-xlsx-files

The problem: The CSV file that I need to convert it to Excel has a column as description which includes large text. While running the flow, it stuck in "Running the Microsoft script to convert csv to excel" and finally "Time out".

What is the limitation for content size in csv?
How can I modify the code to support the csv files including cells with large content size? (In my csv file, the number of rows and columns are normal (20 rows and 6 columns), but the content inside one cell can exceed the limited value)

I would appreciate your help in advance!

Regards
Aida Vatankhah

JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
990 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,936 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,334 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.