Skip to main content





How to bootstrap numeric data from Excel with blank cells


I am trying to bootstrap data from an Excel spreadsheet with blank cells. However, I get an error from blank cells defined as numeric fields. How can I import data from an Excel file with blank cells?

image alt text


Blank cells cannot be interpreted as numeric, either integer or decimal. You have two options:

  • Change the spreadsheet. Change blank cells defined as numeric fields to 0.

  • Change the import process. Define the numeric fields as Text. Then, use a Data Type Conversion function such as TextToDecimal to convert the text to Decimal or Integer.

  • Was this article helpful?