The Text Import Wizard can replace existing data in a worksheet when it brings in new text. Use a blank worksheet so you don't risk overwriting your current data.

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.