Merge Excel Files

Overview

This app scans a folder for all Excel files, extracts the headers from a selected file, and merges data from all the files into a new summary file. It's designed to streamline the process of combining Excel data, making it easy to organize information from multiple files into one place.

How to Use

1. Download the app from Octoparse AI app store.

2. Launch the app in your list.

   

   1.  Parameter Description

      

      1. ExcelFolderPath: The folder path containing the Excel files to be merged.

         

   2. Click "Run application"

3. Output

   The application will collect data from the specified pages for each keyword and save the results to the designated folder.

   

Notes

• Do not use your mouse or keyboard while the app is running to avoid interruptions.

• Ensure all Excel files to be merged are closed before running the app.

• Each file must have the first row set as the header, and data should be located in the first sheet of each file.

• All Excel files must have the same structure: identical columns and headers.

• The merged summary file will be saved in the same folder as the source files.

Support

Encounter obstacles but don't know how to resolve them when executing the app?

Please contact our support team at [email protected] to find the way out!