"File not loaded completely"
The CSV has more than 1,048,576 rows, the limit of an Excel sheet. Excel opens the beginning, warns, and the rest is not there: a total calculated afterwards will be wrong without saying so.
What the message says
An Excel sheet has 1,048,576 rows and 16,384 columns. What goes beyond is not loaded.
Why it appears
- A full export of a database, of logs, of a year of transactions.
- A file of several hundred megabytes, sometimes several gigabytes.
Making it go away
- Filter before opening: keep only the useful rows (a period, a region).
- Split the file into chunks of fewer than a million rows.
- Go through Power Query and the data model, without displaying the rows in a sheet.
The tool that handles it
Open a large file reads a multi-gigabyte CSV from your disk, in chunks: you browse it, filter it, sort it and export what fits in Excel. Split a file cuts it into files of the size you want.
Frequently asked questions
- How many rows can Excel open?
- 1,048,576 per sheet, header included, since Excel 2007.