Go to CitizenLab

If you want to add a (personalized) official update to a long list of ideas and change their status all at once, you can fill out an excel sheet with the ideas, official updates you'd like to add, and/or new statuses, all added in separate columns. Please find the Excel-sheet template below, fill it out, and send it over to support@citizenlab.co. Once we receive the sheet, we'll take care of the import for you!


Export all the ideas on which you'd like to comment with an official update, and/or of which you want to change the status.


Copy all IDs (column A in your export file) of these ideas and paste them in column A ('ID') of the template you can download below.


Fill out: 

  • Your Feedback (column B): the official update that will be shown below each idea on the platform. You can personalize this update by using {{first_name}} to have the citizen's first name inserted.

  • The New Status (column C): you can choose any status that is in use on your platform. If you don't want to change the status, you can leave this column empty.

  • The Feedback Author Name (column D): this name will be shown to users and doesn't have to be a registered user on the platform. E.g.: 'Team Mobility - City of Nanaimo' or simply 'City of Nanaimo'

  • Feedback Email (column E): this is not shown to users but has to be the email of an already registered user on the platform.


Forward the filled out template file to support@citizenlab.co and mention the exact moment (day, time) the updates and status changes should be applied. Our development team takes care of the import. Please note that we need 10 working days to plan this task ahead.

Once the import is finished, every user that has posted, commented on or voted on one of those ideas will get a notification of this official update and status change via e-mail. That is, if the e-mail notification settings are set accordingly.

Need help or support? Don't hesitate to get in touch with support@citizenlab.co!

Did this answer your question?