Free Online GIS Converter
Convert CSV with Lat/Lng to WKT Geometries
Spreadsheets and CSV exports often store spatial locations as separate latitude and longitude columns. Converting CSV coordinates to standard WKT POINT geometries allows fast bulk insertion into spatial databases and OGC GIS tools.
Input (CSV)
WKT geometries
SQL & Code Example
How to perform this conversion directly in your PostgreSQL / PostGIS database:
-- Create WKT Point in PostGIS from CSV lat/lon columns SELECT ST_AsText(ST_SetSRID(ST_MakePoint(longitude, latitude), 4326)) AS wkt FROM raw_csv_table;
Frequently Asked Questions
Which comes first: latitude or longitude in WKT?+
In WKT, longitude (X coordinate) always comes first, followed by latitude (Y coordinate): POINT(longitude latitude).
Can I upload a CSV file with custom columns?+
Yes. Use the Import CSV tool in WKT Studio to map columns visually and generate your spatial dataset.
WKT Geometry Reference
Not sure your input is valid? Each geometry type has its own page with syntax rules, the mistake that most often breaks it, and PostGIS and Shapely recipes.