Workbook workbook = WorkbookFactory.create( inp ) įor ( Iterator rowsIT = sheet.rowIterator() rowsIT.hasNext() )įor ( Iterator cellsIT = row.cellIterator() cellsIT. The first line of the CSV input is taken as the Column Heading. FileInputStream inp = new FileInputStream( file ) Free tool to convert the data in CSV format to JSON format. Download binary from the releases page (Linux/Windows/macOS). Please refer to godoc and example for usage as a library. The difference from these tools is that the syntax of PostgreSQL or MySQL can be used. Here's some pseudo code for the basic usage. CLI tool that can execute SQL queries on CSV, LTSV, JSON and TBLN. I just wrote one for a client and it took only a couple hours including researching tools.Īfter that it's just a matter of iterating through the rows in the Excel data and building a JSON structure. We will automatically identify the fields if we can based on the column headings and the data. If you can't find an existing solution it's pretty easy to build a basic one in Java. CSV To GeoJSON Converter Your delimited data must have a longitude and latitude.

Csv to json converter