Try it—the results might surprise you. Stay tuned If a text file is property structured, you can open the file with Excel and go straight to work. A .csv file is the same way.

To import data from a text file into Microsoft Excel, follow this step-by-step guide: First, create a blank spreadsheet in Microsoft Excel and ensure you have the .txt file on your PC.

The resulting text document usually carries the file extension ".csv" and can be used as input into many other types of software, including database, geographic-information and page-layout programs.