Before you start

  • You need Project Management and Add on Projects. To download the template you also need Can export lists.
  • Your company's plan is active and has room for the projects.
  • One file holds up to 150 projects. It must be .xlsx or .xls and under 500 KB.

Steps

  1. In the sidebar, select Projects › List.

  2. Select Download Template. The message "Template downloaded" shows and the file projects_template.xlsx is saved.

    Step 2. The Download Template and Bulk Upload buttons on the project list.
    Step 2. The Download Template and Bulk Upload buttons on the project list.
  3. Open the file. Row 1 holds the column names and row 2 holds a hint for each column. Keep both rows.

  4. Enter one project per row below them.

    FieldRequiredWhat to enter
    nameYesThe project name.
    projectTypeNoinstallation, replacement, repair, upgrade or inspection. A blank saves no type; set it later in Edit Project.
    priorityNolow, medium or high.
    unitSystemNoImperial or SI.
    descriptionNoFree text.
    budgetNoThe estimated project value.
    manualContractValueNoThe contract value, if already agreed.
    estimatedDurationNoDuration in days.
    locationAddressYesThe site's street address.
    locationCityYesThe site's city.
    locationStateNoThe site's state.
    locationZipNoThe site's ZIP code.
    landmarkNoA landmark near the site.
    clientNameYesAn existing client, or a new client's name.
    clientEmailNoThe client's email.
    clientPhoneNoRequired if the client is new.
    clientCompanyNoRequired if the client is new.
    clientAddressNoRequired if the client is new.
    startDateYesThe start date.
    endDateNoThe end date.
    projectManagerNoThe project manager.
    requiresPermitNoWhether building permits are needed.
    hasExistingSystemNoWhether there is an existing HVAC system.
    notesNoFree text.
  5. Save the file.

  6. On the project list, select Bulk Upload and choose the file.

Result

The message "Bulk upload complete: [number] created." shows, or the message the server sends. Each imported project is in the list with Pending and has its stages ready, as a project added by hand would. See Which stages a new project gets.

If some rows had no project type, a warning says "No project type on [number] row(s): ... Set the type in Edit Project." See Edit a project.

If something is different