Report issues, suggest features or give any general feedback. Thank you in advance!

Convert JSON to SQLite

Add your JSON data and automatically convert it to SQLite.

JSON input options

Flatten objects

SQLite output options

Table name

Create table

JSON

JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write and easy for machines to parse and generate.

JSON has become the de facto standard for data exchange on the web, and it is widely used in APIs.

Character encoding

As stated by the RFC 8259, we expect strings in uploaded JSON files to be encoded in UTF-8.

If your file contains non UTF-8 characters, you might get an error when parsing your data.

SQLite

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine.

It's the most used database engine in the world, embedded in many applications. SQLite is serverless and requires zero configuration, making it ideal for local/client storage in application software.

Convert JSON

JSON to CSV JSON to Excel JSON to NDJSON JSON to JSONLines JSON to TSV JSON to HTML Table JSON to XML JSON to Parquet JSON to Arrow JSON to Avro JSON to Avro schema JSON to SQL JSON to SQLite JSON to MySQL JSON to PostgreSQL JSON to Markdown Table JSON to PDF JSON to TXT JSON to LaTeX Table

15 Dec, 2022

Avro vs JSON: What are the differences?

21 Sep, 2022

Convert JSON to CSV in Python 3 using Pandas

27 May, 2022

Import JSON into Postgres using COPY

16 Oct, 2022