How to Import and Open
CSV and Text Files in Excel
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Not every document you need to open is in XLSX format. Sometimes you get comma-separated value (CSV) files, other tabular data, or even plain-text files.
Luckily, Excel handle those file-formats very well (as well as easy)!
Excel contains some very useful functions for importing other types of files and converting them into spreadsheets that you can work with. It’s especially good with CSVs, but it can work with all sorts of data.
Let’s take a look at how Excel can help you with these file formats…
*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.