Export and import a board via CSV (with preview)
Pull a copy of your board to CSV, or bring tasks in from Monday, ClickUp or a spreadsheet, mapping each column with a preview first.
Watch this step in the video · Export and import CSV
What it's for
CSV is the bridge to move data in and out of Projects: export a copy of your board to back it up or analyze it in a spreadsheet, or import tasks coming from Monday, ClickUp, Excel or Google Sheets. The import includes a preview so you can review everything before anything is created.
Where to find it
Both actions live in the board options menu — the ⋯ ("Board options") button at the top right: Import CSV and Export CSV.
Export to CSV
- Open the board in Projects.
- Click ⋯ → Export CSV.
- A
.csvfile with your tasks and columns downloads. Open it in any spreadsheet.
Import from CSV
The import is a three-step wizard:
Step 1 — Upload file
- Click ⋯ → Import CSV.
- Drag your file in or click to choose it. Requirements: CSV (UTF-8), max 5 MB and up to 5,000 rows.
Step 2 — Map columns (preview)
- Omnifox detects the headers and shows how many columns and rows it found, with a sample row.
- For each CSV column, choose what it maps to under Maps to:
- Title (item name) — required on at least one column.
- An existing board column (Status, Date, Person, etc.).
- ➕ Create as text column — creates a new column.
- Ignore — drops that column.
- Pick the Destination group where the tasks will land.
- Click Import.
Step 3 — Result
You'll see how many rows were created (e.g. ":created of :total"), how many new columns were generated, and whether any rows were skipped because of the limit.
Verify it works
Close the wizard: the imported tasks appear in the group you chose. Switch to the Table view and confirm the Title and the mapped columns were filled in as expected.
If it doesn't work
- "Map at least one column to Title": no column is set as Title; assign Title to the one holding the task name.
- Couldn't import the file: check it's a CSV in UTF-8 and under 5 MB.
- Missing rows: if the file has more than 5,000 rows, only the first ones import; split it into parts.
- Garbled characters (accents): re-save the CSV with UTF-8 encoding.
Tips
- Before a big import, test with 10 rows to validate the mapping.
- Export the board before a bulk import: you'll have a backup to roll back to.
Related articles
Related articles
-
Organize work with Projects & boards
Create boards with groups, tasks and subitems, use columns and Kanban or List views, link tasks to deals and contacts, and automate with recipes.
-
Projects (boards): complete guide
Projects in depth, in 54 chapters: boards, columns, formulas, Kanban, Calendar, Gantt and Workload views, forms, automations, My tasks and dashboard.
-
Column types in boards
Status, date, person, number, formula and more: build boards that fit your process.
-
Kanban and List views
See the same board as draggable columns or as an ordered list, depending on what you need.
-
Recipes (automations) inside boards
Create "when this happens, do that" rules so your board works on its own.