If the file has a .csv file extension, another program such as Microsoft Excel might open and display the file. If Windows displays a pop-up window named "Open With," proceed to the next step.

Go to the File Types tab, scroll down to Microsoft Excel Worksheet (.xls not .csv) and click Advanced. Uncheck 'Browse in same window' (or 'Open Web documents' in place) and OK.

Open Windows Explorer and locate a .csv file and right click on it. From the subsequent menu, choose Open With and choose Excel. Tick the box that says "always use this program to open these files".

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