✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-05
B2B review statistics convert into Schema.org AggregateRating markup for product and service ratings. Structured rating data helps search engines display star ratings in search results. This process transforms spreadsheet data containing review statistics into valid JSON-LD that meets schema requirements.
The Problem
B2B companies track review statistics across platforms with inconsistent aggregation methods. Average ratings, review counts, and rating distributions vary in calculation and format. Manual schema creation for aggregate ratings requires statistical validation and proper nesting within parent entities. Automated conversion ensures consistent structured data while maintaining relationships to rated products, services, or organizations that follow schema specifications for rating display. Schema.org AggregateRating Specification
How to Fix It
1
Upload Rating Data
Import CSV or Excel files containing aggregate rating statistics including average rating, total ratings, review count, and rating scale. System identifies rating-specific fields.
2
Map Rating Properties
Match columns to AggregateRating properties like ratingValue, ratingCount, reviewCount, bestRating, worstRating, and link to rated item.
3
Validate Rating Statistics
System checks rating values are within scale bounds, validates count fields are integers, ensures rating average calculations, and verifies rated item references.
4
Generate Rating Schema
Create JSON-LD for each aggregate rating with proper nesting within Product, Service, Organization, or other rated entity types.
5
Export Schema Files
Download aggregate rating schemas embedded in parent entity JSON-LD, ready for implementation with validated structure.
Frequently Asked Questions
What rating properties are required?
Required properties include ratingValue and ratingCount. Recommended additions are bestRating (typically 5), worstRating (typically 1), and reviewCount for complete statistics.
How is ratingCount different from reviewCount?
ratingCount is total number of ratings submitted. reviewCount is number of written reviews. Users may rate without writing reviews, so ratingCount often exceeds reviewCount.
Can I include rating distribution?
Schema.org doesn't have standard property for distribution. Use individual Review entities with ratings, or add custom property for distribution histogram data.
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.