web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse CSV to Excel wit...
Power Automate
Unanswered

Parse CSV to Excel with out any external connector

(0) ShareShare
ReportReport
Posted on by 152

Dear Team,

 

I am working on a very very high sensitive data and every day I receive a CSV file with in my inbox. I wanted to create an excel file or I wanted to load this data ( not all columns, only couple of columns ) in SQL. Could you please help me to read and parse this data in power automate with out using external connectors. 

 

please guide any solution. 

 

Thanks

Categories:
  • Paulie78 Profile Picture
    8,424 Moderator on at

    I did a video on converting CSV to JSON, which would be a goof starting point for you (because once it is JSON you can do whatever you like with it).

     

    https://youtu.be/0RqSco9Til0

     

    see how you get on with the initial conversion, the rest should be easy.

  • vamsi_varanasi Profile Picture
    152 on at

    Hi @Paulie78 , 

    I tried the solution , it is worked. Thanks for that. I have an issue for one of the column values in CSV file.

    Customer Name : it is as below 

     

    FirstName, LastName 

     

    When I tried to split the entire data, customer name also getting splitted into two values and the rest of the columns with in the record is getting adjusted with wrong header names. 

     

    do you suggest any solution for this ? 

     

    Thanks, 

  • Paulie78 Profile Picture
    8,424 Moderator on at

    It's really a tricky situation to deal with. Dealing with CSV in Power Automate has issues and this is one of them. Is your CSV quoted or not? By that I mean, does it look like this:

    "Jimmy", "Johnson", "31"

    or

    Jimmy, Johnson, 31

    Quoted makes it slightly easier to work with, but I guess your CSV is not quoted, otherwise you would have had problems already.

  • vamsi_varanasi Profile Picture
    152 on at

    Hi @Paulie78 ,

     

    This is my actual data in CSV - 

     

    vamsi_varanasi_0-1613750989191.png

     

    This is my parse data - 

    vamsi_varanasi_1-1613751291042.png

     

  • Paulie78 Profile Picture
    8,424 Moderator on at

    That field is CSV quoted, so you might be able to do something with it (you can see the CSV quote at the start of the remark property and then end of the P property.

  • vamsi_varanasi Profile Picture
    152 on at

    This is the data after removed the header record and before split with comma ( , )

     

    vamsi_varanasi_0-1613751928440.png

     

  • Paulie78 Profile Picture
    8,424 Moderator on at

    I will have a think about it, but it is a common weakness of the CSV parsing method I demonstrated. I'm sure the external connectors could handle the quoted string easily. PowerShell handles it no problem, so you could use an Azure function if that was confidential enough for you. Probably is a way to do it in PA, but needs a bit of careful thought.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 298 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard