Import Multiple Activities via CSV

In this article


You can create multiple activities at once by uploading a CSV file and reviewing them in a spreadsheet-like interface before importing. This helps streamline activity setup for your projects.

📥 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
  2. Fill in Your Activities

    • Include required fields like:

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

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

🧾 Field Requirements

Field Required Description
Project ✅ Must match a project you have access to
Activity ✅ Name of the activity
Total Qty ✅ Enter a number only
Unit ✅ Choose or create a unit
Starts ✅ Format YYYY/MM/DD   or YYYY-MM-DD HH:mm   (24-hr)
Ends ✅ Must be after Starts
Location ❌ Optional; use accurate GPS coordinates (e.g., 1.281619, 103.860433)

⚠️ Common Errors

Type Example Message
Missing Required Activity name is required
Invalid Format Quantity must be a number
Invalid Date End date must be after start
Unknown Reference Project not found
Invalid Location Unrecognized location format

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

📌 Notes

  • Tasks with errors won’t be imported unless fixed.
  • Submitting valid rows will discard invalid ones. You won’t be able to return to fix them later.
  • Use the sample file to avoid common mistakes.

📍 Tip: Convert addresses to coordinates

Use tools like:

🌐 latlong.net

🌐 Google Maps