Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can't load Excel File

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.

11 Replies
Michael_Tarallo
Employee
Employee

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.

Mike

Regards,
Mike Tarallo
Qlik
Giuseppe_Novello

Jose,

When you select the other table can you see data? or only the "farmacias" table has issues?

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
fkeuroglian
Partner
Partner

Jose podes enviar el excel para probarlo?

las otras pestañas del excel te muestra informacion en qlik sense?

slds, Fernando

Not applicable
Author

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

Not applicable
Author

Can't send the excel, as it has sensitive data.

Not applicable
Author

The programam stops working, so I can't select any other tables.

Not applicable
Author

There are any rows.

Can't send the excel, as it has sensitive data.

I've modified the data, but still not working:

pbr
Employee
Employee

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.

Giuseppe_Novello

Jose,

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.

Gio

Giuseppe Novello
Principal Technical Support Engineer @ Qlik