Ajamall family site · File Converters
Home › Data formats › Convert SQLite to CSV / ZIP
Data formats

Convert SQLite to CSV / ZIP

Convert SQLite to CSV / ZIP right in your browser. Your file is not uploaded to a server.

How to use it

  1. Drag your .db .sqlite .sqlite3 .db3 files onto the area above, or press "Choose files".
  2. If options are shown, set them as you like. They appear below the file list.
  3. Press "Convert". The conversion runs on your device, shows its progress and can be cancelled at any time.
  4. Press "Download" next to a result. With several results, "Download all as ZIP" gets them in one go.
  5. The first time, the page downloads the conversion program (about 0.3 MB). It is kept on your device, so later visits do not download it again. Your files are not sent during this step either.

The formats involved

SQLite .db .sqlite .sqlite3 .db3

An SQLite database is a database stored in a single file. The file starts with the string "SQLite format 3" followed by a NUL character (SQLite Database File Format).

CSV .csv

CSV is a text format that writes a table with columns separated by commas. RFC 4180 describes CRLF as the record delimiter and how values are enclosed in double quotes.

ZIP .zip

ZIP bundles several files into one, optionally compressing them (PKWARE APPNOTE 4.1). The specification has a bit (bit 11) that marks file names as UTF-8.

Typical uses: sending many files at once · archiving a folder

What changes in this conversion

  • Every table becomes one file; BLOB values are written as Base64 text and 64-bit integers are written exactly. Views, indexes and triggers are not exported.

Limits and things to watch for

  • On a phone, large files can be slow or fail because of memory limits.
  • The file size that can be processed depends on your device. The limit for your device is shown in the drop area, and files above it are refused with a message.
  • The database is built in the browser memory, so a very large input may not be processed on a phone.

FAQ

Is my file uploaded to a server?

No. Conversion happens only inside this browser, and file names, contents and results are not sent to our servers. Some converters download their conversion program (code) the first time you use them; your files are not sent then either. See the privacy page for details.

Can I convert many files at once?

Yes. Select several files and they are processed one after another; save the results one by one or all at once as a ZIP. How much can be handled at once depends on your device memory and is shown on the page.

Korean or Japanese text is garbled when I open the CSV in a spreadsheet program. What should I do?

CSV results get a UTF-8 BOM at the start by default, because spreadsheet programs often need it to read Korean and Japanese correctly. You can switch it off in the options, and it is off by default for TSV.

Licences and the software used

Programs this converter downloads and uses: sql.js 1.15.2 (MIT) · Open-source licenses

Sources and check date

Date we opened the original documents ourselves: 2026-11-10. Specifications can change, so read the original again before anything important.

How we verify · Sources · What this site does not do