How to do it
- Check with your client that manual time is allowed on the contract. Upwork's help says the client can turn it on or off.
- Export your calendar: Google Calendar settings, Import & export; Outlook's File, Save Calendar; or File, Export in Calendar on a Mac.
- Drop the file into the file box near the top of this page. Pick the dates, and pick the time zone your work diary view uses.
- Add a keyword row for the client, with a word from your event titles or their email domain, like @acme.com.
- Read that client's rows in the Events table, or in the "One row per event (CSV)" download. In Upwork, go to your work diary, select the contract, choose the day, click Add manual time, enter the time range and a description, and Save.
What it does
- Each event is one row: date, client, title, start, end and hours. The title can be the start of your description.
- Upwork's help says the work diary runs on UTC by default and you can switch the view to your own time zone. Pick the same zone here, or the times will not line up.
- This page does not connect to Upwork. You type each entry into the work diary yourself.
- Per Upwork's help, manual time can only be added for open billing periods and for slots where you have not already tracked time, and not to paused contracts.
Sources
- Upwork Help: How to add manual time
- Upwork Help: How to allow manual vs. tracked time on hourly contracts
- Google Calendar Help: Export events from Google Calendar
- Microsoft Support: Export an Outlook calendar to Google Calendar (Save Calendar steps)
Export from Google Calendar
- Open Google Calendar on a computer (the phone app cannot export).
- For every calendar at once: click the gear icon, then Settings, then Import & export, then Export. A .zip downloads. Drop the .zip here as it is.
- For one calendar: under My calendars, point at the calendar, click the three dots, then Settings and sharing, then Export calendar. An .ics file downloads.
Work and school accounts can have export turned off by the admin. You need the "Make changes and manage sharing" permission on a calendar to export it.
Export steps for the other apps
Export from Outlook (.ics)
- In classic Outlook for Windows, open the calendar, then File, then Save Calendar.
- Click More Options. Set Date Range to the period you bill for, and set Detail to the most detail. With less detail the titles can be missing, so no client can be matched.
- Save. Drop the .ics file here.
The new Outlook and Outlook on the web do not always offer this. If yours does not, use the CSV export from classic Outlook, or publish the calendar and download its .ics link.
Export from Outlook (CSV)
- In classic Outlook for Windows: File, Open & Export, Import/Export.
- Choose Export to a file, then Comma Separated Values, then your Calendar folder.
- Outlook asks for a date range. Pick the period you bill for. Save, then drop the .csv here.
The CSV does not carry time zones, declined answers or repeat rules. Each row is one meeting as it sat in your calendar. If repeating meetings look missing, export as .ics instead.
Export from Apple Calendar
- Open Calendar on your Mac. If the calendar list is hidden, choose View, then Show Calendar List.
- Click the calendar name in the list.
- Choose File, then Export, then Export. Save the .ics file and drop it here.
Apple exports one calendar at a time. The "Calendar Archive" (.icbu) option is a backup format this tool does not read. Drop several .ics files at once if your work sits in more than one calendar.
Limits
- An event counts on the day it starts, in the time zone you pick. An event that runs past midnight is not split across two days.
- All-day events are left out unless you set hours per all-day event. Then an event over several days gives one row per day, for the days inside your date range.
- Declined meetings are left out only when you enter your own email address, and only for .ics files. The Outlook CSV has no declined, tentative or free status, so those tick boxes do nothing for it.
- Client keywords match whole words, so "art" does not match "Party". A keyword with @ or a dot, like @acme.com, matches inside email addresses.
- The "events shown as free" box leaves out events marked TRANSP:TRANSPARENT in the file. That this is what Google writes for events set to Free is not confirmed against a real Google export.
- Repeat rules by the hour or minute, by week number, or by hour of the day are not expanded. Those series are listed as not counted. Calendar apps rarely write them.
- A repeat that lands on a time skipped by a clock change (for example 2:30 on the night clocks go forward) is skipped, as the iCalendar standard says. Some calendar apps show it an hour later instead. The page names those dates.
- "This and all later" changes written as RANGE=THISANDFUTURE are applied to the one meeting only, with a warning.
- The Outlook CSV must have English column names. A CSV from a German, French or other localized Outlook is refused.
- The Outlook CSV has no time zone. Its times are read as the wall-clock times of the computer that exported them.
- Not tested against real exports of timed, repeating and declined events from Google, Apple or Outlook. The test files are built from the iCalendar standard and the vendors' help pages. Check the first timesheet against your calendar.
- The Toggl Track, Harvest and Clockify import files follow those vendors' help pages and were not tested by importing into a real account.
Questions
- Is manual time covered by Upwork's Hourly Protection?
- No. Upwork's help says manual time is not covered by Hourly Protection, and that only time tracked through the Upwork Desktop App qualifies.
- Can I upload this file to Upwork?
- No. Upwork's help only describes adding manual time one entry at a time in the work diary or the desktop app. This page gives you the list to work from.
- Why do the times not match my work diary?
- The time zones differ. Upwork's help says the work diary runs on UTC by default. Type UTC in the time zone box here, or switch the work diary view to your own time zone and pick that zone here.
- Can I add last week's calls?
- Only while that week is still open. Upwork's help says work diary weeks lock and then cannot be edited, so add manual time before the lock.
- Is my calendar uploaded anywhere?
- No. The file is read by this page inside your browser. Nothing from it is sent to a server. You can disconnect from the internet after the page loads and it still works.
- How is the client picked for each event?
- From a keyword table you can edit. The first row whose keyword appears as a whole word in the event title, categories, location, or a guest's name sets the client. A keyword with @ or a dot, like @acme.com, matches inside email addresses. Suggestions come from guest email domains, categories and titles like "Acme: review". Your own domain is never suggested, and the table is filled in only once your email address is known. It is saved in your browser.
Related
- Google Calendar to timesheet by client
- Outlook calendar to timesheet
- Outlook calendar CSV to timesheet
- Outlook calendar to Excel hours
- Apple Calendar hours report
- Billable hours from your calendar
- Calendar to invoice summary
- ICS to CSV with hours per event
- Hours per client report
- Calendar to billable hours in tenths of an hour
- Round meeting time to 15 minutes
- Recurring meetings in a calendar export
- Time zone and daylight saving in calendar hours
- Leave declined, tentative and all-day events out
- Calendar hours by category or attendee domain
- See total hours in Google Calendar
- Export Google Calendar to Excel
- Outlook calendar total hours per week
- ICS to Excel
- Calendar time tracking report
- Session hours per client for therapists, tutors and coaches
- Meeting hours per week report
- Calendar to Toggl Track CSV import
- Calendar to Harvest CSV time import
- Calendar to Clockify CSV import
- Export Apple Calendar to Excel
- Google Calendar to Google Sheets
- Hours per project from Google Calendar
- Volunteer hours log from your calendar
- Outlook on the web calendar to hours
- Nanny and babysitter hours from your calendar
- Caregiver timesheet from your calendar
- Clinical hours log from your calendar
- Study hours log from your calendar
- Coaching hours log from your calendar
- Internship, practicum and field placement hours log