You want to move your projects from Monday.com to Notion, but the columns do not match. Monday.com uses column types like Status, Date, and Person that have no direct equivalent in Notion databases. This article explains how to export your Monday.com board, map each column type to a Notion property, and import the data without losing structure. You will learn the specific column mappings and the steps to set up a working Notion database.
Key Takeaways: Mapping Monday.com Columns to Notion Properties
- Monday.com Status column to Notion Select property: Each status label becomes a select option in Notion.
- Monday.com Date column to Notion Date property: Date ranges and due dates map directly to the Notion Date property type.
- Monday.com Person column to Notion Person property: Assignees become linked Notion user accounts.
Understanding Monday.com Column Types and Notion Property Types
Monday.com boards use specialized column types that do not exist in Notion databases. Notion uses property types such as Text, Select, Date, Person, and Relation. When you export a Monday.com board to CSV or Excel, the column data is flattened into plain text. You must reformat that data so Notion can recognize the intended column type.
The export file from Monday.com contains column headers that include the column type in the header name, for example “Status (Status)” or “Due Date (Date)”. This helps you identify which Notion property to create. The core challenge is converting Monday.com’s Status column, which supports multiple status labels, into a Notion Select property with matching options. Date columns need to keep their date format. Person columns contain email addresses that Notion can link to user accounts.
Before starting, make sure you have a Notion workspace where you can create a new database. You also need export access on your Monday.com board. The export feature is available on all Monday.com plans.
Steps to Export Monday.com Board and Prepare the CSV File
- Export the Monday.com board as a CSV file
Open your Monday.com board. Click the three-dot menu in the top-right corner. Select Export. Choose CSV format. The file downloads to your computer. - Open the CSV file in a spreadsheet editor
Use Excel, Google Sheets, or a text editor. The first row contains column headers with type names like “Name (Text)”, “Status (Status)”, “Date (Date)”, and “Person (Person)”. - Rename column headers to match Notion property names
Remove the type suffix. For example, change “Status (Status)” to “Status”. Change “Date (Date)” to “Date”. Keep “Name” as is. This step prevents import confusion. - Check date formatting
Monday.com exports dates in YYYY-MM-DD format. Notion accepts this format. If your file uses a different format, convert all date cells to YYYY-MM-DD before importing. - Handle Person column data
Monday.com Person columns contain email addresses. Notion Person properties require email addresses that belong to workspace members. Verify that each email in the Person column belongs to a user in your Notion workspace. Remove any external emails.
Mapping Monday.com Column Types to Notion Properties
Each Monday.com column type must be mapped to a Notion property type. The table below shows the standard mappings. After mapping, you will create the Notion database with these properties before importing the CSV.
Monday.com Status to Notion Select
The Status column in Monday.com uses predefined labels like Done, Working on it, and Stuck. To preserve these labels in Notion, create a Select property. In the Notion database, add a new column, choose Select as the property type, and add each status label as an option. The CSV import will match the label text to the option.
Monday.com Date to Notion Date
Monday.com Date columns can contain a single date or a date range. Notion Date properties support both. When you import the CSV, ensure the date column contains only one date per cell. If a Monday.com cell had a range, it appears as two dates separated by a comma. You must split those into separate columns or keep only the start date.
Monday.com Person to Notion Person
Monday.com Person columns store user names and email addresses. The CSV export shows email addresses. Notion Person properties display the user’s name and avatar after matching the email. Before importing, confirm that all emails in the Person column belong to active members of your Notion workspace. Non-member emails will appear as plain text and will not link to a user profile.
Monday.com Text, Numbers, and Long Text
Monday.com Text columns map to Notion Text properties. Number columns map to Notion Number properties. Long Text columns, which support rich text, map to Notion Text properties but lose formatting like bold and italics. To preserve formatting, copy the data manually after import.
Importing the CSV File Into Notion
- Create a new database in Notion
In your Notion workspace, create a new page. Type /table and select Table. This creates an empty database. Name the database. - Add the required Notion properties
Click the + button in the last column header. Add a property for each mapped column. For Status, add a Select property. For Date, add a Date property. For Person, add a Person property. For text and numbers, add Text and Number properties. Match the property names exactly to the CSV column headers. - Import the CSV file
Click the three-dot menu in the top-right corner of the database. Select Import. Choose CSV. Select the prepared CSV file. Notion detects the columns and maps them to existing properties with matching names. Confirm the mapping and click Import. - Review and adjust imported data
After import, check a few rows. Verify that Status labels appear as select options. Confirm that dates are in the Date property. Check that Person columns show user names and avatars. If a Person column shows an email address as plain text, that email is not a workspace member. You can manually replace it with a valid user. - Add missing options to Select properties
If a status label did not exist as an option before import, Notion creates it automatically. Open the Select property in any row to see all options. Delete any that are not needed.
Common Issues During Monday.com to Notion Import
Status labels appear as plain text instead of select options
This happens when the property name in Notion does not match the CSV column header exactly. Check that the Notion property is a Select type and that the name matches the CSV header. Rename the property if needed and re-import.
Date values are not recognized as dates
Notion expects dates in YYYY-MM-DD format. If your CSV uses a different format, convert all date cells using a spreadsheet formula. After conversion, save the CSV and import again.
Person column shows email addresses instead of names
The email address in the CSV does not match any user in your Notion workspace. Add the person to your workspace or replace the email with a workspace member’s email. Then re-import or edit the cell manually.
Multiple values in one cell are lost
Monday.com supports multi-select columns and tags. Notion does not have a native multi-select property. Export multi-select values as comma-separated text. After import, you can create a separate database with a Relation property to link multiple items, or keep the data as a Text property.
Monday.com Column Types vs Notion Property Types: Mapping Reference
| Monday.com Column Type | Notion Property Type | Notes |
|---|---|---|
| Status | Select | Each status label becomes a select option |
| Date | Date | Use YYYY-MM-DD format; ranges require manual split |
| Person | Person | Email must match workspace member |
| Text | Text | Rich text formatting is lost |
| Numbers | Number | Number format is preserved |
| Long Text | Text | Bold, italic, and links are removed |
| Dropdown (single) | Select | Each option becomes a select option |
| Dropdown (multi) | Text | Notion lacks multi-select; use comma-separated text |
| Link | URL | URL property preserves the link |
| Email property preserves the address | ||
| Phone | Phone | Phone property preserves the number |
| Location | Text | Address data is stored as plain text |
| Rating | Number | Rating value is stored as a number |
| Progress | Number | Progress percentage is stored as a number |
You can now transfer your Monday.com board data into Notion with proper column type mapping. Start by exporting your board as CSV, then create the Notion database with matching property types. Use the mapping table above to assign the correct Notion property for each Monday.com column. After import, review the data and adjust any Select options or Person links. For complex boards with multi-select columns or rich text, consider using Notion’s API with a custom script to preserve more detail.