Add Property Tax Field Data

Adding Years to the spreadsheet

These values represent each year for which you want to add property tax data.

To add years to your spreadsheet follow these steps:

1. Open the property tax calculator excel spread sheet
2. Select the 'Years' worksheet
3. In the 'Years' column add each year for which you want to provide property tax information. These should be in full 4 digit format (e.g. 2024), and should be entered one year and in chronological order with the most recent year at the top. You can add as many years as you like
4. Save your file

The final version will look something like this.

Adding Wards to the spreadsheet

These values represent each ward for which you want to add property tax data.

If you would like to change the name of the property tax areas to something else (districts, regions, divisions, etc.) you can customize the display name in the public interface through the dictionary. Do not change the name of the worksheet or the column in the spreadsheet.

To add wards to your spreadsheet follow these steps:

1. Open the property tax calculator excel spread sheet
2. Select the 'Wards' worksheet
3. In the 'Name' column add each ward to its own row. There are no restriction on how you name your wards (neighborhood names, colors, numbers, etc.). Note that the order your wards are added will match their order in the public interface
4. If you are working with a multilingual website add the translated ward name to the 'Translation' column for each entry. If your website is not multilingual this column can be left blank
5. Save your file

The final version will look something like this.

Adding Classes to the spreadsheet

These values represent each tax class for which you want to add property tax data.

If you would like to change the name of the property tax classes to something else (departments, divisions, codes, etc.) you can customize the display name in the public interface through the dictionary. Do not change the name of the worksheet or the columns in the spreadsheet.

To add classes to your spreadsheet follow these steps:

1. Open the property tax calculator excel spread sheet
2. Select the 'Classes' worksheet
3. In the 'Name' column add each class to its own row. There are no restriction on how you name your classes. Note that the order your classes are added will match their order in the public interface
4. If you are working with a multilingual website add the translated class name to the 'Translation' column for each entry. If your website is not multilingual this column can be left blank
5. Save your file

The final version will look something like this:

Adding Categories to the spreadsheet

These values represent each tax class for which you want to add property tax data.

If you would like to change the name of the property tax classes to something else (departments, divisions, codes, etc.) you can customize the display name in the public interface through the dictionary. Do not change the name of the worksheet or the columns in the spreadsheet.

To add classes to your spreadsheet follow these steps:

1. Open the property tax calculator excel spread sheet
2. Select the 'Classes' worksheet
3. In the 'Name' column add each class to its own row. There are no restriction on how you name your classes. Note that the order your classes are added will match their order in the public interface
4. If you are working with a multilingual website add the translated class name to the 'Translation' column for each entry. If your website is not multilingual this column can be left blank
5. Save your file

The final version will look something like this: