Excel import out of memory error upon loading

UserBird
Dataiker
Excel import out of memory error upon loading
I am trying to load a 15MB .xlsx file but I get out of memory error, how can I solve this issue?
2 Replies
cperdigou
Dataiker Alumni
Due to the way Excel files are formatted they require a very large amount of memory to be loaded.

You can export you Excel file to a .csv file, and load the .csv file into Dataiku. Large CSV files will not cause any problem.
Clรฉment_Stenac
Hi,

At the moment, DSS cannot handle large Excel files as it needs around 100-200 times the size of the file as amount of memory. We'd recommend that you use Excel to open your file and export it to CSV.

This is a topic we're working on for the next release of DSS.
0 Kudos