If you need to convert that file from CSV to JSON, you can do that with the csvjson command like so: csvjson clients.csv > clients.json Csvkit has a couple of other handy tricks up its sleeve.

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

Some months back I developed some pyuno code for converting spreadsheets into CSV files from the command line. Pyuno being the Python interface to the OpenOffice runtime. One of the enhancement ...