If you want to convert Google Earth KML files to Excel (XLS, XLSX) or CSV format, you can use these free converter software and online tools.

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.

What makes a CSV file unique is the way its content is organized. Here's what you need to know about CSV files and how to use them.