---
title: "Migrating from Excel to Notion: a guide for law firms"
url: https://notionforlawyers.com/guides/migrate-from-excel-to-notion
updated: 2026-10-17
author: Raghav Handa
---

# Migrating from Excel to Notion: a guide for law firms

Save each Excel sheet as a CSV, clean the headers and dates, import it into a Notion database, set each column to the right property type, and then add relations between sheets and the views you used to get with filters. A tidy tracker moves in an afternoon; the work is in cleaning the data, not the import.

## Key takeaways

- One sheet becomes one database; one row becomes one page.
- Clean the data in Excel first: consistent names, real dates, no merged cells.
- Formulas do not import as formulas; rebuild them as Notion formulas or rollups.
- Keep the spreadsheet read-only for a few weeks as a fallback.

## 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.


## FAQ

### 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.
