Skip to main content

Import tasks from a CSV file

Easily migrate data from other tools or bulk-add tasks with a simple CSV import.

Cameron Henneke avatar
Written by Cameron Henneke
Updated this week

You can quickly import tasks into GQueues using a CSV file! This is useful if you’re moving data from another tool or creating lots of tasks at once.

Before you begin

You can import tasks into your own account or into a team (if you’re a team owner).

❗️Please Note: Each import goes to one target — either your personal account or a single team.

You’ll need a CSV file that follows the correct format. You can start from an example CSV template below.

Example CSV

Here’s are sample files with the correct format:

Simply save a copy of it and replace the sample rows with your own tasks!

Import Steps

Step 1: Prepare your CSV file

Each row in your file represents one task.

The Task Title is the only required field. Everything else is optional!

You can include data for due dates, tags, notes, and more as needed.

Step 2: Format your data

The fields below should be listed in the header row of your CSV file (in this order) and each task row should contain data in the formats listed.

Task Detail Fields

Field Name(s)

Format / Values

Default

Notes

Category Name

Text

If both Category and Queue are blank, the task goes to your Inbox (Inbox tasks are not imported for Teams)

Queue Name

Text

If a queue name is provided, a category name must also be provided (unless the queue name is Inbox)

Task Title

Text

REQUIRED

Task Notes

Text

Due Date

YYYY-MM-DD HH:MM

UTC timezone

Due Time

True, False

False

If False it ignores the hour and minutes part of Due Date

Duration

Integer number

0

Minutes

Reminder Amount

Integer number

0

Minutes before due date

Reminder Type

Text

Should be email, sms, alert, or empty

Date Created

YYYY-MM-DD HH:MM:SS

UTC timezone

Date Crossed Off

True, False

False

If provided, this task will be imported as crossed off

Date Completed

YYYY-MM-DD HH:MM

UTC timezone

Parent Task Title

Text

Must exactly match a previous Task Title

Tags

["tag1","tag2"]

Attachments

Text

Not currently supported

Repeating Task Fields

Field

Format/Values

Notes

Repeat Pattern

"Daily", "Weekly", "Monthly", "Annually" or empty

If empty, all other repeat fields are ignored

Repeat Interval

1-100

Defaults to 1 if empty

Repeat On

["Monday","Wednesday"]

Required for Weekly pattern. Valid days: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

Repeat By

"byWeek" or "byMonth"

Required for Monthly pattern

Repeat From

"due" or "completed"

Repeat End Date

YYYY-MM-DD HH:MM

UTC timezone or empty

Queue Fields

Field

Format / Values

Notes

Queue Notes

Assignment Fields

Field

Format / Values

Notes

Assigned To

Email address

Assignment Completed Date

YYYY-MM-DD HH:MM

UTC timezone. If provided, this assignment will be marked completed

Comment Fields

To import multiple comments for a single task, create a row for each comment and copy the Category Name, Queue Name, and Task Title for each row.

Field

Format/Values

Notes

Comment Created Date

YYYY-MM-DD HH:MM:SS

UTC timezone

Comment Author

Email address

Comment Text

Text

All double-quote characters (")in the CSV should be escaped by another double-quote character.

For instance, if you have a task title Create "Wow!" sign this should appear in the CSV as Create ""Wow!"" sign

If you use the Google Sheets template and Export as CSV, or open the CSV Template in Excel and Save as CSV, it will automatically take care of this escaping for you.

Step 3: Import your CSV

If you used the Google Sheet template you must first download the file to your computer as CSV.

Import to My Account

  1. Go to Settings → Import & Export → Import from CSV

  2. Click Choose file... and upload your CSV file

Import to a Team

  1. Go to Team Settings → Import → Import from CSV

  2. Click Choose file... and upload your CSV file

Step 4: Check your import

Once the import finishes, your new tasks will appear in GQueues almost instantly.

If some rows couldn’t be imported, GQueues will skip those specific tasks but continue with the rest. Common reasons include:

  • Missing Task Title

  • Invalid date or time format

  • Unsupported repeat pattern

  • Parent task listed after a subtask

  • Invalid boolean value (must be True/False)

Tips & troubleshooting

  • Handling subtasks - Subtask rows must come after their parent task row. Ensure the Parent Task Title matches the Task Title exactly.

  • Empty category and queue → If you do not specify a category and queue for a task it will be created in the Inbox (unless you are importing into a Team, in which case the task is skipped)

  • Tags colors - Tags are created in gray by default. You can change their colors after import.

  • Invalid data - Rows with incorrectly formatted data will be skipped

Did this answer your question?