Remove Duplicates from Art Gallery and Collection Data
✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-12
Art gallery databases accumulate duplicates when the same artwork is cataloged during acquisitions, exhibitions, loans, and insurance assessments, each process creating its own record. A painting might appear as 'Untitled (Blue Series) #4', 'Untitled No. 4 from Blue Series', and 'Blue Series IV' in different parts of the gallery's collection management system. dataclean.to matches artwork records by normalizing titles, comparing artist names and dates, and clustering entries with shared medium, dimensions, and provenance details to produce a clean catalog of the collection.
The Problem
Duplicate artwork records create serious provenance and valuation problems. When the same piece has multiple catalog entries, its exhibition history is fragmented, making it impossible to compile an accurate provenance record for potential buyers or insurers. Insurance appraisals that double-count works overstate the collection's insured value, inflating premiums unnecessarily. Loan tracking systems with duplicate entries may show the same work as both in-house and on loan, creating confusion about the physical location of valuable pieces. Exhibition planning that references an inflated catalog may allocate wall space for works that do not actually exist as separate pieces. Getty Research Institute vocabularies for art cataloging
How to Fix It
1
Export your collection database
Pull all artwork records from your collection management system. Include title, artist name, date, medium, dimensions, accession number, provenance, exhibition history, current location, and insurance value.
2
Upload to dataclean.to
Upload the CSV. The tool normalizes artwork titles by handling numbering variations and series designations, matches artist names, and compares physical attributes like medium and dimensions to identify duplicate entries.
3
Review duplicate artwork clusters
Examine groups of records flagged as the same work. The tool shows title variations, matching artist and dimensions, and different accession numbers or provenance entries that may belong together.
4
Merge into authoritative catalog entries
Consolidate confirmed duplicates into one record per artwork. Combine exhibition histories and provenance information from all duplicate entries into a complete chronological record. Retain the most current insurance valuation.
5
Export the clean collection catalog
Download the deduplicated CSV and update your collection management system. Each artwork now has one catalog entry with complete provenance, accurate exhibition history, and a single current valuation.
Frequently Asked Questions
How does the tool handle works from an edition or series?
Works within an edition, such as prints numbered 1/50, 2/50, are treated as distinct artworks because each is a separate physical object. The tool only flags entries as duplicates when the edition number matches or when unnumbered works share identical dimensions, medium, and artist.
Can it identify artists listed under different name variations?
Yes. The tool normalizes artist names by handling Western and non-Western name orders, initials versus full names, and common romanization differences. 'Picasso, Pablo' and 'Pablo Picasso' are recognized as the same artist.
What about works that were reframed or restored, changing their dimensions?
Works with the same title and artist but different dimensions are flagged for review with the dimensional difference highlighted. You can determine whether the change reflects a reframing or conservation treatment that should be noted in the merged record.
Example: Input → Output
name
email
phone
city
status
Alice Johnson
alice@example.com
+1-555-0101
New York
active
alice johnson
ALICE@EXAMPLE.COM
5550101
new york
Active
Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.