Convert SQLITE to XLS

Turn SQLITE files into XLS 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

One workbook for each table.Each table in the database becomes its own XLS file with a single sheet.

  1. What you get

    One XLS workbook per table. Each workbook is named after its table and holds one sheet. Views in the database are skipped, so they produce no file.

    Numbers, dates and times become typed cells. Codes with a leading zero, such as a postal code, stay text.

  2. What does not fit

    The Excel 97-2003 format has fixed limits. Rows past 65,536 and columns past 256 do not fit, and they are dropped without a warning. A table larger than that comes out cut off, and nothing tells you.

  3. When a table fails

    A table with text stored in a number column fails. The other tables are not mentioned in that rule, so check the files you get against the tables you expect.

SQLITE and XLS.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 · XLS

Excel 97-2003 Workbook

The binary Excel workbook format from Excel 97 through 2003, and its templates (.xlt). WPS Spreadsheets saves the same format as .et and .ett.

Extensions
.xls .xlt .et .ett
MIME type
application/vnd.ms-excel
Kind
Documents

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

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

Questions.What people ask about SQLITE to XLS.

01OF 04

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

They are skipped. Only tables produce workbooks.

Yes, if they pass the limits. Rows past 65,536 and columns past 256 are dropped without a warning.

Yes. They stay text, so the leading zero is kept.

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