Convert SQLITE to XLSX

Turn SQLITE files into XLSX files. One workbook per table, named after it, with one sheet; views are skipped.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQLITE files on the dialor turn it to pick what to do

Each table becomes its own workbook.Tables turn into XLSX files with typed cells. Views are skipped.

  1. What you get

    One XLSX workbook for each table in the database. Each workbook is named after its table and holds one sheet. The conversion returns one or more files, depending on how many tables the database has.

    Numbers, dates and times become typed cells, so they behave as numbers, dates and times in the spreadsheet. Codes with a leading zero stay text, so the zero is kept.

  2. What it leaves behind

    Views are skipped. Only tables are written out, so a view in the database has no workbook of its own.

  3. When it stops

    A table with text stored in a number column fails the conversion. If the file cannot be parsed at all, it stops with input_corrupted.

    To go the other way, use XLSX to SQLITE.

SQLITE and XLSX.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same SQLITE to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report/ --to xlsx
$ cv convert report.sqlite report/ --to xlsx

Questions.What people ask about SQLITE to XLSX.

01OF 04

Yes. Each table becomes one workbook named after it, with one sheet.

No. Views are skipped, and only tables are written out.

No. Codes with a leading zero stay text, so the zero is kept. Numbers, dates and times become typed cells.

The file could not be parsed. The conversion stops with input_corrupted when that happens.

More conversions.Other ways in and out of SQLITE and XLSX.