Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
HoyHoy
Level 1

Export to Excel No Longer Opens New Spreadsheet.

Export to Excel, used to open excel, with the exported data in the tab of a new unnamed .csv file.You could save the file or drag the tab to an actual existing workbook.

 

Now Export to Excel requires you to save it to a location - then navigate to that location – then open the report. The old way was really useful in combining different reports because all you had to do is grab the .csv tab in the new sheet and drag it over to an existing workbook. Now many more clicks extra saving (of files I don't want to save), etc.

 

Is there any way to get this functionality back? And why did it go in the first place?

1 Comment 1
jeanbiverly_
QuickBooks Team

Export to Excel No Longer Opens New Spreadsheet.

Hi, @HoyHoy.

 

When exporting to Excel and creating a CSV file in QuickBooks Desktop (QBDT), you're required to save the file in a specific location on your computer.

 

In the meantime, you can use the Create new worksheet in existing workbook option and then save it as a CSV file.

 

Moreover, we understand the significance of minimizing clicks and saving time to enhance workflow efficiency. To help improve your experience with QBDT, your valuable feedback will be shared with our product development team. 

 

Here's how to send it:

 

  1. Go to the Help menu, then select Send Feedback Online.
  2. Choose Product Suggestion.
  3. Enter your recommendation or comments.
  4. Click Send Feedback, then Close Window.

 

I'll add a supplementary article that you can check out for more guidance in exporting reports to Excel from QBDT: Export reports as Excel workbooks in QuickBooks Desktop.

 

In case you need assistance in personalizing your reports, you can refer to this article: Customize reports in QuickBooks Desktop.

 

You can always get back to this thread if you need further help exporting your reports to Excel. The Community is always available.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

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