Skip to main content

πŸ“₯ Upload an Entire Project Quote

Updated over 3 weeks ago

The Upload Entire Quote feature allows you to quickly create a full quote by importing an Excel or CSV file. This lets you upload Deliverables, Tasks, and Resources in one step instead of adding them manually.


πŸ› οΈ How to Upload a Quote

  1. Open the Project in the Admin Portal.

  2. Go to the Quote tab.

  3. Click Upload CSV in the top right.

  4. Select Entire Quote.

  5. Upload your CSV or Excel file.

⚠️ Note: The upload option only becomes available once a Project Title has been created.


βš™οΈ Import Options

When uploading your file, choose how the data should be applied:

Add
Adds the new items from your file to the bottom of your existing quote.

Overwrite
Replaces the entire quote with the uploaded file. Existing deliverables, tasks, and resources will be deactivated before the new data is imported.


πŸ“ File Structure

Your file must follow the correct hierarchy so SprintSuite can organise the quote correctly.

Deliverable
Main project phase.

Task
Work item under a Deliverable.

Resource
Labour, assets, materials, or costs linked to a Task.

The file is read from top to bottom, so items are grouped under the level above them.


πŸ“Š Required Columns

Column

Required

Description

Level

Yes

Deliverable, Task, or Resource

Name

Yes

Item name

Budget Type

Yes*

labour, asset, inventory, item, custom, inapplicable

Billable

Recommended

true/false

Charge Out Rate

Recommended

Client charge rate

Cost Rate

Recommended

Internal cost

Start Date / End Date

Optional

Format: YYYY-MM-DD

Quantity

Optional

Numeric value

*Budget Type determines how the cost is categorised in project reporting.


πŸ“‚ Supported Files

  • CSV

  • Excel (.xlsx, .xls)

If your Excel file contains multiple sheets, you will be prompted to select which sheet to import.


πŸ’‘ Tips

  • Use Download Sample CSV in the upload modal to get the correct template.

  • Ensure dates use the format YYYY-MM-DD.

  • Always follow the structure: Deliverable β†’ Task β†’ Resource.

  • If the upload fails, SprintSuite will show the row with the error so you can fix and re-upload.

Did this answer your question?