cancel
Showing results for 
Search instead for 
Did you mean: 
Q_B_compatibility_question
Level 1

If my QBOnline on a Mac suddenly exports spreadsheets full of zeroes, even just using Quick Look to view on the desktop, how can I export data to spreadsheets?

I use LibreOffice now instead of Excel, but even before opening the file, Quick Look shows the export went wrong. How can I fix this?
4 Comments 4
JenoP
QuickBooks Team

If my QBOnline on a Mac suddenly exports spreadsheets full of zeroes, even just using Quick Look to view on the desktop, how can I export data to spreadsheets?

I'd like help with your question about exporting data to a spreadsheet, Q_B_compatibility_question.

 

When exporting reports or data from QBO to Excel, the system will give you a protected view. Let me share this article from Microsoft for more details: What is Protected View?

 

To get the correct values and numbers, you just need to click the Enable Editing button in the upper part of the Excel file. 

 

I'd also like to share these articles for additional reference when running reports in QBO:

 

 

Add a reply below or reach out to us anytime you need anything from us. We're always here to guide and assist whenever you need help.

JenoP
QuickBooks Team

If my QBOnline on a Mac suddenly exports spreadsheets full of zeroes, even just using Quick Look to view on the desktop, how can I export data to spreadsheets?

Hi Q_B_compatibility_question.

 

Hope you’re doing great. I wanted to see how everything is going about exporting your data to spreadsheet. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

 

Looking forward to your reply. Have a pleasant day ahead!

Q_B_compatibility_question
Level 1

If my QBOnline on a Mac suddenly exports spreadsheets full of zeroes, even just using Quick Look to view on the desktop, how can I export data to spreadsheets?

Hi, thanks for the attempt, but to be more clear about the problem.

--I am no longer using Excel, I use LibreOffice

--Even **before** I attempt to open the exported QB report, on my Mac desktop when I click "Quick Look" at the export-file, I see all zeroes in the money cells.

Doesn't that indicate that this issue in in how QB is exporting, and not in how any other software is importing?

 

MadelynC
QuickBooks Team

If my QBOnline on a Mac suddenly exports spreadsheets full of zeroes, even just using Quick Look to view on the desktop, how can I export data to spreadsheets?

I’m here to share some information with you, @Q_B_compatibility_question.


QuickBooks Online can only export data to Excel. You can use a third-party app or converter tool so you can move your data to spreadsheets successfully.


QuickBooks offers third-party applications which are located in our Apps center. You can visit it and then check which app works best for you. You can also go to your Apps menu. Here are the steps to do it:

 

  1. Select the Apps menu from your left navigation pane.
  2. Enter a keyword in the Search field.
  3. Select and open the app. You can read reviews or feedback from other users to help you decide further.


This guide provides more information on how to move your data from QuickBooks: Export reports, lists, and other data from QuickBooks Online.


Please don’t hesitate to let us know if you have other questions or concerns with managing your data. We're here to help. Always take care!

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

Need to get in touch?

Contact us