Export data to Google Sheets with QuickBooks Online Advanced
by Intuit• Updated 2 months ago
You can now export QuickBooks reports to Google Sheets using QuickBooks Online Advanced.
Before you begin
If you are exporting data for the first time:
• Ensure you have a Google account already created
• Adjust your web browser settings to allow pop-up windows from QuickBooks Online
Export data to Google Sheets
1. Log in to your QuickBooks Online account.
2. Go to Reports (Take me there).
3. Open the report you’d like to export to Google Sheets.
4. Select the Export to Google Sheets option from the Export ▼ dropdown menu.
You are sent a verification code to verify your access and identity.
- Enter the verification code sent to you.
- Select Get started.
- Review the permissions information presented.
- Select Allow to accept permissions.
Your Google account opens.
- Sign in to Google, if prompted, and follow the next steps.
- Google Sheets links to your QuickBooks Online account and allows for the export of data.
Note: If you have previously completed your verification, you can access Google Sheets.
Manage exported Google Sheet data
Once the Google Sheet is created, any exported data will be saved on the Google Sheet and can be accessed using the same Google account. The exported data is not controlled any longer by Intuit, and the Google Sheet cannot be imported back into QuickBooks Online.
Note: Any data exported to a Google Sheet will not reflect subsequent changes made in QuickBooks Online unless another export is undertaken.
How can I best use Google Sheets?
Review this article to learn ways to use Google Sheets integration in QuickBooks Online Advanced as an Accountant.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Import customers or suppliers from email contacts or a spreadsheet to QuickBooks Onlineby QuickBooks•19•Updated August 29, 2024
- Make a copy of your QuickBooks Online Advanced companyby QuickBooks•Updated September 10, 2024
- Export reports, lists, and other data from QuickBooks Onlineby QuickBooks•55•Updated 7 days ago
- Spreadsheet Sync troubleshootingby QuickBooks•Updated May 28, 2024