Skip to content

Finding and Removing Duplicate Values in Excel Data

Data Import Updated 13 February 2026 1 min read

Some fields in Recycly such as "Model Number" do not allow duplicate values, and you may get a warning such as the below:

Before importing your data, you can use Excel's "Duplicate Values" column highlighting to remove the duplicate values.

1. Load your data into Excel, and highlight the column you wish to check for duplicate values

2. on the "Home" tab in excel, press the Conditional Formatting button and select Highlight Cells, then Duplicate Values.

3. Press OK on the pop-up that appears

Now any duplicate values in the column can be easily seen and removed

More in Data Import

Data Import FAQ (Frequently Asked Questions)

Q: What format do I need my data to be in order to import it into Recycly?Recycly accepts data in Excel or CSV files.The easiest way to import is to start from...
Guide to Importing Asset Items & Lots

Recycly is very flexible when it comes to data imports, but it can make it challenging when doing your first ones to get everything right.Matching up Asset...
Guide to Importing Individual Hard Drives

For ITADs that do hard drive erasure or shredding en-masse onsite, it is useful to be able to import a list of shredded hard drives into Recycly.The easiest...
Sending data files to us, so we can quote you for import

If you'd like to raise a request for us to quote for importing your data. Please email support@recyc.ly the following details:A general explanation of the data...
Updating Existing Data using a Data Import

You can easily update existing records in Recycly by using the “I want to update data” option on the export screen on any Recycly list. This allows you to...