Convert XLTM to DBF

Turn XLTM documents into DBF files. Each sheet, hidden ones included, becomes its own dBASE III table with formulas as their last results and the first row as field names, cut to 10 Latin letters, digits and underscores (FIELD1 and so on when none are left).

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 sheet of your template.Each sheet becomes its own dBASE III table, with the first row as field names.

  1. What you get

    One DBF file for each sheet in the XLTM file, hidden sheets included. Formulas are written as their last results, so the table holds values, not formulas.

    The first row of a sheet becomes the field names. Numbers, dates and true/false values become typed fields. Other cells become text.

  2. What changes

    Field names are cut to 10 Latin letters, digits and underscores. If none are left, the field is named FIELD1 and so on.

    Text cells hold up to 254 bytes. They are written in the Windows code page that fits the text, or in UTF-8 when none does.

XLTM and DBF.What each format is.

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 · DBF

dBase Table

dBase tables, the attribute tables of shapefiles and many legacy databases.

Extensions
.dbf
MIME type
application/x-dbf
Kind
Documents

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

terminal
$ cv convert report.xltm report/ --to dbf
$ cv convert report.xltm report/ --to dbf

Questions.What people ask about XLTM to DBF.

01OF 04

Yes. Each sheet becomes its own dBASE III table, and hidden sheets are included. The result is one or more files.

They are written as their last results. The DBF file holds those values, not the formulas.

The first row of each sheet gives the field names. They are cut to 10 Latin letters, digits and underscores, and FIELD1 and so on are used when none are left.

Yes. Text cells hold up to 254 bytes. The encoding is the Windows code page that fits, or else UTF-8.

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