Ready for Dataiku 9? Try out the Crash Course on new features! GET STARTED

Excel import out of memory error upon loading

UserBird
Dataiker
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
Dataiker
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
Dataiker
Dataiker
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
Labels (3)
A banner prompting to get Dataiku DSS