Project contact list template. Free, and ready to become an app.
One workbook for everyone a project depends on: each contact with their role, company, email, phone and the project they are on, the projects with their dates, status and project manager, a log of every call and email with a follow-up flag, the tasks on each project with who owns them, a report log and a small dashboard. Download it free. When clients and vendors should see only their own project and a follow-up should not depend on someone rereading the log, describe the same structure to Tadabase AI and it builds the project directory app.
Excel · Google Sheets · Numbers · 6 sheets
Rather have it as an app? Describe it — we’ll build it now.
Same structure as the spreadsheet, plus logins, roles and workflows. Free to start.
6 sheets, already linked by ID.
Each sheet is one kind of record. The ID columns are how the sheets point at each other, and they are the same links the app version turns into real relationships.
-
Contacts
One row per person: their role on the project (Client or Vendor in the sample rows), company, email, phone and the project they are associated with.
Contact ID · Name · Role · Company · Email · Phone · Associated Project
-
Projects
Each project with a start and end date, a status of In Progress or Planning, and its project manager.
Project ID · Project Name · Start Date · End Date · Status · Project Manager
-
Communications
A log of every call or email: which contact, the date, what was said and whether a follow-up is needed.
Communication ID · Contact ID · Date · Type · Details · Follow-Up Needed
-
Tasks
The work on each project: the task, the project it belongs to, who it is assigned to, the due date and a status of Completed or In Progress.
Task ID · Project ID · Task Name · Assigned To · Due Date · Status
-
Reports
A record of the summaries you send, such as a monthly communication summary or a contact engagement overview, with who produced each one and when.
Report ID · Type · Generated By · Generated On · Details
-
Dashboard
Three headline numbers: total contacts, projects in progress and completed tasks, each with a one-line description.
Metric · Value · Description
Fine for one person. Hard for a team.
Where the spreadsheet starts to cost you time once more people depend on it.
-
The dashboard does not count anything
The file has no formulas. The Dashboard's 150 contacts, 10 projects in progress and 300 completed tasks are typed numbers, not counts of the other sheets (the sample has two of each), so they are only right on the day someone retypes them.
-
One project per contact, matched by name
A contact names a single Associated Project by typing it, while Tasks point at the Project ID. A consultant on two projects needs a second row, and renaming a project breaks the link quietly. The status dropdowns cover only the two sample rows, and a project can only be In Progress or Planning: there is no Completed or On hold.
-
Follow-ups have no date, no owner and no audience
Follow-Up Needed is a Yes or No, with no due date and nobody responsible, so a follow-up happens only if someone rereads the log. And you cannot show a client or a vendor just their own project: sharing the file shares every contact's email and phone and every call note.
Same structure, with logins and automations.
Start from a real prompt, change anything that doesn’t fit, then build it.
Loads this prompt into the prompt box- Project contact directory app A project contact directory for a team that runs projects with outside clients and vendors. Projects have a start date, an end date, a status of planning, in progress, on hold or completed, and a project manager. Contacts belong to a company, and one contact can be on several projects with a different role on each. Every call, email and meeting is logged against a contact and a project, with a follow-up date and an owner when one is needed. Tasks belong to a project and are assigned to a team member or a contact. Project managers see their own projects; clients and vendors log in and see only the projects they are on and the tasks assigned to them. Email each owner the morning a follow-up is due, and show a dashboard that counts contacts, open projects and overdue tasks from the data.
- Stakeholder communication log A stakeholder communication log for project managers — every call, email and meeting is logged against a stakeholder and a project with a summary and an optional follow-up date and owner; follow-ups that pass their date without being closed are flagged and the owner is emailed; each project shows its stakeholders with the date of the last contact; and anyone not contacted in 30 days is listed for the project manager.
- Vendor portal for a project A vendor portal for a construction or events project — each vendor company has a login for its own people; they see only the projects they are on, the tasks assigned to them with due dates, and the documents shared with them; they mark a task done and upload proof; the project manager approves it or sends it back with a note; and the project manager sees every open vendor task across projects, sorted by due date.
Starting from Project contact directory app
Opens the builder with your prompt. Free for 14 days, no card needed.
Questions about this template.
Is the spreadsheet template really free?
Yes. It is a normal .xlsx file that opens in Excel, Google Sheets or Numbers. No sign-up is needed to download it.
Does it work as a project contact list template in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets, or use File, then Import, in a blank sheet. Every sheet comes across with its columns and sample rows.
Can one contact be on more than one project?
Not cleanly in the spreadsheet: each contact row names one project, so a person on two projects needs two rows. In the app, contacts and projects are separate tables linked to each other, so one person can be on several projects with a different role on each.
Can clients and vendors see only their own project?
Not in the spreadsheet. In the app, yes: the AI sets up a role for clients and vendors that sees only the projects they are on and the tasks assigned to them, and a project manager role that sees everything on their projects. That rule is enforced on the server for every record, not by hiding rows.
Can I bring the data I already have in the spreadsheet?
Yes. Once the app is built, import each sheet into the matching table from a CSV or Excel file. The importer maps your columns to the fields and shows any row it could not bring in, and why.
When should I move from the spreadsheet to an app?
When more than one person edits it, when someone outside your team needs to see part of it, or when you start copying rows between tabs by hand. Those are the points where a spreadsheet starts losing data quietly.
Keep the structure. Lose the copy-paste.
Describe the app the spreadsheet was trying to be. Tadabase AI builds it with real logins, roles and workflows, and you can try it free for 14 days.
- 14-day free trial, no card
- Unlimited app users
- Live on your own domain