How to Merge Combine Multiple Excel Files

By Ishan Bansal on September 30, 2010 | Sponsored Links

Here is a quick tutorial that explains how to merge multiple excel files into one excel. This is most helpful when all the excels have same columns, and column sequence.

We will use 2 free tools for this:

Combine Excels
Sponsored Links

Step 1: Copy all the excel files into one folder. Make sure you keep a copy of original excels also in a separate folder.

Step 2: We need to convert all the excel files to csv. For this, run free xls to csv converter on the folder in which you copied your excel files. It will quickly convert all of them to csv files.

Step 3: Now that we have converted all the excels to csv, we can easily combine them in the same way as we would merge text files. Just run the free text file merging software on your folder which has csv files, and choose to combine all of them. Make sure you do not add any separator character, or file names in the combined file. This will merge all the csv files together into one big csv file. This is exactly what we wanted.

Step 4: Open the merged CSV file with Microsoft Excel or Microsoft Excel alternatives, and choose to save it as XLS. Now you have the combined excel file that has all your original excel files.

This was a quick and easy method to combine excel files into one excel. Also check out our tutorial about how to create lookup function in Google docs.

Link to This Page:




You Might Also Like:

  1. Combine PDF Files, Split PDF: Hexonic PDF Split and Merge
  2. Merge Text Files into One For Free: TXTCollector
  3. Adolix Split Merge PDF: Split and Merge PDF Files Free
  4. Clipyard: Combine Multiple Flash files into One
  5. Merge PDF Files Online: iPDF2Merge

Be the first to know about Latest Free Software:


Posted in , | Tagged | 2 Responses

  • evelynm

    To get multiple excel files merged into one workbook, besides the steps mentioned in the article, there is also another way to do it. Using an available application Kutools for Excel will makes the combining multiple workbooks simple. With it, you don’t need to copy, and paste, and copy to a new workbook again, just one or two clicks, you can combine the files you need to a new one. Fast and neat app is.

  • Susan

    I needed to merge over 300 xls files on my PC last week. I found a really neat desktop program that did the merge in minutes – called Bulk File Merger. There is even a Mac version! Crazy simple to use program drag and drop features…