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 rid of any funky formulas (these have caused me a problem in the past). Any ideas?

 

Jossy

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

2 Replies

  • 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.