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.

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.