If you have a list of items in a text file and you want to import data from a text file into Microsoft Excel, you can do that without writing them manually.

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

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?

Step 2 when importing data is the command “Data -‘ From Picture -‘ Picture from File”. On the right side you can check the data before importing or insert it directly into the spreadsheet.

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.