Unanswered

Automate merging a lot of individual excel files

(0) Share

Report

Posted on by Just2431

Hello,

I am new to power automate and I found a good solution online to my need. Unfortunately, the steps aren't clear to me. I pasted the steps below:

Create a new Excel file in your OneDrive. The file name "Combination.xlsx" is used in this sample.
Create and save the two scripts from this sample.
Create a folder in your OneDrive and add one or more workbooks with data to it. The folder name "output" is used in this sample.

My question is in regards to the step 2, what do I use to write those scripts and here do i save them? In the same folder with all my files or to the new folder where the files will be merged. Any help is greatly appreciated!

Thank you!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Just2431

It's better if you keep the source link so that we can also understand what script you are talking about

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Just2431

Here is a link to the documentation.

You'll find the answer to your question and more if you follow the link.

Was this reply helpful? Yes No
Just2431 8 on at

Like (0)

Report

this is the link to the resources that I am trying to use https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/combine-worksheets-into-single-workbook

Was this reply helpful? Yes No
Just2431 8 on at

Like (0)

Report

Thank you for this link. This will give me an answer to my question.

Was this reply helpful? Yes No
Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Just2431

So you need to run the script where the script is also already given

So, more details about the Office Script you can refer the documentation link which was shared by @ScottShearer

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini

Was this reply helpful? Yes No