logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Insert (delimited) text file...

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Import  ›  2. Insert (delimited) text file...

With this utility you can import a (delimited) text file into your worksheet at the position of your active cell.

You can configure the following settings:
  • How are the fields in the text file separated:
          ·  space
          ·  tab
          ·  comma (csv)
          ·  semicolon (;)
          ·  pipe (|)
          ·  exclamation mark (!)
          ·  other: you can specify a custom delimiter
          ·  not separated
          ·  Text qualifier: none, ' or "
          ·  Start import at row
          ·  File origin
  • Date settings
          ·  The utility uses the date settings as set in the Regional Settings in the Windows control panel.
  • Field settings
          ·  Let Excel detect the field types (default)
          ·  Treat all fields as text values (this can for example help when you have problems with leading zeros that are lost).
  • Settings used to recognize numeric data
          ·  Decimal separator
          ·  Thousands separator
          ·  Trailing minus for negative numbers
  • Options
          ·  AutoFit column widths
          ·  Remove leading and trailing spaces

    Your last used settings will be remembered.


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

    Starting this tool

    Import  ›  2 Insert (delimited) text file...
    Additional keywords for this tool:
    import, textfile

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

    Empowering Excel Users Worldwide for 25 Years