Forum Discussion
More than 1,048,576 rows
I have been sent a 4.4GB Excel .CSV file. It has 16columns, but several million rows. When I try to open it, it only opens the first 1,048,576 rows. Is there a way to open the whole file? I don't min...
To my knowledge - no. You may split csv on several files and open them one by one. Or import into the Excel using legacy wizard, it has an option from which row to start importing. Something like this.
Could you please provide me steps with screenshots for more clarity?SergeiBaklan
Sorry, I didn't catch, steps for what, how to load csv file into Excel data model?