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

Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

After converting the data sets to Table objects, you can create the relationships. To do so, click anywhere inside a Table and then click the Power Pivot tab to open the Power Pivot window.

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