How to Parse a CSV in Microsoft Power Automate Super Fast, Free and Easy.

Another method to Parse CSV files with Power Automate, using only a select action to reformat the CSV, which makes it super fast and even easier to implment. #powerautomate

Check out my latest solution for parsing CSV files which is even better than this one:

If you found this solution useful, I'd appreciate a donation to the channel:

[steco]

Thank you very much sir, these kind of videos is what I love, no 10 minute intros no blabbering, straight up doing!!! Thank you so much!

[BrettWyrick]

Wow. Earned a subscription from me. Can't believe how quick this was. Who needs premium connectors when I've got Paulie M to teach me? 😆

Thank you!

[cPathz]

For the record...In my case I take the file from an email attachment. For the splitLines compose I use:
split(base64ToString(outputs('getAttachment')?[0]['contentBytes']), decodeUriComponent('%0D%0A'))

Thank you for sharing your knowledge with us 😀

[joeshy]

Thanks for this!
Easily processes all sorts of pesky exports for legacy processes super efficiently.
So clean.

[HarshaVardhan-lidg]

You are a saviour. I was struggling to get a column value and storing it in the array. It’s just what I need. Very informative and to the point. Thanks🎉

[TrevinGrams]

This is a very handy guide, perfect for my purposes. Thank you for putting it together!

[rogerioalves]

I was doing this but instead of using the select action I was manually doing what the select does with iterators and many variables and it took soo much time both to develop the flow aswell as time needed to run. Thanks

[mattpeterson]

This is one of the cleanest and fastest solutions for parsing the contents of a CSV file into JSON I've managed to find. Thank you very much for creating this video! Hopefully future updates don't break this :)

[cipriandia]

Thank you Paulie, just commented on your previous video when I realised you made an even better version. You sir are a legend!

[fuzzy]

Smart. I had a very similar setup for parsing CSV's but using an apply to each loop to add each row into an array. Works well for small files, but Power Automate's loop actions are just way too slow to handle thousands of rows of data. Thank you!

[TranfugaCorp]

you are a genius and very good person to share your knowledge! Greetings from Chile

[facun_OK]

This is fantastic and by far really simple. Thanks a lot for sharing your knowledge

[benjaminmilkutat]

Great Video that helped me so much. Thanks for that simple work through showing how you get this done uncomplicated.

[jett]

I have a csv file that contains a sentence with a comma inside of them surrounded by "". Using this method also splits those sentences causing an error. Any idea on how to deal with this?

[sammighafari]

It was amazing, could you pls advise how to get the file as an email attachment or a file saved on SharePoint?

[DonaldElliot]

Brilliant - now just need to master those quote encapsulated commas.. power automate should do this natively....

[geoffkeenan]

Great video, clear to follow and worked first time for me!

[asifuzzamananik]

Hi Paulie, Thanks from the bottom of my heart! It was really helpful.

[anw]

Thank you...this was exactly what I was looking for

[braveheartingux]

Hi, Your way is amazing, can you please share the way where every CSV value is "" "" seperated please. As many CSVs using quoted fields to escape from character issues in the field value like comma