Discussion board where members can learn more about Qlik Sense Data Connectivity.
I've tried several times loading an excel file in Qlik Sense, but I can't.
It appear the screen when you have to select the fields, but the loading image (right/down) continues working. I've been waiting (this time) 30 minutes and, although the loading image is moving, the screen seems to be blocked
The excel file is an xlsx. of 1.6 MB, with 6 sheets. The first sheet have 3000 rows, and 67 columns. The others are small.
Hi Jose - do you have any blank rows - at the top of the excel file?
Can you send a screen-shot - of the first tab in the .xlsx file - please blur out any sensitive information.
I've deleted all the sheets but the first one, but still can't load it.
Why in the left side appears a lot of tables if I only have one sheet now?
I can load the same file in QlikView without any problems
What version of Sense are you using?
Would you be able to get us a version of an Excel Spreadsheet with no sensitive data that replicates the issue?
You should be able to load that Excel file into QlikView, make a table, then scramble the data (Settings -Document Settings - Scrambling Tab), and then export that back out. You can test this new scrambled file in Sense and if that works, there might be something in the data that's causing the issue.
Have you try to do a simple excel sheet and use that? Also, any chance the current excel sheet has weird/special characters? Have you try to make a copy of your current excel file and try the "elimination process", by removing content on the excel sheet until you notice that it works, and try the last thing you removed and see if that breaks it.