Skip to main content

1 reply

January 17, 2021

Hey there, @usersophieparisrd.

 

Thanks for sharing your concern here in QuickBooks Community. 

 

Can you share with me the type of item list you're trying to import in QuickBooks Online (QBO)? This can affect the amount of data that you'll be entering into your Excel file.

 

For now, you can only import spreadsheets with less than 1,000 rows into QBO. If your file is greater than that, you can split them into smaller files and import them separately. 

 

To make sure your data imports correctly, follow this order:

 

  1. Customer
  2. Suppliers
  3. Products and services
  4. Invoices
  5. Bills

 

For more details, you can check out this article: Common questions about importing data to QuickBooks.

 

In addition, you can look for a third-party application that can help you in importing large data into QuickBooks. Just go to the Apps menu and search for the app.
 

The Community always has your back, so please let me know if you have any other questions. I'll be more than happy to help. Keep safe.