logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

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

ASAP Utilities  › Import  ›  10. 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
    Import multiple files

    Starting this tool


    Import  ›  10 Merge and Import Multiple Files (TXT, CSV, Excel, etc.)...
    Additional keywords for this tool:
    batch import Excel files, merge text files in Excel, import folder of files, stack CSV files, Excel batch merge, merge Excel and CSV files, import many files into one workbook, automate file import in Excel, combine Excel and text files, import and append data in Excel, bulk file import Excel, Excel merge utility, merge files together in a new file, import files from directory



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


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