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.

You can convert OpenOffice.org text documents to Excel with the text import tool. Save the text document with the .txt file extension, open it in Excel and save it as an Excel spreadsheet.