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

ASAP Utilities › Import › 8. 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 › 8 Import Data from Exclamation-Delimited (!) Text File...

Additional keywords for this tool:
exclamation mark separator, ! delimited, import delimited file, data import, legacy file format, text file into Excel, split by exclamation, open ! file in Excel, import export data file, legacy system data

Choose your language preference below

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

Import Data From Pipe-Delimited (|) Text File...

Import Data From Text File Using Wizard...

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.