Convert WQ1 to DBF

Turn WQ1 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 WQ1 files on the dialor turn it to pick what to do

Quattro Pro sheets as dBASE tables.Each sheet becomes its own table, with the first row as field names.

  1. What you get

    Each sheet in the WQ1 file becomes its own dBASE III table, hidden sheets included. You get one or more DBF files, one per sheet.

    Formulas are written as their last results. Numbers, dates and true/false values become typed fields.

  2. How cells are written

    The first row of each sheet becomes the field names. A name is cut to 10 Latin letters, digits and underscores. When none are left, the field is named FIELD1 and so on.

    Other cells become text of up to 254 bytes. The text is written in the Windows code page that fits, or else in UTF-8.

WQ1 and DBF.What each format is.

The formats

From · WQ1

Quattro Pro for DOS Spreadsheet

Spreadsheets from Quattro Pro for DOS 1 to 4, Borland's rival to Lotus 1-2-3.

Extensions
.wq1
MIME type
application/x-quattro-pro
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 WQ1 to DBF conversion through the API, for your app or your agent.

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

Questions.What people ask about WQ1 to DBF.

01OF 04

Yes. Each sheet becomes its own table, and hidden sheets are included.

They are written as their last results, not as formulas.

They come from the first row. Each is cut to 10 Latin letters, digits and underscores, and FIELD1 and so on are used when none are left.

They become typed fields, the same as numbers. Other cells are written as text.

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