Excel Files and Sheets Consolidator

About the tool

Excel Files and Sheets Consolidator is an MS Excel based data consolidation tool which can be used to consolidate data from multiple Excel Files or Excel Sheets. The tool supports multiple configurations such as Sheet Name, Sheet Index, Header Row and Non-Blank column to help consolidating accurate data.

Tool Features

  • Consolidate Excel Files from a Folder and Sub-Folders
  • Consolidate data from multiple sheets into one
  • Read data based on Active Sheets, Index or Sheet Name
  • Define Header Row number and Non-Blank column

Benefits

  • Save time in consolidating data in Excel
  • Multiple options available to consolidate most accurate data

System Requirements

  • You need to have installed version of MS Excel 2010 or above

Tool Limitations

  • As the files increases, tool may take more time to consolidate data
  • All Files or Sheets should be in similar format and column sequence for accuracy
  • If the data contains formulas, then tool will first copy the data and convert it into values

How to use this tool

Follow the below video which details out how to use this tool.
  • Open the tool and you will see below screen
    Excel Files and Sheets Consolidator
  • If the macros are disabled, click on Enable Content button
    Excel Files and Sheets Consolidator
  • Click on Open Tool button
    Excel Files and Sheets Consolidator

Consolidate Excel Files from a Folder and Sub-Folders

  • To consolidate Excel files from a Folder and Sub-Folders, select “Consolidate Files from a Folder” radio button
    Excel Files and Sheets Consolidator
  • If you want to consolidate the files from the Sub-Folders as well then select “Include Sub-Folders” checkbox
    Excel Files and Sheets Consolidator
  • Click on “Browse” button and select the folder where your files as saved
    Excel Files and Sheets Consolidator
  • Select the sheet which needs to be consolidated
    Excel Files and Sheets Consolidator

    Active Sheet: Tool will consolidate data from the active sheet of each file. The sheet which is visible when you open a file is called active sheet.

    Sheet by Index: Tool will consolidate data from the sheet based on index position from the left. If you select this option, then you need to specify the index position as well
    Excel Files and Sheets Consolidator

    Sheet by Name: Tool will consolidate data from the sheet based on sheet name. If you select this option, then you need to specify the sheet name as well
    Excel Files and Sheets Consolidator

  • Select or type the row number which needs to be used as header
    Excel Files and Sheets Consolidator

  • If your data contain any non-blank column then select the checkbox and column name. Note that it is optional feature which helps to improve accuracy in data consolidation. If your data does not contain any non-blank column then leave the checkbox as unchecked
    Excel Files and Sheets Consolidator

  • Now tool is ready to consolidate the data. Click on “Start Consolidation” button
    Excel Files and Sheets Consolidator

  • Tool will start consolidating the data and show the progress on status bar. If you want to stop the tool in-between, then click on “Cancel” button
    Excel Files and Sheets Consolidator

  • Once done, you will receive confirmation message as below
    Excel Files and Sheets Consolidator

  • Data is consolidated and available in “Consolidation” sheet
    Excel Files and Sheets Consolidator

  • You can refer “Logs” sheet to check file wise summary of consolidation

Consolidate Sheets from an Excel File

  • If you have an Excel file with multiple sheets which you want to consolidate into one sheet, then click on “Consolidate Sheets from an Excel File”
  • Click on “Browse” button and select the Excel file which needs to be consolidated
  • Select or type the row number which needs to be used as header
data consolidation
  • If your data contain any non-blank column then select the checkbox and column name. Note that it is optional feature which helps to improve accuracy in data consolidation. If your data does not contain any non-blank column then leave the checkbox as unchecked
data consolidation
  • Now click on “Start Consolidation” button
  • Tool will now start consolidating the data. Once done you will receive confirmation message as below
  • Data is consolidated and available in “Consolidation” sheet
  • You can refer “Logs” sheet to check file wise summary of consolidation

Download automated tool Link given below:-

Want to buy this tool?

Recommended Articles

Excel VBA Course : Beginners to Advanced

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

Secrets of Excel Data Visualization: Beginners to Advanced Course

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *