Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.

いまさら聞けないExcelの使い方講座 【Excel】CSVファイルは旧バージョンのテキストファイルウィザードで取り込みましょう！

JSON to Excel Converter CONVERSION TOOLS is a free online tool that lets you convert a JSON file into Microsoft Excel format. It has both free and paid plans for users.

Luckily, Excel offers handy formulas that allow you to convert text into upper case, lower case, title case, and even sentence case with minimal effort.