Tip of the Day | Saturday 29 August 2026

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:

• Open the data from structured space-delimited files directly in your existing worksheet
• Analyze or convert plain text data exports
• Reuse text file data for reporting, calculations, or cleanup tasks

Note:
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