Transfer data lets you move or reference data between tables in your workspace. Click the "Transfer data" button in the table toolbar to choose from three transfer types.

Looks up and matches rows from another table against your current table. Useful for checking duplicates, verifying entries, or referencing data across different tables. Each row in your current table is checked against the target table and the result is stored in a new column.

1. Click "Transfer data" in the toolbar and select "Match rows from other table".
2. Select the "Table to search" — the table where you want to find matching rows.
3. Select the "Target column" — the column in the target table to match against your values.
4. Choose a "Filter operator" — "Equals" for exact matches or "Contains" for partial matches.
5. Set the "Row value" — the value from your current row to match against the target column. Type text or use "/" to insert a column token (e.g. /Country).
6. Set a "Limit" to cap the number of matched rows returned per row. The total match count is still tracked even when a limit is applied.
7. Optionally enable "Run only if this formula resolves to true" to add a condition for when the transfer should run.
8. Toggle "Auto-update" — when enabled, the column will re-run automatically whenever the "Row value" input changes.
9. Click "Save" to create the column.

Transfers selected data fields from your current table to another table. Choose the destination and map which columns to send for flexible data routing and workflow management.

1. Click "Transfer data" in the toolbar and select "Send rows to other table".
2. Select the "Destination" — the target table where your data will be sent.
3. Under "Data to send", check the columns you want to transfer. Use "Select all" to include every column.
4. Toggle "Update existing rows on re-run" to update the matching row in the destination table instead of creating a duplicate when the transfer runs again.
5. Toggle "Auto-extract new columns" to automatically create new columns in the destination table for any incoming data fields that don't yet exist there.
6. Optionally use "Run only if this formula resolves to true" to add a condition. Describe the formula in plain language and click "Generate", or write your own expression and click "Test".
7. Toggle "Auto-update" — when enabled, the transfer will re-run automatically whenever any of the selected "Data to send" columns change.
8. Click "Save" to activate the transfer.

Converts multiple columns into individual rows in another table. Use this when a single row contains several related items (e.g. Employee name, Employee name (1), Employee name (2)) and you want each item to become its own row in the destination table, with shared context columns copied alongside it.

1. Click "Transfer data" in the toolbar and select "Send rows for each item to other table".
2. Select the "Destination" — the target table where the new rows will be created.
3. Under "Columns to become rows", use "/" to select the columns containing the items that should each get their own row (e.g. /Employee_name, /Employee_name_1, /Employee_name_2).
4. Under "Data that stays in every row", check the columns whose values should be copied into every new row created (e.g. Company name).
5. Toggle "Auto-extract new columns" to automatically create new columns in the destination table for any incoming data fields that don't yet exist there.
6. Optionally use "Run only if this formula resolves to true" to add a condition. Describe the formula in plain language and click "Generate", or write your own expression and click "Test".
7. Toggle "Auto-update" — when enabled, the transfer will re-run automatically whenever any of the "Data to send" columns or "Columns to become rows" inputs change.
8. Click "Save" to activate the transfer.