We're nominated again this year for Best Microsoft Excel Add-in at the Global Excel Awards! ❤️🌟
If ASAP Utilities has helped you in Excel, you can support it with a quick vote→. It only takes about 30 seconds.
Find us in the second category: Best Microsoft Excel Add-in. You can skip other categories if you're unsure about them.
logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Monday April 6th, 2026

Tip of the Day | Monday April 6th, 2026

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

Import Data From Delimited Text File (Custom Options)...

This tool imports the contents of a delimited text file into your current worksheet, starting at the position of the active cell.
You can customize the import settings, including:
  • Delimiter options: Choose how fields are separated: space, tab, comma (CSV), semicolon, pipe (|), exclamation mark (!), or a custom character.
    You can also specify whether multiple delimiters should be treated as one, or if the file is not delimited at all.
  • Text qualifier: Specify how quoted text is handled: none, single quote ('), or double quote (").
  • Start import at row: Choose the row where the import begins (e.g., skip headers).
  • File origin: Set the text encoding, such as ANSI or UTF-8.
  • Field detection: Let Excel automatically detect field types (default), or treat all fields as text (useful to preserve leading zeros)
  • Numeric options: Choose decimal and thousands separators and whether to support trailing minus signs for negatives.
  • Additional options:
          ·  AutoFit column widths
          ·  Trim leading and trailing spaces from imported values
    Your last used settings are remembered for convenience.
    The date format follows your Windows Regional Settings (e.g., D-M-Y or M-D-Y).
    This tool is helpful when you need to:
  • Import text files with custom delimiters or encodings
  • Control how Excel interprets values during the import
  • Start importing data from a specific row
  • Avoid issues like lost leading zeros or misread numbers
    Note:
    For more even more advanced import options (such as changing data types per column and regional settings), consider using Excel's Data > Get & Transform Data tools.

    Screenshots

    Example screenshot: Import a delimited text file
    Import a delimited text file

    Starting this tool


    Import  ›  Import Data From Delimited Text File (Custom Options)...

    Choose your language preference below

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

    Trustpilot
    Download  


    • 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.