Forum Discussion

Jossy's avatar
Jossy
Regular Visitor
10 years ago
Solved

Data appears in preview but doesn't load

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 ri...
Need Help
  • Jossy's avatar
    Jossy
    10 years ago

    Hi,

     

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

     

    Jossy

Jossy's avatar
Jossy
Regular Visitor
10 years ago

Hi,

 

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

 

Jossy

Bjoern's avatar
Bjoern
Icon for Continued Contributor rankContinued Contributor
10 years ago

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.