Tables

Import & Export

Learn about Import & Export in WaymakerOS.

ImportExport

Bring data into tables from CSV files and export table data for use in other tools.

Importing data

From CSV

  1. Open a table
  2. Click Import in the toolbar
  3. Select your CSV file
  4. Preview the import:
    • Waymaker maps CSV columns to table columns by matching header names
    • Adjust mappings if names don't match
    • Unmapped columns are skipped
  5. Click Import

New rows are appended to the table. Existing rows are not affected.

Import tips

  • Headers required: The first row of your CSV must contain column names
  • Type matching: Waymaker converts values to match column types (e.g., "2026-03-01" to a Date column). Invalid values are left empty.
  • Select columns: For Select-type columns, imported values must match existing options. New values are ignored unless you add them as options first.
  • Large imports: CSV files up to 10,000 rows import reliably. For larger datasets, split into multiple files.

Exporting data

To CSV

  1. Open the table
  2. Click Export in the toolbar
  3. Select CSV
  4. The file downloads containing all visible rows and columns

What's included

  • All rows matching the current filter (or all rows if no filter is active)
  • All columns
  • System columns (id, created_at, updated_at)

What's not included

  • Connection metadata
  • Table settings and permissions
  • Column type definitions (just the data values)

Bulk operations

Adding rows

Import a CSV to bulk-add many rows at once instead of creating them one by one.

Updating rows

Currently, bulk updates are done by exporting, editing in a spreadsheet tool, and re-importing with a key field configured to match existing rows.

Deleting rows

Select multiple rows by clicking row numbers (hold Shift for a range), then right-click and select Delete Selected.

Next steps