Excel Consolidation

Consolidate multiple Excel spreadsheets into a single spreadsheet

Top Benefits

  • Saves time in consolidating the multiple Excel files into one Excel
  • Fast, efficient, and accurate
  • Can be used in any department where multiple files of same format need to be consolidated

Tasks

  • Read all Excel files in a folder
  • Create a new Excel file with all consolidated data

Read data from an input folder containing one or many Excel files with matching formats to a single Excel file.

Example: A folder with multiple Excel files has the following: “Excel1.xlsx, Excel2.xlsx, Excel3.xlsx” of the same structure. Through the use of this bot, those files can be consolidated into a single Excel file named “Master.xlsx”

Detailed steps:

  1. Provide necessary values like folder path, the filename(s) in the input file, and trigger the bot.
  2. The bot will read all the Excel files from the provided folder and save the consolidated file in the corresponding output path.

Use Cases:

  • Consolidating sales requirements received from different salespeople.
  • Consolidating annual reports from a folder containing weekly/monthly reports that need to be merged.
  • Consolidate any information collected from different sources into one file for data validation, reporting, etc.
Buy Now

$100 USD per bot
Annual Subscription

Free 30-Day Trial

Request quote for more purchase options

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
September 15, 2021
First Published
July 10, 2020
Platform
11.3.3
ReadMe
ReadMe
Support

See the Bot in Action

Input file (Folder Path, File Name, etc)
Folder with sample Excel files for consolidation
Consolidated file in single spreadsheet
Consolidated file in separate spreadsheets
Error Log in txt file
PREV NEXT
Input file (Folder Path, File Name, etc)
Folder with sample Excel files for consolidation
Consolidated file in single spreadsheet
Consolidated file in separate spreadsheets
Error Log in txt file

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Microsoft Excel
  • Update necessary information in column 'B' "Input Excel.xlsx"