How to Import CSV into Notion: The Complete Step-by-Step Guide

If you have tried moving data from an Excel, Google Sheets or even Airtable back to Notion, then importing the data in the form of CSV into Notion is the first recommended approach to try.

Instead of typing out everything manually one by one Notion allows to get the information organized and added inside the workspace properly.

In this way a single CSV file can be fully converted into a fully functional, filterable and portable database within seconds.

This guide will walk you through all the steps necessary to carry out the CSV import process directly to Notion, right from preparation of the file to finding and fixing all the common errors.

This will help with the import of all the data precisely as expected right into Notion as expected.

---

Why Import CSV Files into Notion?

Before understanding how to import CSV files into Notion, let's first look at why CSV files are imported into Notion rather than building the entire system from scratch:

• Speed of import — Importing a CSV takes few mins to process all the records even for thousands of rows to be processed.
• Centralization of data — It allows fetching data from any source such as Airtable, other CRMs, or spreadsheets into one connected workspace.
• Collaboration opportunity — Once a CSV file gets converted to a Notion database, the entire team can look at one source of data to work with instead of mailing different versions of the spreadsheet back and forth.
• Enhanced Functionality — A flat CSV file can't filter itself by its status, neither can it be grouped by priority or it can't be linked to other pages in use. But a Notion database can do the job.

---

What Will Happen When A CSV Will Be Imported into Notion?

When you import a CSV file, Notion automatically converts it into a database:

• Each row becomes a page (an item in the database).
• Each column becomes a property (Text, Number, Date, Select, and so on).

This is different from importing a Word document, PDF, or Markdown file, which Notion turns into a regular page rather than a database.

---

How to Import CSV into Notion: Step-by-Step

Step 1: Prepare Your CSV File

A clean CSV import starts before you ever open Notion. Before uploading:

• Make sure the first row contains clear column headers.
• Save the file with a comma delimiter and UTF-8 encoding to avoid character issues.
• Remove stray commas, unmatched quotation marks, or merged cells, since CSV files are sensitive to delimiters and formatting.
• Standardize date formats so Notion recognizes them as Date properties instead of plain text.

Step 2: Start the Import

You have two easy entry points in Notion:

• Go to Settings → Import → CSV from your sidebar, or

!Notion Settings Import Option

!Notion Import CSV Dialog

• Type /csv on any page and select the CSV import option.

!Notion CSV Slash Command

Step 3: Upload Your File

!Upload CSV File Dialog

Drag and drop your CSV file, or click on Choose File to browse and select it from your device.

Notion also supports importing XLSX, TSV, and ODS files the same way, so if your data lives in Excel, you can often skip converting it to CSV entirely.

Step 4: Map Columns to Notion Properties

Once uploaded, Notion shows a preview screen where you can:

• Toggle whether the first row should be used as column headers (this is on by default).
• Set a property type for each column — Text, Number, Date, Checkbox, Select, Multi-select, and more.
• Rename columns before they become permanent database properties.

Taking a minute here saves cleanup work later, since property types are much easier to set correctly during import than to fix afterward.

Step 5: Finish the Import

!Notion Import CSV Complete

Click Import CSV to complete the process. Notion creates a new page in your workspace containing the finished database, ready to filter, sort, group, and connect to other pages.

---

How to Merge a CSV into an Existing Notion Database

If you already have a Notion database and just need to add new rows, you don't need to start over. Use the Merge option instead:

• Open the existing full-page database.
• Click the •• menu in the top-right corner.
• Select Merge with CSV.
• Upload your CSV file (it must include a header row).
• Match each CSV column to the corresponding Notion property.
• Click Import to finalize the merge.

Keep in mind that merging appends new rows as new pages rather than updating existing entries, so it won't automatically overwrite or deduplicate records that already exist in your database.

---

Common CSV Import Errors and How to Fix Them

Even a well-prepared file can run into snags. Here are the most frequent issues and how to solve them:

• Import fails immediately — Check for inconsistent delimiters, unescaped commas inside text fields, or mismatched quotation marks.
• Dates import as text — Set the column's property type to Date manually if Notion doesn't detect the format automatically.
• Checkbox, Person, and Relation fields don't populate — These property types generally aren't supported through standard CSV import; you'll need to set them manually or through the Notion API afterward.
• New Select or Multi-select options don't appear as selectable — Temporarily switch the property type to Text and back to Select or Multi-select to refresh the option list.
• Large files feel slow or hit limits — Notion doesn't enforce a strict row cap, but very large imports can run into rate limits. Splitting a huge CSV into smaller batches usually resolves this.

---

Best Practices for a Clean Notion CSV Import

Following a few habits consistently will save you significant rework:

• Clean your data first. Fix typos, duplicate rows, and inconsistent formatting in your spreadsheet tool before exporting to CSV.
• Test with a small sample. Import 10–20 rows first to confirm property mapping looks right before uploading the full file.
• Standardize headers. Use short, consistent column names that map cleanly to Notion property types.
• Back up your original file. Keep the source CSV in case you need to re-import or troubleshoot later.
• Automate recurring imports. If you're importing data regularly (like from Airtable or a CRM), consider a no-code tool or the Notion API instead of repeating manual imports.

---

Frequently Asked Questions

Can I import a CSV into an existing Notion database?

Yes. Use the Merge with CSV option from the database's ••• menu to add new rows without creating a duplicate database.

Is there a row limit for CSV imports in Notion?

Notion doesn't publish a strict row cap, but very large files can hit rate limits. Importing in smaller batches is more reliable for big datasets.

Can I import an Excel file instead of a CSV?

Yes. Notion supports XLSX files directly in addition to CSV, TSV, and ODS formats, so converting Excel files to CSV first is optional.

Why didn't my Checkbox or Relation properties import correctly?

CSV import doesn't fully support Checkbox, Person, or Relation property types. Set these manually after the import, or use the Notion API for more complex data structures.

---

Final Thoughts

Knowing how to import CSV into Notion turns scattered spreadsheet data into a live, connected database you can filter, sort, and build workflows around. Whether you're creating a brand-new database or merging fresh rows into an existing one, the process takes just a few minutes once your CSV file is properly formatted. Clean your data, map your properties carefully, and your Notion workspace will be ready to scale with you.