cancel
Showing results for 
Search instead for 
Did you mean: 
ajm01998
Level 2

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

 
Solved
Best answer December 04, 2020

Best Answers
Angelyn_T
QuickBooks Team

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

Thank you for the additional details, @ajm01998.

 

Allow me to step in for a moment and share with you some additional information about exporting QuickBooks reports as a CSV file.

 

Yes, this is how QuickBooks works with reports when exporting them as a .csv file. Currently, the upper limit or file format limitation of the CSV file is 32,770 rows. The good news is, yes, you can export all the rows on your report by creating a new worksheet to Excel.

 

For additional about managing reports in QuickBooks Dekstop, you can check out this article.

 

Also, feel free to open the topics from our help articles in case you need related resources while working with QuickBooks in the future.

 

If you have any other follow-up questions, please add a comment below. I'm more than happy to help. Have a good day!

View solution in original post

6 Comments
Jovychris_A
QuickBooks Team

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

Hi there, @ajm01998.

 

I appreciate the details you've shared. QuickBooks allows exporting reports into Excel. Currently, the limit in exporting reports to CSV file is 32, 770 rows. In the meantime, you can export this into a .xls file format (Excel) so that this will have the report uncut.

 

Let me show you how:

 

  1. In QuickBooks, go to the Reports menu and select Reports Center.
  2. Find and open the report.
  3. Select the Excel on the toolbar.
  4. Tick Create new worksheet and in new workbook.
  5. Then click Export.

For additional reference, you can check this article: Export report from QuickBooks Desktop to Microsoft Excel.

 

For other references, you can check this article:

 

If you need more assistance with reports, please tag me in your comment. I'll get back to you as soon as I can. Wishing you and your business continued success.

ajm01998
Level 2

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

@Jovychris_A thanks for your help.  I tried unchecking the row height box, but it made no difference to the CSV export.  It cuts off at 32770 rows every time.

 

I also tried exporting to Excel instead of CSV.  That one works fine, all the rows are displayed, although it takes a long time because the report is large.  So I guess I will export to Excel instead of to CSV.  But I find it strange that exporting to CSV doesn't work when it should be a straightforward process.

ajm01998
Level 2

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

@Jovychris_A Thank you for your help.  I am able to export using Excel without issue.  It takes a long time because the report is large, but all the rows are captured.  With CSV however, it continues to cut off at row 32770.  It seems strange to me that it would do this, I can't figure out why when the Excel export works fine.

Angelyn_T
QuickBooks Team

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

Thank you for the additional details, @ajm01998.

 

Allow me to step in for a moment and share with you some additional information about exporting QuickBooks reports as a CSV file.

 

Yes, this is how QuickBooks works with reports when exporting them as a .csv file. Currently, the upper limit or file format limitation of the CSV file is 32,770 rows. The good news is, yes, you can export all the rows on your report by creating a new worksheet to Excel.

 

For additional about managing reports in QuickBooks Dekstop, you can check out this article.

 

Also, feel free to open the topics from our help articles in case you need related resources while working with QuickBooks in the future.

 

If you have any other follow-up questions, please add a comment below. I'm more than happy to help. Have a good day!

View solution in original post

ManageMyNest
Level 1

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

Has this been addressed yet? Can we PLEASE remove the 32770 limit on CSV exports? I know you can do it to Excel, but it is SOOOOO much slower that way.

AlexV
QuickBooks Team

QB Desktop Enterprise 2018 Nonprofit: When saving reports as CSV files, the output file is cut off after only 32,700 rows. Is this normal?

Thanks for joining us here, ManageMyNest.

 

QuickBooks Desktop limits the rows to 32,770 when you export the report to a CSV file. It's best to export it to Excel while an option to remove the limit isn't available.

 

If there's a new feature or update, it'll be posted to our blog

 

Also, I've added this link for your reference. This will show you how to use the report feature of QuickBooks Desktop: Understand reports.

 

Please feel free to post again if you have more concerns. I'll be here!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up