If your Excel files are opening in Notepad on Windows PC, here's how you can reset the settings to make .xls, .xlsx, etc files open in Excel.

Export your Microsoft Excel spreadsheets to CSV files effortlessly. Enhance data sharing and transfer across platforms with this new feature.

Now, opening a JSON file is not hard, however, it would make more sense to convert it to the Microsoft Excel (CSV) format for easier use. The question is, how does one convert a JSON file to Excel?

Open Folder Options in the control panel. Go to the File Types tab, scroll down to Microsoft Excel Worksheet (.xls not .csv) and click Advanced.

If the DAT file you're trying to open is text, you can convert the file into text in the Microsoft Excel program by first saving it as a CSV file.