Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
B
BarefootPR
July 21, 2021
Question

QBO exporting/importing

  • July 21, 2021
  • 1 reply
  • 1 view

I am trying to export my QBO accounting files so I can import them to my QBO payroll account since QBO cannot merge the accounts. After QBO said the file was zipped, I now just have a white box on my screen that says downloading - how long should it take? It has been on my screen for 15 minutes.

1 reply

AlexV
AlexV
Level 10
July 21, 2021

Good day, BarefootPR1

 

Thanks for posting here. Allow me to help you in importing your data.

 

You can import data into QuickBooks Online (QBO) but it doesn't support zipped files. You'll want to unzip them first and upload the individual files. From your File Explorer, select the zipped file and right-click. Then, select Extract All.

 

These are the supported file format when importing data in QBO:

  • CSV (Comma Separated Values)
  • Google Sheets
  • XLS/XLSX

 

Also, importing a file only takes a couple of minutes depending on the file size. Make sure that you're using a supported and updated browser. If this behavior continues, you'll want to import the file through an incognito window. These are the keyboard shortcut:

  • Google Chrome: Ctrl + Shift + N
  • Safari 11 or newer: ⌘ + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Microsoft Edge: Ctrl + Shift + P

 

If the same thing happens, consider clearing the browser's cache.

 

Additionally, here are some of the articles you can check. These will show you more info on how to import data QuickBooks Online:

 

Keep on posting here if you have additional questions. Take care!

B
BarefootPRAuthor
July 21, 2021

Thanks Alex - I was actually wondering about the export function. It seems to be taking an exceptionally long time to download the data. I'm wondering if it just takes multiple hours or if maybe I need to try a different browser instead of using the app.

 

Thanks,

Cori

JasroV
JasroV
Level 8
July 21, 2021

I appreciate your prompt reply for sharing additional details, Cori.

 

Allow me to chime in and impart some insights about exporting QuickBooks Online (QBO) data. 

 

Exporting QBO data doesn't take too much time. However, it'll also depend on your company file size. To ensure a smooth process, you'll want to log in to your account through a regular web browser and export your file from there. Let me show you how.

 

  1. Go to the Gear icon.
  2. Select Export Data.
  3. From the Reports tab, set the date range.
  4. Add or remove items from the Reports and Lists tabs by toggling the slider. 
  5. Then select Export to Excel.

 

You can also check this article for more details: Export Data out of QuickBooks Online

 

Once done, you can now import your data whenever you're ready.

 

In case you have other follow-up questions about exporting and importing file in QBO, you can always tag me in your reply. I'll be more than happy to work with you again. Have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement