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

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.

Click "New worksheet." Click "OK" to add the CSV file's data to a new sheet. Type the following formula into a cell in a different sheet in the workbook:=VLOOKUP ("example",Sheet2!F10:G20,2,FALSE) ...