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

You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. ... Alternatively, you could find the icon from the Desktop. 2] Start a new Spreadsheet.

And that’s how we can manipulate XLS, JSON, and CSV files with csvkit. This tool might not be used very often, but when you need it, you’ll be happy it’s around.