Home Screenshots 10 Languages Why use it?

Tip of the Day | Thursday December 18th, 2025

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

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

This tool imports the contents of a text file that uses the exclamation mark (!) as a delimiter, inserting the data into your current worksheet starting at the position of the active cell.

It splits the data into columns at each exclamation mark and uses your system's regional settings to interpret numbers and dates.

This tool is a faster alternative to manually opening the file and copying the data into your target sheet.

Use it when you want to:

Open data from structured exclamation-delimited files directly in your existing worksheet

Analyze or convert plain text data exports that use ! as the separator

Reuse text file data for reporting, calculations, or cleanup tasks

Note:
Although rare today, some legacy systems or custom exports may use the exclamation mark (!) as a delimiter to avoid conflicts with more common characters like commas or tabs.
For more advanced import options (such as changing data types or regional settings), consider using Excel's Data > Get & Transform Data tools.

Starting this tool

Click ASAP Utilities › Import › 8. Import Data from Exclamation-Delimited (!) Text File...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

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

Choose your language preference below

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

Today's Tip

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.