Google Sheets timesheet templates
Free timesheets for Google Sheets, with the totals already working. Import the CSV file in a few clicks, or upload the Excel version to keep its colours and Yes or No menus.
How to import a timesheet into Google Sheets
- Download the CSV file of the template you want, from the list below.
- In Google Sheets, open a new blank spreadsheet.
- Click File, then Import, and upload the file.
- Choose Replace spreadsheet. Leave the separator on Detect automatically, and keep the box that converts text to numbers, dates and formulas ticked, so the totals work.
- Click Import data. The hours and totals are formulas, so they update as you type.
To keep the formatting, upload the .xlsx file to Google Drive instead and open it with Google Sheets. It keeps the column widths, the colours, and the Yes or No menu in the billable column.
The six templates
Weekly timesheet
NameWeek starting
| Day | Date | Start | End | Break | Hours | Notes |
| Monday | | 9:00 | 17:30 | 30 | 8.00 | |
| Tuesday | | 8:45 | 17:00 | 45 | 7.50 | |
| Wednesday | | 9:00 | 13:00 | | 4.00 | Half day |
| Thursday | | | | | | |
| Friday | | | | | | |
| Saturday | | | | | | |
Weekly timesheet
A line per day from Monday to Sunday, with start and end times, breaks and the week's total.
Weekly timesheet
NameWeek starting
| Project | Task | Billable | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Total |
| Acme Health | Design | Yes | 2.5 | 3 | | 4 | 1.5 | | | 11.00 |
| Northwind | Development | Yes | 4 | 3.5 | 6 | 2 | 4 | | | 19.50 |
| Internal | Admin | No | 1 | | 1 | | 0.5 | | | 2.50 |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
Weekly timesheet with projects
A line per project and task, a column per day, and the week's billable hours.
Monthly timesheet
NameMonth
| Day | Start | End | Break | Hours | Notes |
| 1 | 9:00 | 17:30 | 30 | 8.00 | |
| 2 | 9:00 | 16:00 | 30 | 6.50 | |
| 3 | 8:30 | 12:30 | | 4.00 | Half day |
| 4 | | | | | |
| 5 | | | | | |
| 6 | | | | | |
Monthly timesheet
Days 1 to 31 with start and end times, breaks and the month's total.
Monthly timesheet
NameMonth
| Project | Task | Billable | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | | Total |
| Acme Health | Design | Yes | 3 | 2 | | 4 | 2.5 | | | | | | 11.50 |
| Northwind | Development | Yes | 4 | 5 | 6 | | 3 | | | | | | 18.00 |
| Internal | Admin | No | 1 | | 1 | | 0.5 | | | | | | 2.50 |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
Monthly timesheet with projects
A line per project and task, a column for each day of the month, and the month's billable hours.
Daily timesheet
NameDate
| Start | End | Break | Hours | Notes |
| 9:00 | 12:30 | | 3.50 | Client workshop |
| 13:15 | 17:45 | 15 | 4.25 | Design review and changes |
| | | | |
| | | | |
| | | | |
| | | | |
Daily timesheet
One day's start and end times, breaks and notes, with the day's total.
Daily timesheet
NameDate
| Project | Task | Start | End | Hours | Billable | Notes |
| Acme Health | Design | 9:00 | 11:30 | 2.50 | Yes | |
| Acme Health | Client call | 11:30 | 12:15 | 0.75 | Yes | |
| Internal | Admin | 13:00 | 13:45 | 0.75 | No | Invoices |
| | | | | | |
| | | | | | |
| | | | | | |
Daily timesheet with projects
Each piece of work on its own line, with project, task, times and billable totals.
After importing
- Type times with a colon, like 9:00 or 17:30, and Google Sheets reads them as times.
- Empty lines show 0 in the hours column until you fill them in.
- To add lines, insert rows between the first and the last line of the table, and the totals include them.
- Share the sheet with your manager or client from the Share button, with comment or edit access.
- To send a PDF, choose File, then Download, then PDF.
Prefer paper? Each template also has a printable version on the timesheet templates page, and Excel timesheet templates explains what each formula does.
Questions people ask
How do I make a timesheet in Google Sheets?
Import one of the CSV files on this page with File, then Import. Or start from a blank sheet with columns for the day, start, end, break and hours, where the hours are =(End-Start)*24-Break/60.
Why do empty lines show 0?
A CSV file keeps the formulas but not the number formats, so a line without times shows 0 until you fill it in. Upload the .xlsx version instead to keep those lines blank.
Can my team fill in the same timesheet?
Yes. Share the spreadsheet with them and give each person a tab of their own, with one tab per week or per month.
How do I turn the timesheet into a PDF?
In Google Sheets, choose File, then Download, then PDF. Or open the printable version of the template and save it as a PDF from the print window.