Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue with Adding Data in Excel Format

Hi All,

I am new to Qlik Sense and just starting out with its functionalities. I receive a large amount of data as Excel files and I save from my outlook to a folder without opening the file. When I open add data in Qlik Sense, and the load table opens, only 4 columns are available while the original file has 20 fields.

If I open the excel file, save it and add data in qlik sense again, now I can see all 20 columns. Also, if i save as csv, all fields are visible. Please let me know what is causing this issue and how do I resolve it? Our ETL at data source cannot output csv format.

Appreciate any help! Thank you.

Vikram

0 Replies