Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
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

  • Paulie78 Profile Picture
    8,416 Super User 2025 Season 1 on at
    Re: Parse CSV to Excel with out any external connector

    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.

  • vamsi_varanasi Profile Picture
    152 on at
    Re: Parse CSV to Excel with out any external connector

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

     

    vamsi_varanasi_0-1613751928440.png

     

  • Paulie78 Profile Picture
    8,416 Super User 2025 Season 1 on at
    Re: Parse CSV to Excel with out any external connector

    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
    Re: Parse CSV to Excel with out any external connector

    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,416 Super User 2025 Season 1 on at
    Re: Parse CSV to Excel with out any external connector

    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
    Re: Parse CSV to Excel with out any external connector

    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,416 Super User 2025 Season 1 on at
    Re: Parse CSV to Excel with out any external connector

    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.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1