uniteapps.dk/en/google-maps-timesheet

Google Maps timesheet – work hours from your location history

Turn your Google Maps Timeline export into a work-hours report. Draw your workplaces on a map and download the visits as PDF or Excel. The file is read in your browser.

Location data for working hours
Analyses location data and exports working hours based on when the employee was physically at work
1
2
3
Step 1 of 3 · Upload location data
Step 1: Upload location data
Upload the Timeline file (JSON) from Android or iPhone

Upload your Timeline from Google Maps

GDPR: The raw file is not uploaded to the server and is processed locally only. Filtered data, i.e. the times the employee was at the workplace, is processed by the server to create an Excel file but is not stored. Map images for the PDF are fetched from Google Maps.

How to export your Timeline from your phone

Android

  1. Open the Settings app
  2. Tap Location → Location services → Timeline
  3. Tap “Export Timeline data”
  4. Tap “Continue” and choose where to save the file

iPhone

  1. Open the Google Maps app
  2. Tap your profile picture → Settings
  3. Tap “Personal content”
  4. Tap “Export Timeline data”
  5. Save the file in the Files app — it is called location-history.json

Menu names may vary slightly between phone brands and app versions.

Click to choose a file or drag and drop

Only JSON files are allowed (max 200 MB)

Processing settings

Used for working hours and the report

Visits shorter than this are ignored

Removes short GPS inaccuracies


About the Google Maps timesheet

This tool reads the Timeline export from Google Maps (Android or iPhone) and finds the periods when your phone was inside the work areas you draw on the map. You download the result as a PDF or Excel file. The file itself is read in your browser and is not uploaded — see the bottom of this page for what is sent on when you export.

What is generated?
  • PDF report: An overview of the work areas with map extracts, a table of visits and statistics. The report is built in your browser.
  • Visit records: Arrival, departure and duration for every visit to every work area.
  • Statistics: The number of visits and total time are calculated automatically from the loaded data.
  • Excel sheet: The list of visits with decimal hours, ready for further calculation. The sheet is created on the server and downloaded straight away.
What the fields mean
  • Data source: The Timeline file (JSON) that you export from Google Maps on Android or iPhone. Older location history from Google Takeout can be read too.
  • Work areas: Draw a circle or a polygon around each workplace. If you set working hours for an area, only points within those hours count.
  • Processing settings: Time zone, minimum visit time and removal of short gaps where the phone briefly placed you outside the area.
  • Generate report: Calculate the visits and download them as PDF or Excel. The report covers the whole period the file contains.

Examples of use

Documenting working hours

Export your Timeline, draw the workplace and download the report. It shows every visit with arrival, departure and duration for the whole period of the file.

Useful when there is a disagreement about overtime, start times or attendance.

Output:PDF report with a table of visits

Several workplaces

If you work for several customers or on changing building sites, draw one area for each place. The report totals the time per area, and the Excel sheet can be used for further calculation.

Output:Time per area in Excel
About the data

Timeline is Google’s estimate of where your phone has been. Visits and times can be inaccurate — compare the report with your own notes, calendar or shift schedule.

The report is your own material. You decide whether to share it with, for example, your shop steward or trade union.

What happens to your data?

The Timeline file is read and analysed in your browser. It is not uploaded, and the individual location points do not leave your computer.

If you choose Excel, the list of visits (area names and coordinates, arrival, departure and duration) is sent to the UniteApps server, which creates the sheet and sends it back. Nothing is stored.

The map is Google Maps. For the PDF, map images of the work areas are fetched from Google via the UniteApps server, so Google receives the coordinates of the areas.

Create a free profile to see more

Get access to all features and save your calculations