Skip to main content

Export task and project list data in GUIDE 2.0

Export tasks or projects from GUIDE 2.0 when you need to work with list data outside GUIDEcx, such as reviewing it in a spreadsheet, performing additional analysis, or sharing a point-in-time file with your team.

Written by Elan Maynez

Overview

Exports use the filters, search, and sort currently applied to the list and include every matching record—not just the records visible on the current page. You can download the results as a CSV or JSON file.

Where exports are available

You can export data from two places in GUIDE 2.0:

  • Tasks

  • Project list

Exports are not currently available from GUIDE 1.0 pages, individual project plans, reports, or other lists.

Who can export data

The Export option is available to these internal GUIDEcx roles:

  • Admin

  • Manager

  • Guide

Task Owners, Contributors, customer users, and partner users do not see the Export option.

Your workspace must also have data exports enabled. If you have an eligible role but do not see Export, the feature may not be enabled for your workspace.

Note: Exporting does not give you access to additional records or restricted information. The export follows the same access rules as the list you are viewing. For example, internal tags, warnings, or RAG information are included only when you have permission to see that information.

Export tasks or projects

  1. Open Tasks or the GUIDE 2.0 Project list.

  1. Apply any filters, search terms, or sorting you want to use.

    The export will use the current list criteria, so you can narrow the data before downloading it.

  2. Select Export.

    • On the Project list, Export appears next to the project creation button.

    • On Tasks, Export appears next to the saved filters button.

  3. Review the number of rows that will be exported.

  4. Choose CSV or JSON.

  5. Select Download.

GUIDEcx begins loading the matching records and displays the export progress.

When the export finishes, your browser saves the file to your computer and GUIDEcx confirms the number of exported rows and the file name.

Manage an export while it is running

You do not need to keep the export window open while GUIDEcx prepares the file.

Hide the export window

Select Hide to close the export window while the export continues.

A progress button appears in the lower-right corner of GUIDEcx. Select it to reopen the export window and check progress.

You can continue moving between GUIDE 2.0 pages while the export runs.

Cancel an export

Select Cancel export at any time.

The export stops and no file is saved.

Keep GUIDE 2.0 open

The export runs in your browser, so keep the browser tab open until the download finishes.

The export stops if you:

  • Close the tab.

  • Reload the page.

  • Navigate to a GUIDE 1.0 page.

  • Leave GUIDEcx for another website in the same tab.

Your browser may warn you before leaving the page. If you leave, the export must be started again.

How filters, search, and sorting affect the export

The export includes all records matching the list's current filters and search, using the current sort order.

This means an export can contain more records than you see on the current page.

For example, if your Tasks list is filtered to:

  • Project Manager = Jordan

  • Status = In Progress

  • Due Date = This Month

the export includes all tasks matching those criteria, subject to your normal GUIDEcx access.

Changing which columns are displayed in the list does not change the export. The export always includes its full set of supported columns and custom fields, including fields that are currently hidden in the list.

Choose CSV or JSON

CSV

Choose CSV when you want to open the data in applications such as Excel, Google Sheets, or Numbers.

A CSV export contains:

  • One header row.

  • One row for each task or project.

  • UTF-8 text formatting so accented and non-Latin characters display correctly in common spreadsheet applications.

If multiple values belong in one field, such as several tags or assignees, they are separated with ; .

Related multi-value columns use the same order. For example, the second value in Assignees corresponds to the second value in Assignee Member IDs.

JSON

Choose JSON when you want to process the export programmatically or use it with another technical workflow.

The file contains an array with one object for each exported task or project.

File names and dates

Exported files use names such as:

  • tasks-YYYY-MM-DD.csv

  • tasks-YYYY-MM-DD.json

  • projects-YYYY-MM-DD.csv

  • projects-YYYY-MM-DD.json

The date in the file name uses UTC.

Dates inside the export are also represented as calendar dates in UTC, such as 2026-09-01, without a time.

What's included in a task export

A task export includes the standard task fields below, followed by your workspace's task custom fields.

Category

Included fields

Task

Task ID, Task, Status, Status Category, Status Explanation

Project

Project, Project ID, Project Status, Project Status Category, Project Status Explanation

Structure

Phase, Phase ID, Milestone, Milestone ID, Parent Task, Parent Task ID, Is Subtask

Customer

Customer, Customer ID

Ownership

Assignees, Assignee Member IDs, Role, Project Manager

Dates

Start Date, Due Date, Project End Date, Created Date, Completed Date

Relationships and classification

Tags, Tags Internal, Dependencies, Dependency Types, Dependency Unit IDs, Dependency Statuses, Visibility, Responsibility

Time

Estimated Hours, Logged Hours, Billable Hours, Non-Billable Hours

Completed Date

Completed Date shows when a task was marked done. It is blank when the task has not been completed.

Task hours

A task's Logged Hours, Billable Hours, and Non-Billable Hours include time logged directly to that task.

Hours logged to subtasks are not rolled into the parent task's row. Each subtask appears as its own exported record.

If you do not have access to time-tracking reporting information, these hour fields are blank.

