Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Use MS Flow to save CSV file to one master Excel file

(0) ShareShare
ReportReport
Posted on by

We have a customer inquery website that generates a CSV file with each interaction. I'd like to automattically take each CSV file and combine them into one master Excel file. Each CSV file has a header row and a data row. I'd like to take the data row and move it into the Excel file. Is it possible to automate this process with MS Flow? Each CSV file will be save independently into a central folder on OneDrive for Buisness.

  • gadgetman4u Profile Picture
    gadgetman4u 31 on at
    Re: Use MS Flow to save CSV file to one master Excel file

    Is there a way to save the CSV file?  I have a CSV generated from Create CSV table and I want to save to a CSV file to be stored in Azure Data Lake Store.  Can it be done?

  • v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Use MS Flow to save CSV file to one master Excel file

    Hi @ rct224,

     

    I am afraid there is no way to analyze CSV file in Microsoft Flow currently.

    There is a similar idea would like to get rows from a text file (CSV) submitted as link below:

    https://powerusers.microsoft.com/t5/Flow-Ideas/Text-CSV-file-get-rows/idi-p/19494

     

    You could consider convert all your CSV file to Excel file manually, and then get data with “Get rows” action of Excel connector .

     

     

    Regards,
    Alice Zhang

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics