Free · No sign-up · Files stay on your device

Free · No sign-up · Files stay on your device

Convert KML to SQLite online

Turn KML placemarks, paths and polygons into a SQLite database you can query with SQL. Free, private and processed right in your browser.

KMLSQLite
Other formats
Processed in your browserConverts in secondsNo account needed

How it works

How it works

How to convert KML to SQLite

Three steps, no software to install. Works on Windows, macOS, Linux and mobile.

01

Upload your KML file

Drop a .kml file into the converter, or click to browse. Files up to 100 MB are supported.

02

Convert in your browser

Click Convert to SQLite. The file is processed locally, so your data is never uploaded to a server.

03

Download your SQLite file

The SQLite file downloads straight to your device. Need another format? Pick a converter below.

Beyond conversion

Beyond conversion

A file is a start. A map tells the story.

Converted your KML file? Upload it to GISCARTA and turn it into an interactive map your team or clients can actually use.

Every layer, styled your way

Colour by attribute, cluster thousands of points, switch on 3D.

Dashboards with live charts

Charts and key numbers next to the map, updated as you filter.

Timeslider for change over time

Animate dated features and compare how places change.

Share with a link or embed

Publish a read-only map, embed it on your site, or keep it private with role-based access.

No credit card. No GIS degree. Upload your data and start mapping in minutes.

GISCARTA interactive map with layers and dashboards

Know your formats

Know your formats

KML vs SQLite: what changes when you convert

KML is built for viewing and sharing in Google Earth. SQLite is built for SQL querying and mobile or offline apps.

KML

What is a KML file?

KML (Keyhole Markup Language) is an XML format created for Google Earth and adopted as an OGC standard in 2008. It stores placemarks, paths and polygons together with their styles and descriptions.

KML is the easiest way to show geographic data to people who don't use GIS software, but it is built for display rather than analysis.

SQLite

What is a SQLite file?

SQLite is a self-contained, serverless SQL database stored in a single file. Each layer sits in its own table, and you can filter, aggregate and join it with standard SQL.

With the SpatiaLite extension, SQLite also stores geometry and supports spatial queries. It opens in QGIS, DB Browser for SQLite, Python, R and many mobile and desktop apps.

KML

KML

SQLite

SQLite

Structure

Structure

XML text file

XML text file

Single-file relational database

Single-file relational database

Best for

Best for

Viewing and sharing in Google Earth

Viewing and sharing in Google Earth

SQL querying and mobile or offline apps

SQL querying and mobile or offline apps

Geometry

Geometry

Points, lines, polygons, organised in folders

Points, lines, polygons, organised in folders

Stored via the SpatiaLite extension

Stored via the SpatiaLite extension

Attributes

Attributes

Name, description and extended data

Name, description and extended data

Typed columns in tables

Typed columns in tables

Coordinate system

Coordinate system

WGS84 only

WGS84 only

Stored in SpatiaLite metadata

Stored in SpatiaLite metadata

Opens in

Opens in

Google Earth, Google My Maps, QGIS, ArcGIS

Google Earth, Google My Maps, QGIS, ArcGIS

QGIS, DB Browser for SQLite, Python, R, mobile apps

QGIS, DB Browser for SQLite, Python, R, mobile apps

What to know before converting KML to SQLite

Your KML file

KML styles (icons, colours) describe how features look; attributes kept in descriptions or extended data may need tidying after conversion.

The SQLite output

Each layer becomes its own table, with geometry stored next to the attribute columns.

Privacy

Your file never leaves your device: conversion runs in your browser, for files up to 100 MB.

Use cases

Use cases

Why convert KML to SQLite

Query with SQL

Query with SQL

Filter, aggregate and join KML data with standard SQL instead of scrolling through files.

Ship inside apps

Ship inside apps

Embed the KML data in mobile and offline apps that already use SQLite.

Analyse in Python or R

Analyse in Python or R

Read the tables directly with sqlite3, pandas or R's DBI.

Free GIS file converters

Free GIS file converters

Convert between 12 GIS formats

Every converter runs in your browser and keeps your files on your device.

All converters

Start making and sharing maps and dashboards now

Upload your data — GISCARTA turns it into interactive maps and dashboards in minutes.

No credit card. No GIS degree.

Start making and sharing maps and dashboards now

Upload your data — GISCARTA turns it into interactive maps and dashboards in minutes.

No credit card. No GIS degree.