Tip of the Day | Friday April 10th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Merge and Import Multiple Files (TXT, CSV, Excel, etc.)...

This tool lets you import or merge multiple files from a folder into Excel in one go.

You can choose to:

Import each file into its own worksheet

Merge the contents of all files into a single sheet (stacked vertically)

You can also:

Start the import from a specific row (e.g., skip headers)

Apply special handling for the first file (e.g., include headers only once)

Import into the current workbook or create a new one

Supported file types include:

CSV and other text files: comma-, tab-, semicolon-, space-, pipe (|)-, exclamation mark (!)-delimited, or a custom delimiter

Excel formats:
      ·  Excel Workbook (.xlsx)
      ·  Excel Macro-Enabled Workbook (.xlsm)
      ·  Excel Binary Workbook (.xlsb)
      ·  Excel 97-2003 Workbook (.xls)
      ·  Strict Open XML Spreadsheet (.xlsx)
      ·  Excel Template (.xltx)
      ·  Excel Macro-Enabled Template (.xltm)
      ·  Excel 97-2003 Template (.xlt)
      ·  XML Spreadsheet (.xml)
      ·  OpenDocument Spreadsheet (.ods)
      ·  Microsoft Excel 5.0/95 Workbook (*.xls)

dBASE files (*.dbf)
For multi-sheet spreadsheet files, only the active sheet from each file is imported.

Your last used settings and folder location are remembered.

This tool is ideal when you want to:

Combine hundreds of files into one workbook quickly

Eliminate repetitive manual file opening and copying

Prepare datasets for analysis or reporting

Note:
For more advanced import and transformation tasks, consider using Excel's built-in Power Query (Data > Get & Transform Data).

Screenshots

Example screenshot: Import multiple files

Starting this tool

Click ASAP Utilities › Import › 10. Merge and Import Multiple Files (TXT, CSV, Excel, etc.)...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Import › Merge and Import Multiple Files (TXT, CSV, Excel, etc.)...

Choose your language preference below

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

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.