Skip to main content

Notifications

Power Automate - General Discussion
Answered

How to add multiple CSV tables to a single file on separate worksheets?

(0) ShareShare
ReportReport
Posted on by 21,809

Hi Everybody,

 

I have a recurring flow that collects data from different sources and stores them in separate .csv files. Ideally I would like to save those tables in one file, but on separate worksheets. Like this all data for one reporting period is stored together in one file.

 

Any way to make that work?

 

Below is the flow in its current form:

 

BCBuizer_0-1651751668420.png

 

 

  • BCBuizer Profile Picture
    BCBuizer 21,809 on at
    Re: How to add multiple CSV tables to a single file on separate worksheets?

    Hi @Rhiassuring ,

     

    Yep, just found out the hard way as well 🙂 Thanks for your reply.

  • Verified answer
    Rhiassuring Profile Picture
    Rhiassuring 8,688 on at
    Re: How to add multiple CSV tables to a single file on separate worksheets?

    Hi there, 


    CSVs are only one worksheet, ever - if you open up an Excel file now, enter some data into it, then into another spreadsheet tab in the same file, and save it as CSV - your data on that second spreadsheet will be gone.  And you'll get this lovely pop-up:

     

    Rhiassuring_0-1651766661989.png

     

    Cheers,

     

    Rhia



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,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard