✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-05
Automotive dealerships advertise vehicle pricing, lease specials, financing rates, and promotional offers. Offer schema structures pricing information with availability, payment terms, and seller details. Converting CSV pricing data to markup enables price display in rich results and shopping searches.
The Problem
Automotive pricing data in CSV format includes MSRP, sale prices, lease payments, financing rates, and promotional terms without Offer schema markup. Dealerships updating pricing for inventory changes, seasonal sales, and manufacturer incentives need structured data. Manual Offer schema creation for hundreds of vehicles is time-intensive when managing pricing across multiple models and promotional periods. Schema.org Offer Specification
How to Fix It
1
Upload Pricing Data CSV
Import offer information including prices, currencies, availability status, valid dates, and terms. System detects pricing structure automatically.
2
Map Price and Currency
Link price values to Offer properties. Currency codes (USD, EUR, GBP) populate priceCurrency. Sale prices and regular pricing are differentiated.
3
Configure Availability and Dates
Stock status maps to availability (InStock, OutOfStock, PreOrder). Valid from and valid through dates define promotional period duration.
4
Add Payment Terms
Lease payments, financing rates, and down payment requirements populate priceSpecification. Payment frequency and term lengths are included.
5
Export Offer JSON-LD
Download JSON-LD markup for vehicle and service pages. Schema includes seller Organization, accepted payment methods, and delivery options.
Frequently Asked Questions
How do I represent lease vs. purchase pricing?
Create separate Offer entries for lease and purchase options. Each offer has distinct price values, terms, and priceSpecification details. Link both offers to the same Vehicle using the offers property array.
Can I include manufacturer incentives in Offer schema?
Yes, use the priceSpecification property with UnitPriceSpecification for rebates and incentives. Include eligibility requirements and expiration dates in the description or using eligibleCustomerType.
How should trade-in allowances be represented?
Trade-in values are not directly supported in Offer schema. Mention trade-in programs in the description and show the net price after trade-in credit in the price field.
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.