|
|||
![]() ![]() | |||
ASAP Utilities, description of our Excel tools![]() 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: · 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 · The utility uses the date settings as set in the Regional Settings in the Windows control panel. · 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). · Decimal separator · Thousand separator · Trailing minus for negative numbers · AutoFit column widths · Remove leading and trailing spaces Your last used settings will be remembered. Starting this utilityIn the Excel menu choose: ASAP Utilities » Import » Insert (delimited) text file...« Return to the list of “Import” tools.
You can do this too![]() Download "The one essential add-in for all Excel users." Download 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-2019 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
![]() ![]() |