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

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

How do I Merge Excel Files into One Sheet without Losing Data?

(0) ShareShare
ReportReport
Posted on by 2
Hi everyone,

I just wanted to share my experience. Recently, I was struggling to merge Excel files into one sheet without losing any data. At first, I tried manual methods, but because of the file size and formatting issues, it wasn't easy to manage.


After searching for a proper solution, I came across a detailed blog that explained everything step by step. It really helped me understand the process and finally get my files combined successfully. I thought it might help others facing the same issue as well. You can try the free demo version to understand how it works for free.
I have the same question (0)
  • Power Platform 1919 Profile Picture
    1,773 on at
    How do I Merge Excel Files into One Sheet without Losing Data?
    Hi @kylen0550, adding this to conversation, we can use VBA macros (if you are up for VBA coding).

    we can build a generic VBA macro codes which accepts the parameters and does the operations as defined like merging, deleting, creating new sheets  etc....

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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard