Skip to main content
Migration guides

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.

By Raghav Handa · Updated 17 October 2026 · 3 min read

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 columnNotion property typeNote
Matter name or numberTitleOne title per database
ClientSelect, then relation laterStart with select, upgrade to relation
Status, stage, practice areaSelectMerge duplicate values first
Key date, due dateDateCheck the format imported correctly
Hours, amountNumberSet the number format
NotesTextLong notes are better as page content
Calculated totalsFormula or rollupRebuild after relations exist

Step-by-step import

  1. 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. 2

    Create a database for each

    Use LawyerOS Matters, Time and Clients, or your own. Decide property types before you import.

  3. 3

    Import the CSV

    Use Notion's import for CSV, or paste the sheet into a table. Check the row count matches.

  4. 4

    Fix property types

    Notion guesses types from the data. Correct any date or number column that arrived as text.

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

Raghav Handa trained as a lawyer, then spent years building legal technology, from enterprise legal products to custom systems for law firms.

Want it built for you?

LawyerOS is a ready-made Notion workspace for matters, deadlines, time and invoices. Starter $19, Pro with AI $39, one-time.

See LawyerOS