Can I export data from Quickbooks in database format? The export reports as Excel is not giving me full data line items and need a lot of manual work for data analysis.

Hello joris1,

 Thanks for connecting with us here. QuickBooks is a versatile program that helps you streamline your accounting with ease. I'll be happy to steer you in the right direction so you can get back to doing what you love. 

The  function you've described above isn't available. I can see the benefit of having the exporting options you've described and I encourage you to send feedback about this to our engineers. You can send feedback by clicking on the Gear icon and looking for Feedback. I recommend searching for a third-party data migration app that can offer more exporting options. You can search for apps on our app store www.apps.com. In the meantime, here's a helpful article that shows you how to: Export Data out of QuickBooks Online. 

Let me know if you have other questions by leaving a comment below. I'll be one message away.

@joris1 

Explore an exporter tool

https://get.transactionpro.com/qbo

Another option, use a BI app instead to integrate with QBO.