Download our spreadsheet template, or create your own with the columns below. You may omit or leave columns blank. The most important are in bold.
Ward 2for example)
Councillorfor most municipalities)
A1A 1A1for example)
1 555 555-5555 Ext. 5555for example)
If you would like to specify multiple addresses or numbers, add a parenthesized label to the column header, e.g.
Save the spreadsheet in the CSV file format. Microsoft Excel and other programs can do this.
Upload the CSV file to your municipal website. You may need to ask your webmaster.
Email us the link to the spreadsheet, and we'll quickly add the information to Represent.
If you have an open data catalog, you may specify that "This dataset conforms to the Represent CSV Schema for elected officials' contact information."
Now, all you have to do is update the spreadsheet when information changes. We'll automatically import those changes.
If you have any questions, please do not hesitate to contact us.