Write a Visual Basic Script (VBS). Save the VBS file. Open Command Prompt in the folder. Enter the CSV to Excel conversion command. Let’s discuss these steps in detail! Firstly, open the Notepad ...
You could then load the CSV into Excel, convert it into a table ... Excel can handle JSON. So, you try to open the file in Excel using its data import tooling, which usually works very well ...