Blank cell translation
- Last UpdatedApr 24, 2025
- 1 minute read
When importing data from an Excel file, a blank cell may not be translated as you intended. The following table outlines how different types of blank cells are translated into Advanced Database Editor (ADE) fields.
|
Excel Cell Content & Type |
ADE field translates as: |
|---|---|
|
Empty cell under a string column (that is, description). |
Keeps the existing value that is in the database |
|
Enter blank in a cell under a string column. |
Empty field |
|
Empty cell under a numeric column (for example, analog.tolerance). |
Keeps the existing value that is in the database |