Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Consolidate Data from multiple Excel Files and create Master File
This Bot will copy all the data without a header from multiple Excel files and create a master file with a header.
Top Benefits
- Saves Time
- Consolidated Excel file available with standard formatting
Tasks
- Gathers data from multiple files placed in a input folder.
- Creates master file with all the data from multiple files.
Inputs: Multiple Excel files with data.
Outputs: Consolidated Excel file with data from all the input Excel files
Use Cases: Consolidating data received from multiple customers, vendors, departments etc.,