Excel files
Prepare an .xlsx file for DataxLand — one sheet per table, a data_dictionary sheet describing the columns, size limits — then upload it and replace the file when new numbers arrive.
1. One sheet per table
- Row 1 holds the column names. No blank header cells, no two columns with the same name.
- Up to 200,000 rows per sheet and 50 MB per file. Empty sheets are skipped with a warning.
- Sheet and column names are normalised to lowercase ASCII joined by underscores (
Order ID→order_id; accents are stripped, so a Vietnamese header such asMã đơnbecomesma_don). - Values are loaded as-is, as text; numeric and date types are inferred in a later step.
2. The data_dictionary sheet
This sheet helps Si understand your data faster and more accurately. Without it DataxLand still reads the file, with a warning that column types and meanings are inferred from the data. If you include it, all four required columns must be present.
| Column | Required | Contents |
|---|---|---|
table_name | Yes | Sheet name |
column_name | Yes | Column name; * is a row describing the whole table |
data_type | Yes | Type in the original system, e.g. VARCHAR(50), DECIMAL(15,0), DATE |
description | Yes | What the column means |
key | No | PK, FK or PK, FK; several PK columns form a composite key |
references | No | The referenced column, e.g. products.sku |
pii | No | Y for personal data (name, phone, email, address) |
Columns marked pii = Y are always masked; they cannot be unticked in the column-selection step.
3. Upload
- When you create a workspace (or under Data sources → Add source), pick the Excel file card and click Upload file.
- Choose the file in the Data file (.xlsx) field. Only
.xlsxis accepted. - Click Create workspace and read data, or add the source. Blocking errors (blank header cell, duplicate column, too many rows) are shown with the sheet name.
4. Replace the file when you have new numbers
The Free plan has no refresh schedule. When new numbers arrive, open Data sources, card Replace file, choose New file (.xlsx) and click Replace file and refresh. Keep the sheet and column names unchanged so the approved mapping still applies.
Related
Verified numbers
Data quality checks after every build, reconciliation against the source before publishing, the data health page and how DataxLand hides a metric when the numbers make no sense.
PostgreSQL
Connect a PostgreSQL database with a read-only user, pick tables, and sync with full reload, incremental or CDC; CDC requirements on self-managed Postgres, RDS, Cloud SQL, Neon and Supabase.