Excel Sheets Merger
Easily merge multiple sheets with the same structure into one, and export the combined data.
Overview
The app allows you to consolidate multiple sheets from an Excel file into a single sheet. Simply select the file you want to merge, and the app will combine all sheets with matching formats. After merging, you can choose to export the combined data to a new worksheet within the original file or to a specified folder. This is especially useful when working with files that contain similarly structured data across different sheets.
How to Use
Download the app from Octoparse AI app store.
Launch the app in your list.
Parameter Description
File Path: Provide the absolute path to the Excel file you want to import (supports .xlsx format), such as “D:\Sample sheets.xlsx”. If left blank, the currently active Excel file will be selected.
Export Data Path: Specify the path where you want the merged data to be saved, for example, "D:\Sample". If left blank, a new worksheet will be created in the imported Excel file to store the data.
pages: The number of pages to scrape for each keyword (each page contains 120 products).
Click "Run application"
Output
The app will create a new sheet for the merged data. If you specify an export path, it will also create a new Excel file in that location.
Notes
During the app's operation, please avoid using the mouse or keyboard to prevent interruptions.
If merging an already opened Excel file, make sure to save your data beforehand to avoid any unexpected loss.
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!
Version
version 2
2024-10-14
version 1
2024-09-02
Published