Convert CSV to Excel Power Automated

(1) Share

Report

Posted on by rpskt

Hi,

Is it possible to convert CSV to Excel using Power automate? Limitation of rows?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@rpskt

As of now there is no free way to convert CSV into Excel in MS Flow. But someone suggested in this thread- https://powerusers.microsoft.com/t5/Building-Flows/Help-with-convert-excel-based-csv-to-xlsx/m-p/595637

i did not tested this link. You can try.

Thanks

Hardesh

Was this reply helpful? Yes No
Verified answer

Jay-Encodian 2,920 on at

Like (0)

Report

Hey @rpskt

I don't believe you can do this natively.

You can use the Encodian 'Convert Excel' to do this - https://support.encodian.com/hc/en-gb/articles/360011804178-Convert-Excel

Example here: https://blog.encodian.com/2020/09/convert-excel-and-csv-files-in-power-automate/

HTH

Jay

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report

I know this post is already solved, but here is a way to convert csv to excel for free. It is a premium connector which means that your mobile app will require Plan 2, I believe. But it is free.

How to Convert CSV to XLSX in Power Automate and Logic Apps - Bing video

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report

@awalker - The Encodian connector is a standard connector, therefore you do not need additional Power Automate licencing, your Microsoft / Office 365 licences will provide access to the connector.

There is a free SKU available (50 actions per month) or paid licences for higher throughput - https://www.encodian.com/pricing

HTH

Jay

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report

@Jay-Encodian I see. I must have tested my flow more than 50 times while building it then, because now my powerapps mobile app has me locked out until I extend the lisence. The online version still works fine and the flows still run, but the mobile app won't.

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report

@awalker What do you mean by 'locked out', this is nothing to do with the Encodian connector... a connector is just simply called, there shouldn't be any difference whether you consume online or via a mobile app. Why do you think this is related to the Encodian connector? (or any connector)

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report

After I added an excel connector and the "CVS to Excel" Cloudmersive connector to my flow, my mobile app said that I needed to extend my trial. Our company has the full licensing for this product, as far as I know, and I've been using the mobile app for over a year without any problems until then.
I don't know that it is related to the cloudmersive connector, but that's the only changing variable to what I've been doing with Powerautomate and Powerapps.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (3)

Report

I think this is possible, without premium or third party connectors....

Convert the CSV to JSON.

Then once you have the JSON you can use an Office Script or the action to add rows to populate excel.

This is of course not a straight "Conversion" - but the result is the same.

Was this reply helpful? Yes No
awalker 233 on at

Like (0)

Report

Thanks! I will try that

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Did you get this sorted ?

Was this reply helpful? Yes No