The value null cannot be found in the list of items Error

Summary:

HSDL Error # The value null cannot be found in the list of items

Content (please ensure you mask any confidential information):

Hi Team,

Greetings!

This is a strange error found in case of HSDL load in the worksheet

"The value null cannot be found in the list of items for Calibration Status."

There are 3 possible values on UI for the same including the blank value, but when we change the value on Spreadsheet to blank value, it fails with error of "The value null cannot be found in the list of items for Calibration Status."

Why does it not accept blank value in HSDL when the same is accepted on UI?