A value of 0 means no time was logged. A blank value can mean the value is not available to you.

What's included in a project export

A project export includes the standard project fields below, followed by your workspace's project custom fields.

Category

Included fields

Project

Project ID, Project, Customer, Customer ID

Status

Status, Status Category, Status Explanation

Ownership

Project Manager, Project Manager ID

Task health

Total Tasks, Completed Tasks, Overdue Tasks, Unassigned Active Tasks, Stuck Tasks, Remaining Tasks, % Complete

Dates

Start Date, Planned End Date, Forecasted End Date, Last Updated, Days Elapsed, Done Date, Created Date, Kicked Off Date, Status Changed Date

RAG

RAG Status, RAG Description, RAG Mitigation, RAG Updated

Classification and warnings

Tags, Tags Internal, Warnings, Unfulfilled Internal Roles

People

Customer Users

Project details

Cash Value, Brand, Brand ID, Project URL

Time

Allotted Hours, Logged Hours, Billable Hours, Non-Billable Hours

% Complete

% Complete is the number of completed tasks compared with the project's total tasks, expressed as a whole number.

It is blank when the project does not contain any tasks.

Status Changed Date

Status Changed Date shows when the project's current status was set.

Project URL

Project URL links to the project's plan.

Project hours

Project-level Logged Hours, Billable Hours, and Non-Billable Hours include time logged to the project's tasks as well as time logged directly to the project.

If you do not have access to time-tracking reporting information, these fields are blank.

How custom fields are exported

Task and project exports also include workspace custom fields.

  • Task exports include task custom fields.

  • Project exports include project custom fields.

  • Each custom field gets its own column.

  • Custom fields appear after the standard export columns.

  • Fields follow the workspace's custom field order.

  • The column heading uses the custom field's label.

Select fields contain the selected option's name. Toggle fields are exported as true or false. Other values are exported as stored.

If a custom field has the same name as a standard export column, GUIDEcx adds (Custom Field) to its heading.

For example, a custom field named Customer is exported as Customer (Custom Field).

Understand blank values

An empty value means GUIDEcx does not have a value to export for that field or the value is not available to you.

Do not assume an empty numeric field means 0.

For example:

  • 0 logged hours means no time was logged.

  • Blank logged hours may mean you do not have access to that information.

  • Completed Date is blank for an incomplete task.

  • % Complete is blank for a project with no tasks.

CSV formula protection

CSV exports protect cells from being interpreted as formulas by spreadsheet applications.

If a value begins with any of these characters:

  • =

  • +

  • -

  • @

GUIDEcx adds a leading apostrophe (') to the exported CSV value.

For example, a stored value of -5 appears in the CSV as '-5.

This behavior applies only to CSV files. JSON values are not changed.

Export limits

Maximum of 100,000 rows

A single export can contain up to 100,000 rows.

If more than 100,000 records currently match your list:

  1. GUIDEcx tells you that the export is too large.

  2. Narrow the list using filters or search.

  3. Start the export again.

GUIDEcx does not create a partial export when the list exceeds the limit.

If the matching list grows beyond 100,000 records while an export is already running, the export stops instead of creating a partial file.

One export at a time

You can run only one export at a time.

If an export is already running and you select Export again—including from the other supported list—GUIDEcx reopens the active export instead of starting another one.

Large exports may take longer

GUIDEcx loads export records in batches and builds the file in your browser. Larger exports therefore take longer and use more of your computer's available memory.

If your computer begins slowing down, you can cancel the export.

Exports are not a database snapshot

GUIDEcx loads records in batches while the export is running.

If tasks or projects are being created, removed, or updated at the same time—and those changes affect their position in the current sort order—a record can occasionally be missed or appear more than once.

For the most consistent results, consider exporting during a period when the records you are exporting are not being heavily updated.

If an export fails

If loading a portion of the export times out, GUIDEcx automatically retries it. The progress message may display Retrying while this happens.

If GUIDEcx cannot complete the export, the export stops and displays an error.

Select Try again to restart the export from the beginning.

Frequently asked questions

Does Export download only the page I'm viewing?

No. It exports every record matching the list's current filters and search, up to the 100,000-row limit.

Can I choose which columns to export?

No. Each export includes the supported standard fields and all applicable custom fields. Changing visible or hidden columns in the list does not change the export.

Can I export directly to Excel?

No. Exports are available as CSV or JSON.

You can open a CSV file in Excel after downloading it.

Can I schedule an export or have it emailed to me?

No. Exports are created manually in your browser and downloaded directly to your computer.

Does GUIDEcx keep a history of my exports?

No. The completed file is downloaded by your browser. GUIDEcx does not provide a history of previously generated export files.

Can I leave the export running and use another GUIDE 2.0 page?

Yes. You can navigate between GUIDE 2.0 pages while the export continues.

Do not reload the browser tab, close it, navigate into GUIDE 1.0, or leave GUIDEcx until the export finishes.

Why are some fields blank?

A blank field can mean there is no value for that record or that the value is not available based on your access.

For example, time-tracking fields are blank when you cannot view time-tracking reporting information.

Did this answer your question?