JSON comes into play whenever data is being sent from a server to a webpage, something that happens on a regular basis. Related: Online JSON Tools is a collection of useful JSON utilities.

But things have changed at Twitter, and if you request a download of your data it comes as a set of JSON files. That shouldn't be a problem, after all, Excel can handle JSON. So, you try to open ...

Even importing data can be a complicated process. But Microsoft Excel’s mobile app allows you to take a picture of a table and paste the information directly into your spreadsheet.