Home Screenshots 10 Languages Why use it?

Tip of the Day | Monday January 5th, 2026

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

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

This tool imports the contents of a pipe-delimited (|) text file into your current worksheet, starting at the position of the active cell.

It splits the data into columns at each pipe character (|) 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 pipe-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:
The pipe character (|), also known as the vertical bar, is sometimes used as a delimiter in plain text files, especially when the data may include commas or tabs. It may also be referred to as a bar, pipe, or vertical line, and is still used in legacy systems and certain export formats.
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 › 7. Import Data From Pipe-Delimited (|) Text File...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

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

Choose your language preference below

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

Yesterday's Tip

Tomorrow'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.