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

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

Convert CSV to SQLite online

Turn CSV tables with coordinates into a SQLite database you can query with SQL. Free, private and processed right in your browser.

CSVSQLite
Other formats
Processed in your browserConverts in secondsNo account needed

How it works

How it works

How to convert CSV to SQLite

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

01

Upload your CSV file

Drop a .csv file with coordinate columns 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 CSV 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

CSV vs SQLite: what changes when you convert

CSV is built for spreadsheets, databases and BI tools. SQLite is built for SQL querying and mobile or offline apps.

CSV

What is a CSV file?

CSV (comma-separated values) is plain text where each line is a row and commas separate the columns. Location is stored in coordinate columns, such as latitude and longitude, or as WKT geometry text.

Every spreadsheet, database and BI tool reads CSV, which makes it the universal hand-off format. It has no data types, styles or coordinate system metadata.

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.

CSV

CSV

SQLite

SQLite

Structure

Structure

Plain text table

Plain text table

Single-file relational database

Single-file relational database

Best for

Best for

Spreadsheets, databases and BI tools

Spreadsheets, databases and BI tools

SQL querying and mobile or offline apps

SQL querying and mobile or offline apps

Geometry

Geometry

Latitude/longitude columns or WKT text

Latitude/longitude columns or WKT text

Stored via the SpatiaLite extension

Stored via the SpatiaLite extension

Attributes

Attributes

Untyped columns

Untyped columns

Typed columns in tables

Typed columns in tables

Coordinate system

Coordinate system

Not stored in the file

Not stored in the file

Stored in SpatiaLite metadata

Stored in SpatiaLite metadata

Opens in

Opens in

Excel, Google Sheets, Power BI, Tableau, any database

Excel, Google Sheets, Power BI, Tableau, any database

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

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

What to know before converting CSV to SQLite

Your CSV file

The CSV needs coordinate columns (latitude/longitude or X/Y) or a WKT geometry column, so every row can be placed on the map.

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 CSV to SQLite

Query with SQL

Query with SQL

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

Ship inside apps

Ship inside apps

Embed the CSV 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.