Convert SQLITE to DIF

Turn SQLITE files into DIF files. One DIF table of values in UTF-8 per table, named after it, with a header row; 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

Every table as a DIF file.Each table in the database becomes its own DIF spreadsheet.

  1. What you get

    One DIF file per table, named after the table. Each file holds the table's values in UTF-8 and starts with a header row.

    The output is one or more files, so a database with several tables gives you several DIF files.

  2. What it skips

    Views are skipped. Only tables are written, so a view in the database has no DIF file of its own.

  3. When a table fails

    A table with text stored in a number column fails. The conversion cannot place that text in a column of numbers.

    To go the other way, use DIF to SQLITE.

SQLITE and DIF.What each format is.

The formats

From · 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
To · DIF

Data Interchange Format

Data Interchange Format spreadsheets.

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

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

terminal
$ cv convert report.sqlite report/ --to dif
$ cv convert report.sqlite report/ --to dif

Questions.What people ask about SQLITE to DIF.

01OF 04

Yes. Every table becomes one DIF file named after the table, with a header row.

No. Views are skipped and only tables are written.

UTF-8.

A table has text stored in a number column. That table fails the conversion.

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