Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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!
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?
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here