Export Your Data

Here's how to export projects, tasks, time entries, time reports, and data about users and clients - including Google Sheets integration.

---

Key benefits and use cases

• Process raw data for your own analyses

• Share project and task status as Excel or timeline image

• Document time entries as Excel or timesheet (PDF)

• Back up user and client data including associated projects and time entries

• Pull data via Google Sheets add-on and update with one click

---

Export projects

The project overview can be exported from both list view and timeline view. The export includes the raw data from your project overview, which you can use for your own analyses, for example.

1. Open the project overview and select List or Timeline in the header.

2. Click the action button in the top right.

3. Select Export.

---

Export tasks

You can download all tasks from a project in Excel format (.xlsx) and process them further.

1. Open the project and switch to your desired view (Tasks, Board, or Timeline).

2. Click the action button in the top right below the header.

3. Select Export tasks.

---

Export views

1. Open Views in the main menu

2. Select a standard view or a filter you've created.

3. Click the action button in the top right below the header.

4. Select Export.

---

Export timeline as image

You can export the entire timeline as an image, download it, and share it with a client or include it in a presentation, for example.

1. Open the Timeline in your project.

2. Click the action button in the top right below the header.

3. Select Export as SVG or Export as PNG.

---

Export time entries

You can download recorded time entries in Excel format (.xlsx) and process them further.

My time entries

In the Time menu item, you can export your recorded time entries. The export is available in Overview, My Day, and My Week.

1. Open the Time menu in the left navigation bar.

2. Stay in Overview with all time entries, select the date range at the top center and group by activity, billability, project, day, week, month, quarter, or year;
   or switch to My Day or My Week.

3. Click the Export button in the top right and download the export.

Time entries for a task

1. In the task detail view, click the green Logged box in the task KPIs (Due, Planned, Logged). This gives you an overview of the time entries logged for this task.
2. Click the Export icon in the top right to export.

---

Export time reports

The report data can be exported in two ways using the icons in the top right:

• Print timesheet or save as PDF

• Export table as Excel file (.xlsx) as raw data or formatted

For more information about time reports, see here.

---

Export users

You can export the user overview or download time entries and projects for individual users.

Navigate to Settings (gear icon in the bottom left of the main menu). Select Users.

To export the user overview:

1. Sort or filter the view and select which columns to display.

2. Click the action button in the top right and select Export.

To export user time entries and user projects:

1. Select a user from the overview.

2. Open the Projects or Time entries tab

3. Click the action button and select Export.

---

Export clients

You can export the client overview or the projects and time entries of a client.

1. Open Clients in the main menu on the left under Workspace.

To export the client overview:

1. Click the action button in the top right and select Export.

To export time entries and projects for a client:

1. Select a client.

2. Go to the Projects or Time entries tab

3. Click the action button and select Export.

---

Export data via Google Sheets integration

awork offers a handy add-on for Google Sheets that lets you quickly export your most important information.

Add-on features:

• Data export: Projects, tasks, users, and time entries
• Easy integration: Load your data into your open spreadsheet with just a few clicks
• Updates: Keep your data current anytime with one click

With this add-on, you can easily create custom reports and analyses. For more information about Google Sheets integration, see here.

---

Best practices

---

FAQ

What formats can I export data in?

You can export project overviews, tasks, time entries, and user and client data in Excel format (.xlsx). Time reports can be exported as PDF (timesheet) or as Excel (.xlsx, raw data or formatted export). A project timeline can also be exported as an image (png or svg).

Where do I find the download after exporting?

Once the export has been created successfully, you'll receive a notification in awork with a link to download the document.

What's included in the timeline image export?

The export includes all displayed tasks plus the entire time range of these tasks plus one week at the start and end. Your entire configured view will also be included (e.g., zoom level, language, dark mode).

Can I also be notified by email when an export is available?

Yes. Enable the Notify me when an export is ready option in your account settings.

What data can I export via the Google Sheets integration?

Via the Google Sheets add-on, you can export your most important data: projects, tasks, users, and time entries. You can load the data into an open spreadsheet and update it anytime with one click.