This tool imports the contents of a tab-delimited text file into your current worksheet, starting at the position of the active cell.
It splits the data into columns at each tab character and uses your system's regional settings to interpret numbers and dates.
This tool is a faster alternative to manually opening the text file and copying the data into your target sheet.
Use it when you want to:
Note:
For more advanced import options (such as changing data types and regional settings), consider using Excel's Data > Get & Transform Data tools.
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords to help you find this tool:
tab-delimited text import, insert tab-separated data, import TSV file, tab-separated values, open tab-delimited file, analyze tab-separated data, reuse tab-separated data, import plain text into worksheet, import rows from tab file, paste TSV into worksheet, import tab file into sheet, convert tab-delimited file to columns
Tip:Alt+P for the previous tool.
Tip: Alt+N for the next tool.
ASAP Utilities helps you save time and do what Excel alone can't.
You can get started right away. No training needed.
Most users start with a few tools. Many end up using ASAP Utilities daily.
Used by teams in 28,500+ organizations.
Start saving time in Excel with practical tools you can use right away.
No sign-up required.
Free 90-day trial