Monthly timesheet template for Excel and Google Sheets
A free monthly timesheet: one row per project, one column per day of the month, weekends shaded and totals that add up as you type. Download it for Excel, use it in Google Sheets, or fill it in Onplana.
Step 1
Download the template for Excel
An .xlsx file for any month. Type your name and the first day of the month in the two yellow cells, and the day columns, weekdays and weekend shading follow. Then type your hours.
Step 2
Use it in Google Sheets
Make your own copy in Google Sheets, with the same formulas and weekend shading. It lands in your Drive; you only need your Google account.
Step 3
Fill it in Onplana
When a team fills it in, skip the files. People log hours against their tasks, submit the week for approval, and the month adds itself up per person and project. Timesheets are on the Professional plan, $12 per seat a month.
Or build this month's timesheet with your projects filled in
Pick the month, name your projects and set the hours per working day. The download is a CSV for that month that Excel and Google Sheets open, with every weekday filled in.
What the spreadsheet does well
One person, one month, a handful of projects: a grid is quick, it is yours, and everyone knows how to fill it in. If that is your whole need, this file is enough.
Where it starts to hurt
The moment there is a team. Somebody has to chase the files, check them, and add up who worked how many hours on which project each month, and the hours never connect to the plan they were spent on.
Timesheets in Onplana
- Log hours against the tasks people actually worked on, from the web, a phone, the desktop app or the browser extension.
- Submit the week for approval, with approvers you choose.
- A monthly view of every person's hours per project, with no files to collect or add up.
- Mark projects billable or internal, and see capacity against hours logged.
Timesheets are on the Professional plan, $12 per seat a month, and the button starts you on it. Rather look first? The demo opens a ready-made Professional workspace to try.
Bill these hours: approvals, rates and draft invoices for your firm
A month of hours split by project is usually time somebody bills a client for. Onplana Services is Onplana with the commercial layer added, so the hours, the rates and the client sit on one record instead of meeting in a spreadsheet at month end.
- Hours on tasks with approval, priced at a cost rate and a billable rate from a ladder that knows the client and the project.
- Margin per client, per project and per person.
- Approved time and rebillable expenses go to Xero as draft invoices, one per client, with a preview that writes nothing first.
On sale now, and free to start, with no card.
Frequently asked questions
Is it free, and do I need to sign up?
Free, and no. The template is a static file on this page, and the builder makes your sheet in your browser: no email, no account, nothing uploaded.
How do I download a monthly timesheet template for Excel?
Choose Download for Excel at the top of this page. You get an .xlsx file: type your name and the first day of the month in the two yellow cells, and every day column, weekday and weekend shade follows. Type the hours, and the row, day and month totals are formulas that add up as you go. For the next month, save a copy and type the new month.
How do I use the monthly timesheet template in Google Sheets?
Choose Make a copy in Google Sheets on this page. The copy is your own Sheet in your Drive, with the same formulas and weekend shading as the Excel file. You only need your Google account.
Can I get a timesheet with the hours already filled in?
Yes. Use the builder on this page: pick the month, name your projects and set the hours per working day, and it downloads a CSV for that month with every weekday filled in and the totals as formulas. Excel, Google Sheets, LibreOffice and Numbers all open it.
What is in the file?
Your name and the month at the top, then one row per project or activity and one column per day of the month, each day labelled with its weekday. Every row has a total, every day has a total, and the bottom-right cell is the month total. Weekends start empty.
Does it know about public holidays?
No. Holidays differ by country and employer, so every working day starts with the hours you set. Clear the holidays in the spreadsheet, or type the leave hours on a row of their own.
Can I use it for several people?
Build one per person: each file carries one name and one month. That is also where a spreadsheet timesheet starts to hurt, because somebody then has to collect the files, check them and add them up.
How does this compare with timesheets in Onplana?
The spreadsheet is yours and free. Onplana timesheets are on the Professional plan ($12 per seat a month): people log hours against the actual tasks they worked on, from the web, their phone, the desktop app or the browser extension, submit the week for approval, and a monthly view shows every person's hours per project without anyone adding up files.
Planning the work as well as tracking it? The project plan template gives you ready-made plans for Excel, and the Gantt chart generator turns a task list into a schedule.