Managing humanitarian projects with Notion instead of Excel
When a Notion workspace beats scattered Excel files for project tracking, how to set up linked databases, and what to check on data safety first.
Short answer
Notion can replace several Excel files for tracking activities, tasks, risks and meeting notes, because its databases link to each other and show the same data in table, board, calendar and timeline views. Set up three linked databases: projects, tasks and meeting notes. Keep budgets in Excel, and keep sensitive beneficiary data out of it.
Key points
- Notion databases link to each other; separate Excel sheets do not.
- Start with three databases: projects, tasks and meeting notes.
- Use views, not copies, to show each person what they need.
- Keep budgets in Excel, and sensitive personal data out of shared tools.
- Test it with a small team for one month before you move everything.
Why do Excel files stop working for projects?
Most project teams start with Excel. One file for the work plan, one for the indicator tracker, one for the risk list, one for action points. After six months, the files drift apart. A task is marked done in one place and open in another. Someone saves "final_v3" on a laptop. A new officer cannot find the current version.
The problem is not Excel. The problem is that each file stands alone. Notion's databases are built to link to each other, which solves part of this.
What does Notion do differently?
Notion's own guides describe databases as structured homes for information where you can add properties, then sort and filter. Three features matter most for a project team:
- Relations. A relation property connects one database to another. You can link a task to its project, or a meeting note to a project.
- Rollups. A rollup can count related tasks marked "done" and show project completion as a progress bar.
- Views. One database can show as a table, list, board, calendar or timeline. A manager can view a timeline while an officer views a board of their own tasks.
Notion also lets you create page templates inside a database, so each new task or meeting note starts from the same structure.
How do you set it up in five steps?
- Create a Projects database. One row per project or grant. Add properties: status, donor, start date, end date, lead.
- Create a Tasks database. One row per task or activity. Add: status, owner, due date, and a relation to Projects.
- Create a Meeting Notes database. Use a template with the five parts from our guide on meeting notes. Relate each note to a project.
- Add a rollup for progress. On the Projects database, roll up the status of related tasks and show percent done.
- Save views for each role. For example, "My tasks this week" for officers, "All projects on a timeline" for the director, and "Overdue" for the project manager.
Add a risk register and an indicator tracker later, once the first three work. Our guides on the risk register and work plan and Gantt chart show what to track.
What should stay in Excel?
| Task | Better tool | Why |
|---|---|---|
| Budget and expenditure | Excel | Formulas, totals and donor financial formats |
| Large data cleaning and analysis | Excel or KoboToolbox | Built for rows of survey data |
| Tasks, status and owners | Notion | Linked, shared, with several views |
| Meeting notes and decisions | Notion | Linked to the project and searchable |
| Work plan overview | Notion timeline, or Excel Gantt | Choose what the team will update |
Do not force everything into one tool. The aim is one clear place for each kind of information. See Excel skills for NGOs and Notion for NGOs for more.
What risks should you check before you start?
- Personal data. Do not put names, contact details or case information about beneficiaries into a shared workspace without a clear data protection plan. Read data protection for NGOs first. Use codes, not names, where you can.
- Donor rules. Some donors have rules about where project data is stored. Check your agreement.
- Access and connectivity. Test on the phones and connections your team actually uses.
- Permissions. Give people only the access they need. Remove access when staff or partners leave.
- Exit plan. Export key tables regularly so you are not locked in.
How do you get the team to use it?
A tool fails when only one person updates it. Start with one project and a small team for one month. Hold a 30-minute training. Agree who updates what and when, for example: every owner updates task status before the Friday meeting. Open the Friday meeting in Notion, so the board is the agenda. When people see that the meeting uses the tool, they keep it current.
If the team is not ready, do not force it. Fix your Excel habits first: one master file, clear names, one owner, a shared folder. See our guide on organising shared files.
How EMPO can help
EMPO is a trusted Yangon-based training and consultancy provider and one of Myanmar's leading names in practical NGO training, with 1,200+ people trained and 15 partner organisations. We run practical training on project management and digital tools, online over Zoom or in person across Myanmar, in English and Burmese. Teams can commission training built around their own project setup. See our services, the Master Project Budget Tracker in our store, or contact us.
Sources
- Three key databases for teams, and how to use them — Notion Help Center
Questions people ask
Is Notion free for NGOs?
Check Notion's current plans and any nonprofit offer on its website before you decide, because prices and terms change. Do not move a project there until you know the cost for your team size.
Can we use Notion with weak internet?
Test it first on your team's real connections and phones. If connectivity is a problem, keep a weekly export of key tables so work does not stop when the connection drops.
Should we move our budget tracking to Notion?
Usually no. Excel is better for formulas and financial reports. Use Notion for tasks, status and notes, and link to the budget file.
