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.

Locate and select the PDF file you wish to import. Excel will analyze the PDF and present a list of tables to import. Select specific or multiple tables and click ‘Load’ to import them into Excel.

You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.

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