Convert XLTM to SQLITE
Turn XLTM documents into SQLITE. A SQLite database with one table per worksheet, named after it, hidden ones included; chart sheets and empty sheets are skipped.
Converted in an isolated sandbox on our serversDeleted after 24 hours
Drop XLTM files on the dialor turn it to pick what to do
One table for each worksheet.Each worksheet becomes a table in one SQLite file, named after the sheet.
What you get
A SQLite database in one file. Every worksheet becomes a table with the sheet's name, and hidden worksheets are included.
Each table takes its column names from the first row. Its column types come from the values in the columns.
Formulas give their last computed values, so the tables hold the results and not the formulas.
What is skipped
Chart sheets are skipped, and so are empty sheets. No table is made for them.
Choosing one sheet
Set Sheet to convert one worksheet only. Give its name or its number counting from 1. When Sheet is left out, every worksheet is converted.
The result is one file either way. To combine several databases afterward, you can merge SQLITE files.
XLTM and SQLITE.What each format is, and the options this conversion takes.
- 01 · sheet
Sheet
The one worksheet to convert, by its name or by its number counting from 1. Every worksheet is converted when it is left out.
The formats
Excel Macro-Enabled Template
An Excel template with macros enabled.
- Extensions
- .xltm
- MIME type
- application
/vnd .ms -excel .template .macroEnabled .12 - Kind
- Documents
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
In your code.The same XLTM to SQLITE conversion through the API, for your app or your agent.
$ cv convert report.xltm report.sqlite$ cv convert report.xltm report.sqliteQuestions.What people ask about XLTM to SQLITE.
Yes. Each worksheet becomes one table named after it, and hidden worksheets are included.
From the first row of the worksheet. The column types are taken from the values in the columns.
Values. Formulas give their last computed values.
Yes. Set Sheet to the sheet's name or its number counting from 1, and only that worksheet becomes a table.