Data appears in preview but doesn't load

[Jossy]

Hi there,

I'm uploading some data from an Excel file and it appears fine in the preview. However, when I hit load it only loads the column headers. I've copied and pasted only the value to get rid of any funky formulas (these have caused me a problem in the past). Any ideas?

Jossy

[Jossy · Accepted solution]

Hi,

It would appear some blank rows at the bottom of the Excel were causing the problem. Deleting them fixed it!

Jossy

[Bjoern]

@Jossy, thank you for solving that.

To avoid "blank rows" you can convert the data-part of the excel sheet into a table, it should automatically get rid of the empty data.