How to fix Microsoft Excelâs “File not loaded completely” error message [SOLVED]
A client recently reached out to me with the following problem: When importing a large (72MB) CSV document, Excel reports “file not loaded completely”. đ Sure enough, data is missing. Can you help me? This issue is caused by Excel only supporting ~1,048,576 rows in a CSV file. In the client’s instance, there were around 1.6 million records. Thankfully, for Excel’s limitation, there is a relatively simple workaround: Open the CSV file in a text editor that supports large file