How To Merge Multiple Excel Files |best| Jun 2026

path = "C:\YourFolder\" files = glob.glob(path + "*.xlsx")

There are several third-party tools available that can help you merge multiple Excel files into one, such as: how to merge multiple excel files

' Copy the data from the source file wbSource.Sheets(1).Range("A1:Z" & wbSource.Sheets(1).Rows.Count).Copy path = "C:\YourFolder\" files = glob

merged = pd.concat(df_list, ignore_index=True) merged.to_excel("merged_output.xlsx", index=False) how to merge multiple excel files

Plan Your Trip to ASC:

You Make an Impact at the ASC

We’re proud to share the 2024–2025 Donor Impact Report, a look at how your generosity shaped artistry, education, and community this year.
From empowering artists on the Blackfriars stage to expanding ASL-interpreted performances, student matinees, Drama Clubs, and Theatre Camps—you made it all possible. Thank you.

Read the 2024–2025 Donor Impact Report

Summer 2026 Directors & Cast

Join us for a milestone year at the Blackfriars Playhouse as we celebrate 25 years of shared light. This summer, join us for William Shakespeare’s AS YOU LIKE IT and Thornton Wilder’s OUR TOWN, as ASC brings these two worlds into repertory. Here’s your first look at the artists bringing it all to life.

Meet the Directors and Cast

Spring 2026 Season Events

Playhouse Tours and Lights ON Blackfriars now have new Saturday times. Pair them with a show (or two) and make it a Shakespeare Saturday at the Blackfriars Playhouse this spring in Staunton, VA. Plus New Usher Training, Bard & Bites Boxes, and more—all in our Spring Season Events blog.

Discover What's Happening This Spring

Your Support Matters

At ASC, your support does more than keep the lights on—it makes magic happen. As a 501(c)(3) nonprofit, each gift fuels performances, education, and community events. Your donation is the heartbeat that keeps live theatre alive, creating unforgettable moments and touching lives.

Donate to Make a Difference

Blackfriars Circle Membership

Join the Blackfriars Circle for priority seating, discounted tickets, and early access to events at the American Shakespeare Center. Get behind-the-scenes access, member-only gatherings, and personalized service—all while supporting the magic of live theatre. Share your passion and elevate your experience.

Learn More About Membership

FREQUENTLY ASKED QUESTIONS

Have questions about your visit to the Blackfriars Playhouse?
Find everything you need on our general FAQ page, where we’ve compiled answers to the most common inquiries—whether it’s about tickets, seating, or what to expect during your theatre experience!

Visit our FAQ page