# 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 as `Mã đơn` becomes `ma_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

1. When you create a workspace (or under **Data sources → Add source**), pick the **Excel file** card and click **Upload file**.
2. Choose the file in the **Data file (.xlsx)** field. Only `.xlsx` is accepted.
3. 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

- [Personal data masking](/en/docs/review/pii)
- [Quickstart](/en/docs/quickstart)
- [Excel connector page](/en/connectors/excel)
