Convert SQLITE to XLTX

Turn SQLITE files into XLTX 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 Excel template for each table.Each table in the database becomes its own XLTX workbook with one sheet.

  1. What you get

    One workbook per table, named after the table. Each workbook holds a single sheet with that table's data.

    Each file is saved as a template, so Excel opens a new copy of it instead of the file itself.

  2. How values are typed

    Numbers, dates and times become typed cells, so Excel treats them as numbers, dates and times. Codes with a leading zero stay text, so the zeros are kept.

    A table that has text stored in a number column fails to convert.

  3. What is skipped

    Views are skipped. Only tables produce a workbook.

    To go the other way, use XLTX to SQLITE.

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

Excel Template

An Excel template.

Extensions
.xltx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.template
Kind
Documents

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

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

Questions.What people ask about SQLITE to XLTX.

01OF 04

One XLTX file per table, each named after its table. A database with several tables gives several files.

No. Views are skipped, and only tables produce a workbook.

Yes. Codes with a leading zero stay text, so the zeros are not dropped.

A table fails when text is stored in a number column. Numbers, dates and times become typed cells, so a column that mixes in text stops the conversion.

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