This tool imports the contents of a comma-delimited (CSV) text file into your current worksheet, starting at the position of the active cell.
It splits the data into columns wherever a comma is found 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:
Note:
CSV files are one of the most common formats for data exchange between systems.
For more advanced import options (such as changing data types or 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:
csv to worksheet, csv file import, comma delimited file, comma-separated values, csv import Excel, load csv data, insert csv into Excel, text to columns csv, import csv values, csv import with regional settings, convert csv to worksheet, read csv file, data import csv
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