logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Import » Merge and/or import multiple files...

This utility will merge multiple files from a folder together into one new file. You can also use it to import multiple files at once into your workbook.

Excel has no built-in method for merging files. It can therefore be time consuming and frustrating if you for example need to import or merge 200 Excel or CSV files. Fortunately you can use ASAP Utilities to do this quick and easy.

You can configure the following settings:
  • Start the import from a certain row, with the option to make an exception for the first file. This can be useful if you have files with fieldnames and only want these listed once.
  • Import the files into your current workbook or a new workbook.
  • Create a new worksheet for each file, or merge the data into one new sheet. With this second option the data from the files will be placed below each other.

    You can import/merge the following file formats:
  • CSV, comma delimited
  • Text, space delimited
  • Text, tab delimited
  • Text, pipe (|) delimited
  • Text file, semicolon (;) delimited
  • Text file, delimited by specified character
  • dBASE
  • Excel*
  • Lotus 123*
  • Quattro Pro*
    * Only data from the active sheet is imported

    Your last used settings and chosen folder will be remembered.

    Screenshots

    Example screenshot: Import multiple files
    Import multiple files

    Starting this utility

    In the Excel menu choose: ASAP Utilities » Import » Merge and/or import multiple files...

    « Return to the list of “Import” tools.
    «
    Insert text file (with options)...
     
      »
    Create a list of filenames and properties in a folder...
    Excel 2010 with ASAP Utilities in the menu
    Download ASAP Utilities
    Additional keywords for this tool:
    Concatenate, Combine, Directory, merge workbooks, combine workbooks, Merge files together in a new file, merge sheets, combines, consolidation

    Follow ASAP Utilities on Facebook



  • Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
    © 1999-2017 - - - - The Netherlands

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook