Excel Consolidation

This Bot consolidates all xlsx files in a folder as 1 Excel with choice of consolidating requirement by user. 1. Single Spread Sheet 2. Separate Spread Sheets

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 new excel with consolidated data

Summary:
Read data from folder containing ‘n’ number of excel files with same format to one Single Excel, e.g. Folder with Multiple excel files say “Excel1.xlsx, Excel2.xlsx, Excel3.xlsx” of same format to a Single Excel say “Master.xlsx” ( Copies all data inside the excel files inside the folder to a single excel) on two Different Conditions.
Details Steps:
1. Provide necessary values like folder path, filename in the input file and trigger the bot.
2. Bot will read all the excel from folder and save the consolidated file in output path.
Use Case :
1. Consolidating sales requirement received from different sales person.
2. Consolidating Yearly report from a folder containing report based on month or weekly.
3. Consolidate any information collected from different source 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
July 24, 2020
First Published
July 10, 2020
Enterprise Version
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"