logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Import Data From Text File Using Wizard...

ASAP Utilities  › Import  ›  9. Import Data From Text File Using Wizard...

This tool imports the contents of a text file into your current worksheet, starting at the position of the active cell. It uses Excel's built-in Text Import Wizard to guide you through the process. The wizard lets you control how the data is structured and imported, including:
  • Whether the file is delimited or fixed-width
  • Which delimiter is used (e.g., comma, tab, semicolon)
  • Which column formats to apply (e.g., general, text, date)
  • Adjust advanced options like the decimal and thousands separators to match your source data This gives you full control over how Excel reads and inserts the data. Use this tool when you want to:
  • Import files with non-standard or mixed delimiters
  • Manually define how Excel handles numbers, dates, or text
  • Skip extra steps like opening the file separately and copying the data manually This tool is a quick alternative to opening the text file manually and copying the contents into your target sheet.

    Screenshots

    Example screenshot: 1
    1, Import  ›  9 Import Data From Text File Using Wizard...
    Example screenshot: 2
    2, Import  ›  9 Import Data From Text File Using Wizard...
    Example screenshot: 3
    3, Import  ›  9 Import Data From Text File Using Wizard...
    Example screenshot: 4
    4, Import  ›  9 Import Data From Text File Using Wizard...
    Example screenshot: 5
    5, Import  ›  9 Import Data From Text File Using Wizard...

    Starting this tool


    Import  ›  9 Import Data From Text File Using Wizard...
    Additional keywords for this tool:
    import text file into Excel, delimited file import, fixed-width file import, choose column format, Excel import options, decimal separator settings, import data with wizard, Excel import step by step, import txt into worksheet, custom import Excel, control Excel text import, import file with delimiters



  • 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.