Tip of the Day | Sunday 15 November 2026

This tool imports the contents of a text file into your current worksheet, starting at the position of the active cell.

It uses Excel's built-in Text Import Wizard to guide you through the process. The wizard lets you control how the data is structured and imported, including:

• Whether the file is delimited or fixed-width
• Which delimiter is used (e.g., comma, tab, semicolon)
• Which column formats to apply (e.g., general, text, date)
• Adjust advanced options like the decimal and thousands separators to match your source data

This gives you full control over how Excel reads and inserts the data.

Use this tool when you want to:

• Import files with non-standard or mixed delimiters
• Manually define how Excel handles numbers, dates, or text
• Skip extra steps like opening the file separately and copying the data manually

This tool is a quick alternative to opening the text file manually and copying the contents into your target sheet.

Starting this tool