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 JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.