Excel rate table import validations

PolicyCenter performs the following validations on Import from Microsoft Excel:

Is the file based on an Excel workbook that PolicyCenter exported? The validation checks that the headers are correct and in the right order.
Does the file have the same column count for the header row as the rate table? The validation ignores display-only fields.

A violation causes the import to fail immediately.

PolicyCenter also ensures that data values for parameters with value providers adhere to the value provider edit rules. Any violations of these rules does not cause the import to fail, but the invalid value is blanked out and an error message appears on the Rate Table Editor page.