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
- Open a table
- Click Import in the toolbar
- Select your CSV file
- 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
- 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
- Open the table
- Click Export in the toolbar
- Select CSV
- 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
- Column Types — ensure columns accept your import data
- Filtering & Sorting — work with imported data
- Introduction to Tables — overview of all features