The ASAP Utilities menu in Excel (English)
Import Data From Space-Delimited Text File...
ASAP Utilities › Import › 4. Import Data From Space-Delimited Text File...This tool imports the contents of a space-delimited text file into your current worksheet, starting at the position of the active cell. It splits the data into columns wherever one or more space characters appear (multiple consecutive spaces are treated as a single separator). It uses your system's regional settings to interpret numbers and dates. This tool is a faster alternative to manually opening the text file and copying the data into your target sheet. Use it when you want to:
For more advanced import options (such as changing data types and regional settings), consider using Excel's Data > Get & Transform Data tools.
Starting this tool
- Click ASAP Utilities › Import › 4. Import Data From Space-Delimited Text File...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
space separated file, import text file, parse space-separated data, import data from text file, read plain text data, import data using space separator, convert space-delimited file, import plain text, insert text file into Excel, text file to table, load space-separated data, paste structured text, import fixed format text
space separated file, import text file, parse space-separated data, import data from text file, read plain text data, import data using space separator, convert space-delimited file, import plain text, insert text file into Excel, text file to table, load space-separated data, paste structured text, import fixed format text
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Import Data from dBASE (.dbf) File... |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 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.
🏆 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.