By Linkedd LLC ·
How to Import a CSV into Notion (and Connect the Tables)
A lot of Notion templates, including every Packd system, come as CSV files you import into your own workspace instead of a page you duplicate. Importing one file takes a minute. Getting several files to work together as one client system takes a few more steps, because a CSV import can't build the links between tables for you. Here's the whole process, using Notion's own help pages as the source.
Notion is a trademark of Notion Labs, Inc. Packd is not affiliated with, endorsed by, or sponsored by Notion.
Data last checked: November 9, 2026
Before you start
- Use desktop or web. Notion says imports aren't available on mobile yet (Notion Help, Import data into Notion).
- Check the file size. The limit is 5 MB per file on the Free plan and 50 MB on paid plans.
- Check the header row. The first row must be the column headers, and every cell needs a header above it.
- Import one CSV at a time. Notion's CSV import doesn't take several files in one go.
Step 1: Import the CSV
- Go to Settings → Import → CSV, or type /csv on a page.
- Upload the .csv file.
- Choose create a new database (for a template, this is almost always what you want).
- Pick the page where it should live. Tip: make one parent page first, such as "Client System", and import every file into it.
- Map each column to a property type.
Each row becomes a page in the database, and each column becomes a property (Import data into Notion).
Step 2: Map the property types
This is where most imports go right or wrong. A typical client tracker maps like this:
| Column | Property type |
|---|---|
| Client or project name | Title |
| Status, stage, priority | Select |
| Invoice amount | Number (or Text, see below) |
| Due date, deadline | Date |
| Done, paid | Checkbox |
| Notes, next action | Text |
Notion's tips for this step:
- If numbers with $ signs, % signs or minus signs don't import correctly, map that column to Text. You can change the property type after import.
- If values with commas don't show up when mapped to Select, map that column to Text instead.
- Dates import in MM/DD/YYYY format.
- If a column has mixed types, Notion may import it as text to avoid losing data.
- If you see garbled characters, re-save the CSV as UTF-8 and import again.
All from Import data into Notion.
Step 3: Know what doesn't come across
Notion is clear about this (Import data into Notion):
- A new CSV import can't create relations, the links between databases.
- It can't create rollups or formulas. You rebuild those in Notion.
- Imports add rows; they don't update existing ones. Importing the same file twice gives you duplicates.
Notion also notes that if you export a database that has relations to CSV, the relations come out as plain-text URLs, and you can't re-import that CSV to bring the relations back (Notion Help, Relations & rollups). So if a template's CSV has a column that looks like links, plan to rebuild that relation by hand.
Step 4: Rebuild the relations
Say you imported a Clients database and a Projects database and want each project linked to its client:
- In Projects, add a new property and choose Relation.
- Search for and pick the Clients database.
- Turn on Show on Clients if you want the link to appear on both sides (a two-way relation).
- Click Add relation.
- Click a cell in the new column and pick the matching client.
Steps from Notion Help, Relations & rollups. For a handful of rows, linking by hand takes minutes.
Adding more rows later? Once the relation exists, you can bring in new rows with Merge with CSV from the database's ••• menu, and map a CSV column to that existing relation property (Import data into Notion). The CSV headers need to match the database's property names exactly.
Step 5: Add rollups for totals
With the relation in place, a rollup can total things up, for example the amount owed by each client:
- In Clients, add a property and choose Rollup.
- Pick the relation (Projects), then the property to roll up (Invoice amount).
- Choose a calculation such as Sum.
Sum, average, min and max only work on Number properties, so if you mapped amounts to Text in Step 2, switch that column to Number first. One limit: Notion can't roll up a rollup (Relations & rollups).
Step 6: Add views and one real record
Make a board view grouped by status and a table view sorted by due date. Then add one real client or project and run it through before moving your whole history in. If something's off, it's easier to fix with one row than with fifty.
A starter set to practice on
If you'd like to try this on files built for it:
- The free Freelancer Client Workflow Starter gives you blank CSV tables for inquiries, onboarding and follow-up, plus a setup guide and message templates. You enter your email and the download appears on the page.
- The Freelancer OS Bundle ($19.00) has four CSVs (client CRM, finance tracker, content calendar and project workspace) that work with Notion's free plan. You get files to import, not a hosted Notion workspace or share link.
- Niche versions, such as the Writer Client System ($39 one-time), are on the niche systems page, and The Vault includes the toolkits for $12/month or $96/year, renewing until you cancel.
- Want it set up for you? See Done-For-You Customization.
Comparing setups first? Read the best Notion templates for freelancers, how to build a Notion client portal, or the full inquiry-to-paid workflow.
FAQ
Why didn't my relations import?
A new CSV import can't create relations. Import each table, then add a Relation property in Notion and link the rows. If you later merge a CSV into a database that already has a relation property, you can map a column to it.
Can I import several CSV files at once?
Not through the CSV importer; it takes one file at a time. (Notion's ZIP importer can turn CSVs inside a ZIP into databases, but they still arrive unconnected.)
Why are my dollar amounts showing as text?
Notion suggests mapping amounts with $, % or minus signs to Text if they don't import correctly. To total them with a rollup, clean the values and switch the property to Number.
Does importing the same CSV again update my database?
No. Imports and merges add rows and don't update existing ones, so you'll get duplicates.
Do I need a paid Notion plan?
No. The Free plan can import CSVs up to 5 MB per file.
Sources: Notion Help, "Import data into Notion" and "Relations & rollups," read November 9, 2026. Packd product details from packd.cloud product pages, November 9, 2026.