Showing results for 
Search instead for 
Did you mean: 

Fix duplicate entries in your spreadsheets

QuickBooks Commerce is no longer available for purchase as a stand-alone product.
The features referred to in this article are only relevant for customers who still have QuickBooks Commerce bundled with their QuickBooks Online subscription.
If you want to learn more about e-commerce accounting features that are part of QuickBooks Online, check out Accounting for e-commerce FAQ.

Learn how to spot and fix duplicate records when working on spreadsheets.

Duplicate records can sometimes happen, especially when working with large amounts of data in spreadsheets. They can mess up your processes and workflows. Here’s how to check and fix duplicates when uploading spreadsheets to QuickBooks Commerce.

Note: Make sure there are no duplicate product names, variant names, SKUs, barcodes, or other identifiers before you upload your data.

Remove duplicate records in Google Sheets

Here’s how to remove duplicate entries in your Google Sheets.

Remove duplicate records in Microsoft Excel

Here’s how to remove duplicate entries in Microsoft Excel.

Both processes will select any duplicate records on your spreadsheet. You can now remove or change them accordingly.

Was this helpful?

You must sign in to vote, reply, or post

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up