Sources one by one

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.

ColumnRequiredContents
table_nameYesSheet name
column_nameYesColumn name; * is a row describing the whole table
data_typeYesType in the original system, e.g. VARCHAR(50), DECIMAL(15,0), DATE
descriptionYesWhat the column means
keyNoPK, FK or PK, FK; several PK columns form a composite key
referencesNoThe referenced column, e.g. products.sku
piiNoY 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.

Markdown