1.4 Import Multiple Activities via CSV

Use CSV import when you already have multiple Progress Activities to create at once.

Instead of adding activities one by one, you can upload a CSV file, review the activity data in a spreadsheet-like table, fix any errors, and then add the valid activities to GoBuid.


CSV import is useful when you are setting up a new project, copying activity data from an existing schedule, or preparing multiple activities across different projects.



In this article


📥 How It Works

  1. Download the Sample File
    • The sample .zip contains:
      • ImportActivities.csv – Template to fill in your data
      • README.txt – Field instructions and sample values
  1. Fill in Your Activities

    • Include required fields like:

      Project, Activity, Total Qty, Unit, Starts, Ends

    • Optional field: Location (accurate GPS format only)
  1. Upload the File
    • The system will automatically scan the file and highlight any errors.
  1. Fix Errors Online
    • You can edit directly in the table view.
    • Use the error panel to jump to invalid rows.
  1. Submit Valid Activities
    • You may choose to:
      • Submit only valid rows (invalid rows will be discarded)
      • Or fix all errors before submitting

Import activities from CSV

To import activities:


  1. Open a project.
  2. Go to Project -> Progress.
  3. Select Import CSV.
  4. Download the sample file.
  5. Fill in the CSV file with your activity data.
  6. Upload the completed CSV file.
  7. Review the imported activities in the table.
  8. Fix any highlighted errors.
  9. Select Add Activities when the activities are ready.

The sample file includes the required columns and example values. Use it as the starting point to avoid formatting errors.




🧾 Field requirements

Field Required Description
Project Yes The project where the activity should be added. The project name must match a project you have access to. You can enter a different project name to add the activity to that project.
Activity Yes Name of the Progress Activity.
Total Qty Yes Target quantity for the activity. Enter numbers only.
Unit Yes Unit used to measure the activity, such as m, m2, item, or lot.
Starts Yes Activity start date. Use YYYY/MM/DD  format.
Ends Yes Activity end date. Use YYYY/MM/DD  format. The end date must be after the start date.
Location No Optional GPS coordinates for the activity location, such as 1.281619, 103.860433 .

Even when you import from inside a specific project, the Project field is still required. GoBuid uses this field to decide which project each activity should be added to.

Review and fix errors

After you upload the CSV file, GoBuid checks the file and highlights any rows or cells with errors.


You can:


  • edit values directly in the table
  • use the error panel to find invalid rows
  • hover over highlighted cells to see more details
  • download the edited CSV if you need to keep a copy before leaving

Fix all required errors before submitting if you want every activity to be imported.



Submit valid activities

When the table contains valid activities, select Add Activities.

If some rows still have errors, GoBuid may let you add only the valid activities.


Warning

If you choose to submit only valid activities, rows with errors will be discarded and will not be imported. You will not be able to return to the same import review screen to fix those discarded rows later.

To keep a copy before leaving, download the CSV first.



⚠️ Common Errors

Type Example message How to fix it
Missing required field Activity name is required Fill in the missing required value.
Invalid quantity Quantity must be a number Enter numbers only in Total Qty.
Invalid date format Invalid start date Use YYYY/MM/DD  format.
Invalid date range End date must be after start date Make sure Ends is later than Starts.
Unknown project Project not found Check that the project name is correct and that you have access to the project.
Invalid location Unrecognized location format Use GPS coordinates, such as 1.281619, 103.860433 , or leave the field blank.

You’ll see errors directly in the table and the error panel on the right. Hover over cells for more info.

Notes

  • Activities with errors will not be imported unless the errors are fixed.
  • Submitting valid activities only will discard invalid rows.
  • The Project field is required for every row.
  • Use the sample file when preparing your CSV.
  • Keep the date format as YYYY/MM/DD .

📍 Tip: Convert addresses to coordinates

Use tools like:

🌐 latlong.net

🌐 Google Maps