Spreadsheet to a vector file
The code below uses the Toolbox SDK, which you can install with pip install toolbox-sdk.
Additional Python examples: using SDK, using Requests. If you prefer other programming language or need full API reference, check out Toolbox OpenAPI as well.
Docs
The tool converts spreadsheet file (XLSX, ODS, CSV) to a vector file in a format of your choice.
Input:
Spreadsheet file in ODS, XSLX or CSV format. Spreadsheet must be located on the first page (if input file format implies books) and contain fields named
latandlonfor latitude and longitude, respectively. Coordinate reference system - WGS84. Coordinates should be expressed as decimal degrees.Optional: format of an output vector file. Choose one from the list:
ESRI Shapefile
GeoPackage
GeoJSON
TAB
MIF
SQL
CSV
Optional: field type - list of field types for an output vector file, which correspond to the columns from initial spreadsheet. Should be specified without quotes and be comma separated. Possible types:
Integer, Real, String, Date (YYYY-MM-DD), Time (HH:MM:SS), DateTime (YYYY-MM-DD HH:MM:SS). Example:Integer,Real,Real,String,String,String.
Output:
ZIP-archive with vector file. You can import this file into NextGIS QGIS or NextGIS Web without unpacking.
Try the tool in action
Click on the Demo button above the tool form. The fields are filled in with demo values.
Click on the Run button.