Import Data From Pipe-Delimited (|) Text File...ASAP Utilities › Import › 7. 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: 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
![]() Additional keywords for this tool: pipe-delimited text import, vertical bar separator, import pipe-separated file, load | delimited file, import .txt with pipe separator, text file pipe delimiter, open | delimited data in worksheet, import plain text with vertical bar, legacy system data import, import txt file with | separator, clean up pipe-separated data, analyze | separated file, convert pipe text file to table Choose your language preference belowEnglish (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語![]()
| ||
Home
Privacy Policy
Cookie Policy
EULA
Download
All added Excel tools
Sitemap
Contact Us
©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. |