Import each table data in a HTML file to a separate SQLite table

Want to import data from each table in a HTML file to a separate SQLite table?

Try Withdata FileToDB, a HTML to SQLite converter, Import each table data in a HTML file to a separate SQLite table, Easy and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Import HTML to SQLite locally and privately, avoid uploading HTML file(s) to online services.
• Support Windows, Linux, and macOS.

Download Withdata FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import data from each table in a HTML file to a separate SQLite table

Select tables in HTML file -> Set SQLite tables -> Import HTML data to SQLite

Choose SQLite and logon.

Click “Wizard – 1 File To N Tables” at task dialog.

Select the “HTML” file type.

then show the wizard.

1. Open a HTML file, select tables.

2. Show existing SQLite tables, choose “Import Type”.

3. Set SQLite tables.

4. Show summary, set “Convert Rows”.

5. Import data from each table in a HTML file to a separate SQLite table.

View imported data in SQLite table

---

More about HTML file to SQLite converter

HTML → SQLite reference

Type mapping

Value kind	in HTML	in SQLite
Int	<td>1234</td>	INTEGER
Bigint	<td>9007199254740993</td>	INTEGER
Decimal	<td>1234.56</td>	NUMERIC
Float	<td>1.234e+10</td>	REAL
Text	<td>text</td>	TEXT
Long text	<td>multi-line text</td> (entities for &amp; &lt;)	TEXT
Date	<td>2026-09-18</td>	TEXT
Datetime	<td>2026-09-18 14:30:00</td>	TEXT
Binary	not representable in a cell	BLOB
Boolean	<td>true</td>	INTEGER
JSON	<td>{&quot;a&quot;:1}</td> (quotes escaped)	TEXT

Dialect differences

HTML is a file format and SQLite is a database server, so the target has to be told the types the file never carried - the rows below are where the two sides diverge.

Property	in HTML	in SQLite
port	—	(file-based)
identifiers	Attribute values in quotes; entities for reserved characters	"double quotes" or [brackets]
row limit	—	LIMIT n
dates	Whatever text was rendered	TEXT (no date type)
long text	—	TEXT
binary	data: URIs inside src attributes	BLOB
separator	Tags, not delimiters	—
encoding	Declared in a meta charset tag or the HTTP header	—
typing	None	—
shape	Free form; tables are row/column structures inside markup	Tables of rows and columns
ceiling	No formal limit	—

Command line

Side	Command
SQLite	sqlite3 .dump
SQLite (load)	.import (sqlite3)

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.