Home Screenshots 10 Languages Why use it?

Tip of the Day | Monday March 23rd, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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

Example screenshot: 2

Example screenshot: 3

Example screenshot: 4

Example screenshot: 5

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 › Import Data From Text File Using Wizard...

Choose your language preference below

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

Today's Tip

Download

©1999-2026 ∙ 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.