The Salary Assessor allows users to import up to 500 job titles to the Benchmark List or Advanced Reports. When importing to the Benchmark List, there is the option to include salary data.
To import these titles, first save your job list. Create a list of job titles and annual salaries using a program like Microsoft Excel and save it as a .CSV (comma delimited) file. ERI provides users with a .CSV file template to simplify the upload process.
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.Click the 
button in the Benchmark List or Advanced Reports to download and save a .CSV file template.
2.Open the .CSV file template using a spreadsheet program like Microsoft Excel.
3.A header row is required to identify each column (included in the template). Any of the following column headers are acceptable (the program is not case-sensitive):
Job, Job Title, Title, ERI Title, Position, Position Title
Salary, Actual Salary (Benchmark List only)
The following example displays the correct format for the .CSV file in the Benchmark List:
Any data that is not formatted correctly in the .CSV file will not be displayed in the Benchmark List or Advanced Reports.
4.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.
5.Close the .CSV file.
To Import a .CSV File
1.Click the 
button in the Benchmark List or Advanced Reports.
2.In the File Upload window, select the .CSV file to upload by clicking the Browse button and Open. Then click OK.
3.In the Upload List from File window, the rows that have been successfully imported are displayed. Any jobs that do not match ERI jobs are pulled into a separate list, and suggested jobs are provided using an updated Semantic Search algorithm. Select a suggested job for any unmatched titles, as needed.
4.Click OK to return to the Benchmark List or Advanced Reports.
The .CSV file shown above will be displayed as follows in the Benchmark List.
To Export
See Export to PDF
See Export to Excel