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.
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.
What it leaves behind
Views are skipped. Only tables are written out, so a view in the database has no workbook of its own.
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
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
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.
$ cv convert report.sqlite report/ --to xlsx$ cv convert report.sqlite report/ --to xlsxQuestions.What people ask about SQLITE to XLSX.
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.