1

I have an Excel file of accounts which is imported from a previous CRM version (2011), and I would like to import it to CRM Online. Some columns that hold integer values might also contain “null” in case the value does not exist.

These null values are causing errors and doesn’t allow the row to be imported, it displays the message “The source data is not in the required format.” How can I get around this and let the CRM ignore the cell data when “null” and not try to insert it into the CRM?

fixer1234
  • 28,064
user3340627
  • 213

1 Answers1

3

Are your 'null' columns containing 'null' as text or are they empty?

If this is the case just replace the text with empty column. There shouldn't be a problem importing empty columns.

If there still is a problem filter out these fields in excel and do a separate import for the ones that have a value and the ones that don't.

Bojan Borisovski
  • 146