✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-12
eBay Motors is one of the largest online vehicle marketplaces, but its listing data is notoriously inconsistent. Sellers enter make, model, year, and mileage in different formats, abbreviate trim levels, and embed key details in free-text descriptions. dataclean.to cleans eBay Motors exports and maps the data to schema.org Vehicle properties, producing JSON-LD markup that enables vehicle-specific rich results.
The Problem
eBay Motors data contains abbreviated makes ('Chevy' vs 'Chevrolet'), model names mixed with trim levels ('Camry LE 4dr'), mileage in various units ('45k mi', '45,000 miles'), and VIN numbers that may be partial or formatted incorrectly. Condition descriptions range from coded values to free text. This inconsistency prevents direct mapping to structured Vehicle schema. schema.org Vehicle type
How to Fix It
1
Export eBay Motors listings
Download your eBay Motors vehicle listing data as a CSV. Include title, item specifics (make, model, year, mileage, VIN), price, condition, and description fields.
2
Upload to dataclean.to
Import the eBay Motors CSV. The platform identifies automotive-specific fields and flags issues like abbreviated makes, mixed mileage formats, and incomplete VINs.
3
Normalize vehicle attributes
Standardize make names to full manufacturer names, separate model from trim level, convert mileage to consistent numeric values, and validate VIN format where present.
4
Map to Vehicle schema properties
Assign cleaned columns to schema.org Vehicle properties: vehicleIdentificationNumber, manufacturer, model, vehicleModelDate, mileageFromOdometer, offers, and vehicleConfiguration.
5
Export Vehicle schema JSON-LD
Download validated JSON-LD for each vehicle listing. Embed on your automotive listing pages to enable Google vehicle rich results with price, mileage, and condition.
Frequently Asked Questions
How does dataclean.to handle abbreviated car makes?
The platform maps common abbreviations to full manufacturer names: 'Chevy' to 'Chevrolet', 'VW' to 'Volkswagen', 'Merc' to 'Mercedes-Benz', and similar patterns found in eBay Motors data.
Can mileage from eBay be used in Vehicle schema?
Yes. The mileageFromOdometer property uses a QuantitativeValue with unitCode. dataclean.to normalizes values like '45k mi' or '45,000 miles' into the proper numeric value with 'SMI' (statute miles) as the unit.
Is VIN validation included?
dataclean.to checks VIN format (17 alphanumeric characters excluding I, O, Q) and flags entries that are too short, contain invalid characters, or appear to be partial. It does not verify VINs against a vehicle database.
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.