Prepare the spreadsheet
Notion imports tables, so spreadsheet habits that work visually in Excel cause trouble. Fix these before you export:
- Unmerge cells and put the header in row one.
- Make dates real dates in one format, not text like "early March".
- Use one spelling per client and per status. A status column with eight variants of "open" imports as eight options.
- Split combined columns such as "Smith v Jones" into party columns if you want to filter by them.
- Replace formulas with their values for the export. Note what each formula did so you can rebuild it.
Excel columns to Notion properties
| Excel column | Notion property type | Note |
|---|---|---|
| Matter name or number | Title | One title per database |
| Client | Select, then relation later | Start with select, upgrade to relation |
| Status, stage, practice area | Select | Merge duplicate values first |
| Key date, due date | Date | Check the format imported correctly |
| Hours, amount | Number | Set the number format |
| Notes | Text | Long notes are better as page content |
| Calculated totals | Formula or rollup | Rebuild after relations exist |
Step-by-step import
- 1
Export each sheet as CSV
Use Save As CSV in Excel. One file per sheet; a workbook with five tabs becomes five imports.
- 2
Create a database for each
Use LawyerOS Matters, Time and Clients, or your own. Decide property types before you import.
- 3
Import the CSV
Use Notion's import for CSV, or paste the sheet into a table. Check the row count matches.
- 4
Fix property types
Notion guesses types from the data. Correct any date or number column that arrived as text.
- 5
Add relations
Add a relation from Time to Matters, and from Matters to Clients. Fill them by matching the matter number or client name.
- 6
Rebuild totals and views
Use a rollup to sum hours per matter, and create saved views for Active, Due soon and Overdue instead of Excel filters.
The LawyerOS Pro Time database already has views such as Uninvoiced and My Week, so you are adapting a working structure, not designing one.
Parallel run
Keep the spreadsheet open but stop editing it. Enter new matters and time in Notion for a month, then compare totals: hours per matter, open matters, upcoming dates. When they agree, mark the workbook "archived" in its filename and move it to a read-only folder.
What not to migrate
If your spreadsheet doubles as a client money ledger, do not move it into Notion. Trust and client account records need accounting software and your regulator's retention rules, which Notion is not built to meet. Leave long-dead tabs, scratch calculations and old versions behind.
Frequently asked questions
- Do Excel formulas carry over to Notion?
- No. The CSV carries values. Rebuild calculations with Notion formulas and rollups once relations are in place.
- Can I import an .xlsx file directly?
- Notion's import options have changed over time and CSV is the safest format, so export to CSV from Excel.
- Is Notion as fast as Excel for large data?
- Notion handles thousands of rows, but very large datasets and heavy calculations are still better in a spreadsheet. Keep those in Excel.
- What if my spreadsheet is messy?
- Clean it first. Importing bad data just gives you a messy database.
About the author
Raghav Handa trained as a lawyer, then spent years building legal technology, from enterprise legal products to custom systems for law firms.
Keep reading
- Migration guidesHow to migrate from Clio to Notion: a step-by-step planA practical plan for moving matters, contacts and time entries from Clio into Notion: what to export, how to map fields, and what to leave behind.4 min read · 17 October 2026
- Migration guidesMoving from Word documents and folders to NotionHow to move a folder-and-Word-document practice into Notion: build a matter index, link your files, and capture the facts that live only in documents.3 min read · 17 October 2026
- Practice managementIs Notion good for lawyers? Strengths and limitsIs Notion good for lawyers? It suits matters, tasks, knowledge and intake, but not trust accounting or e-filing. Strengths, limits and who it fits.3 min read · 17 October 2026