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.

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.