Import Data From Text File Using Wizard...

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

Additional keywords to help you find this tool:
import text file into Excel, delimited file import, fixed-width file import, choose column format, Excel import options, decimal separator settings, import data with wizard, Excel import step by step, import txt into worksheet, custom import Excel, control Excel text import, import file with delimiters

Tip:Alt+P for the previous tool.