Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll

Reply to message

View discussion in a popup

Replying to:
RhoiceW
QuickBooks Team

Reply to message

Hi there, cstocker and cwelch61. We appreciate you bringing up the issues with QB Enterprise reports converting to CSV files instead of XLS, and the problem with exporting reports that contain large numbers of rows. Let's work together to resolve this so you can get back to managing your tasks smoothly.

 

The 32,769-row limit when exporting to Excel is a significant issue, especially for large datasets like your General Ledger, cstocker. To work around this, try exporting your General Ledger in smaller segments, such as quarterly or monthly chunks, instead of the entire year. This way, each export will have fewer rows and stay within the limit.

 

On the other hand, when exporting the report in QBDT, there's another option besides a CSV file. Let me help you export your reports directly to Excel, cwelch61.

 

Here's how:

 

  1. When running the report, click Export.
  2. Click the dropdown button on either, Print, Email, or Excel.
  3. When you click print, the report will be saved as a PDF file.
  4. When you click Email, you'll have the report sent in Excel and PDF.
  5. Then, for Excel, you'll have a saved copy as a CSV file.

image.png

 

Furthermore, you can refer to this article to learn how to export data in QBDT: Import or export MS Excel files.

 

Additionally, I'm going to add this in case you're having trouble opening your company file in QuickBooks Desktop. Visit our support article for step-by-step guidance on resolving the issue: Can't open your company file in QuickBooks Desktop.

 

If you have any more questions or need further assistance, feel free to reach out. I'm here to help!

Need to get in touch?

Contact us