Import Data From Text File Using Wizard...

ASAP Utilities › Import › 9. 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.

Screenshots

Example screenshot: 1

1, Import › 9 Import Data From Text File Using Wizard...

Example screenshot: 2

2, Import › 9 Import Data From Text File Using Wizard...

Example screenshot: 3

3, Import › 9 Import Data From Text File Using Wizard...

Example screenshot: 4

4, Import › 9 Import Data From Text File Using Wizard...

Example screenshot: 5

5, Import › 9 Import Data From Text File Using Wizard...

Starting this tool

Click ASAP Utilities › Import › 9. Import Data From Text File Using Wizard...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Import › 9 Import Data From Text File Using Wizard...

Additional keywords for 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

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Import Data from Exclamation-Delimited (!) Text File...

Merge and Import Multiple Files (TXT, CSV, Excel, etc.)...

Download

©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.