Moving from Notion
Notion exports each database as a CSV file. Put them in one spreadsheet, tidy five kinds of column, and the assistant builds the lists and the links between them, and brings your records in.
Out of Notion
- Export each database.
- Open the database, click ••• at the top right, then Export, and choose Markdown & CSV. The zip holds the database as a CSV file, with a Markdown file for each of its pages.
- A view with everything.
- Notion exports the current view or the default view, not all views at once. Pick a view that shows every property and has no filter.
- One workbook.
- Open the CSVs in Excel, Google Sheets, Numbers or LibreOffice and put each on a sheet of one workbook, named after its database. Save it as .xlsx. A relation becomes a link only when the database it points to is in the same workbook.
From Notion’s help page on exporting, checked on 8 November 2026.
Tidy five kinds of column
- Relations.
- If a relation reads Acme Bakery (https://www.notion.so/…), keep only the name: delete the space and the part in brackets. A two-way relation is in both CSVs: keep it where each row names one page, such as a project’s Client, and delete it from the other.
- Several choices in a cell.
- Base Captain reads several choices separated by semicolons. If a multi-select column reads Design, Build, replace its commas with semicolons: Design; Build.
- Dates.
- Dates are read as 2026-11-20, as the date cells of a workbook, or in the date format of your own settings. If a date reads November 20, 2026, format the column as dates in your spreadsheet before you save the workbook.
- Amounts.
- An amount with its currency sign, $12,000.00, is not a number yet: remove the sign. Thousands separators can stay.
- Times and files.
- Delete the Created time and Last edited time columns, and Files & media: a record’s history starts on the day you import it, and files do not come over.
We tried it with CSVs shaped as Notion’s. Left as they were, no project came in: every row was reported with its reason. After these changes every row came in but one: the project whose client was not in the Clients database.
Into Base Captain
From here it is the spreadsheet’s way in: open the assistant, drop the workbook in, apply the card with the lists and then the one with the import, and read the report.
Moving from spreadsheetsWhat becomes what
- Title, text, email, phone.
- Text fields; an email address column becomes an email field.
- Select and status.
- A choice, its options the values in the column.
- Multi-select.
- A choice of several, once its values are separated by semicolons.
- Checkbox.
- Yes or no: Notion’s Yes and No come over as they are.
- Date.
- A date, once it is a date cell or reads 2026-11-20.
- Number.
- A number, once the currency sign is gone.
- Relation.
- A link to the other list, found by the page’s name in the other sheet. A name the other sheet does not have is reported, with its row.
- Person.
- The person’s name, as text.
What does not come over
- What is inside each page.
- The text, images and other blocks of a database’s pages are in the zip’s Markdown files, not in the CSV. Paste what you need into a text field.
- Views.
- The CSV holds records only. Ask for the lists, boards and calendars you use.
- Automations and permissions.
- Ask for the ones you need, in your own words (below).
- Formulas and rollups.
- Their values in the CSV come over as values, not as the formula. Add a computed field that works it out, or ask the assistant for one.
- Files, comments and history.
- Upload the files you need again. Comments stay in Notion, and a record’s history starts again on the day you import it.
Then ask the assistant
- “Show projects on a board by status.”
- “Only managers see the budgets.”
- “When a project is done, email its client.”
- “A project over 10,000 needs a manager’s approval before it starts.”
Each comes as a card that says what changes, before it does.