logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

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

Import » 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
          ·  Thousand separator
          ·  Trailing minus for negative numbers
  • Options
          ·  AutoFit column widths
          ·  Remove leading and trailing spaces

    Your last used settings will be remembered.

    Screenshots

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

    Starting this utility

    In the Excel menu choose: ASAP Utilities » Import » Insert (delimited) text file...

    « Return to the list of “Import” tools.
    « Previous
    Insert Excel file...
     
     Next »
    Insert dBASE file...
    Excel 2010 with ASAP Utilities in the menu
    Download ASAP Utilities
    Additional keywords for this tool:
    import, textfile

    Follow ASAP Utilities on Facebook



  • Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
    © 1999-2017 - - - - The Netherlands

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook