✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-05
Review data converts into Schema.org Review markup for customer feedback. Structured information helps search engines understand ratings, authors, and reviewed items. This process transforms spreadsheet data containing review details into valid JSON-LD that meets schema requirements.
The Problem
B2B companies maintain review data across feedback platforms, CRM systems, and testimonial databases with inconsistent formatting. Star ratings, review text, author information, and review dates vary in structure. Manual schema creation for hundreds of reviews takes excessive time. Automated conversion ensures consistent structured data while maintaining relationships to products, services, or organizations being reviewed that follow schema specifications. Schema.org Review Specification
How to Fix It
1
Upload Review Data
Import CSV or Excel files containing review information including rating, review text, author name, date, and reviewed item. System identifies review-specific columns.
2
Map Review Properties
Match spreadsheet columns to Schema.org Review properties like reviewRating (Rating), reviewBody, author (Person or Organization), datePublished, and itemReviewed.
3
Normalize Review Data
Standardize ratings to numeric scale with bestRating and worstRating, validate dates in ISO 8601 format, structure authors as Person type with name.
4
Generate Review Schema
Create JSON-LD structured data for each review with proper nesting of rating, author details, and references to reviewed Product, Service, or Organization.
5
Export Schema Files
Download individual JSON-LD files or bulk export all review schemas with validated structure ready for website implementation.
Frequently Asked Questions
What review properties are required?
Required properties include reviewRating with ratingValue, and either reviewBody or name. Recommended additions are author, datePublished, and itemReviewed reference to product or service.
How do I format rating values?
Use Rating type with ratingValue (numeric), bestRating (typically 5), and optionally worstRating (typically 1). Specify scale clearly for non-standard rating systems.
Can I aggregate multiple reviews?
Yes, use AggregateRating type with ratingValue average, ratingCount total reviews, and reviewCount. Attach to Product, Service, or Organization being reviewed.
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.