Happy Business Starts Here

"File not loaded completely" message while opening the large file downloaded from Zuora using Excel

Highlighted
Zuora Support
Zuora Support

"File not loaded completely" message while opening the large file downloaded from Zuora using Excel

Question:

After downloading a huge file from Zuora, especially from the accounting period, such as AccountsReceivableAgingAccountExport_20181203171106, you may fail to open it using Excel with a pop-up alert - "File not loaded completely".

 

Solution:

This is the limitation of Excel, instead of Zuora. The maximum row number that Excel supports is 1,048,576.

If you want to download or export a large CSV file, Zuora officially recommends you to use text editors other than Microsoft Excel to open the file. As we documented below:

https://knowledgecenter.zuora.com/CC_Finance/E_Accounting_Periods/F_View_Accounting_Period_Balances/...

One unofficial suggestion for your reference (as this question has out of Zuora support, maybe you have known, or you are able to find a better approach):
-1. Back up .csv file.
-2. Rename .csv with .txt.
-3. Split the .txt file into different smaller files, such as:

split -l 1000000 AccountsReceivableAgingAccountExport_20181203171106.txt

-4. Change the newly generated .txt files back to .csv.
-5. Copy the first row from the first file into others.



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √