To import data from a text file into Microsoft Excel, follow this step-by-step guide: Once you paste the text (containing numbers) in the cell, you can change the cell data type to a number.