Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

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.