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.

  1. 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.

  2. What is skipped

    Chart sheets are skipped, and so are empty sheets. No table is made for them.

  3. 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.

  1. 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

From · XLTM

Excel Macro-Enabled Template

An Excel template with macros enabled.

Extensions
.xltm
MIME type
application/vnd.ms-excel.template.macroEnabled.12
Kind
Documents
To · 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

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

terminal
$ cv convert report.xltm report.sqlite
$ cv convert report.xltm report.sqlite

Questions.What people ask about XLTM to SQLITE.

01OF 04

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.

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