Additional Geographic Assessor Topics (Listed Alphabetically)

The Geographic Assessor (GA) allows users to import up to 40 salary levels to the Cost of Labor List or Cost of Living List from a .CSV file.

If you attempt to upload another file format, then this message is displayed: "We currently only support '.csv' file format for upload."

To Create a .CSV File

1.Using a program like Microsoft Excel, create a list of annual salary levels.

2.Once the table is complete, give the file a unique name (different from the template file name) and save the file in a .CSV (comma delimited) format.

3.Close the .CSV file.

Note: The salaries in the list must be annual (not hourly, weekly, monthly, etc.). To display a different salary value, please see Salary Value Types. Any data that is not formatted correctly in the .CSV file will not be displayed in the Cost of Labor List or Cost of Living List.

To Import a .CSV File

1.In the Cost of Labor List or Cost of Living List, click the Customize Table Headers button in the Options panel.

2.In the Modify Salary Levels dialog, click the Upload Salary Levels button.

3.Select the .CSV file to upload by clicking the Browse button and then Open.

4.Click the OK button.

5.The Modify Salary Levels dialog will display the values that you have successfully imported. If the .CSV file contains any errors, then a message will display the number of errors encountered during the import and will list the values needing review.

6.Click OK to return to the Cost of Labor List or Cost of Living List.

See Using GA FAQ #22 and Salary Structure Variances for more information.

To Export a Comparison List

See Export to PDF and Export to Excel.

Import Salary Levels

Import Salary Levels