Remove Duplicates from Software Asset and License Data
✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-12
IT departments track software assets across procurement systems, license management platforms, endpoint detection tools, and vendor portals. The same application appears under different records when purchased through multiple channels, when different versions are tracked as separate products, or when license renewals create new entries without retiring old ones. Microsoft 365 might be listed as 'Office 365 E3', 'Microsoft 365 E3', and 'M365 Business Premium' across three systems. dataclean.to matches software records by product name, vendor, version, and license key patterns to identify and consolidate duplicate entries.
The Problem
Duplicate software records lead to direct financial waste and compliance risk. Organizations with duplicate license entries believe they own more licenses than they actually do, leading to under-purchasing that creates compliance exposure during vendor audits. Conversely, duplicate records that inflate license counts may cause over-purchasing when IT buys additional seats that already exist under a different record. Endpoint management tools showing the same application installed under two product names cannot accurately report deployment coverage. Vendor audit responses prepared from databases with duplicates either overstate or understate license positions, both of which are costly outcomes. ISO/IEC 19770 IT asset management standard
How to Fix It
1
Export software asset records
Pull software data from your ITSM platform, license management tool, procurement system, and endpoint detection tool into CSV format. Include product name, vendor, version, license type, license key, quantity, renewal date, and deployment count.
2
Upload to dataclean.to
Upload the combined CSV. The tool compares product names, vendors, and version numbers to identify software assets tracked as multiple records across your IT management systems.
3
Review duplicate software clusters
Examine flagged groups. Common duplicates include the same product listed under old and new branding names, different versions tracked as separate products rather than updates, and license renewals entered as new purchases alongside the original record.
4
Consolidate into accurate license records
Merge confirmed duplicates into single software asset entries. Retain the current version, the total license quantity from all sources, the most recent renewal date, and all associated license keys.
5
Export the clean software inventory
Download the deduplicated data for import into your ITSM or license management platform. Accurate software records prevent audit penalties, eliminate wasted license spend, and provide a true picture of deployment coverage.
Frequently Asked Questions
How does the tool handle software that was rebranded by the vendor?
Vendor rebranding is a major source of software duplicates. When 'Office 365' became 'Microsoft 365', many organizations ended up with both names in their inventory. The tool flags entries sharing a vendor and similar product name for consolidation.
Can it distinguish between different editions of the same software?
Different editions like 'Professional' and 'Enterprise' are treated as distinct products since they have different license terms and pricing. The tool only flags entries as duplicates when the edition, vendor, and product name all match.
What about software deployed on both on-premises and cloud?
The same product deployed on-premises and as a cloud service may have separate license agreements. The tool flags them based on product name matching so you can decide whether to track them as one asset or maintain separate records for different deployment types.
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.