✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-13
Content publishers managing article databases in spreadsheets can significantly improve their search visibility by adding Article schema markup. Whether you publish news, blog posts, tutorials, or long-form content, Google uses Article structured data to better understand authorship, publish dates, and content relationships. dataclean.to converts your CSV article database into validated Article (or NewsArticle, BlogPosting) schema JSON-LD, handling the data cleaning that makes the difference between valid and rejected markup.
The Problem
Article metadata in spreadsheets tends to accumulate inconsistencies over time. Publish dates use different formats depending on who entered them — "2026-01-15", "Jan 15, 2026", "1/15/26", "15-01-2026." Author names appear as "John Smith", "J. Smith", "Smith, John", or just "john." Category fields mix hierarchy levels: one row says "Technology" while another says "Tech > AI > Machine Learning." Headline fields contain trailing whitespace, inconsistent capitalization, or HTML entities from CMS exports. These inconsistencies produce Article schema that either fails validation or sends conflicting signals to search engines about your content. Article schema type specification
How to Fix It
1
Export your article database to CSV
Export your content database, CMS article list, or editorial spreadsheet as CSV. Include columns for title, publish date, author, description or excerpt, URL, image, category, and any other metadata fields you maintain.
2
Import and detect content metadata types
Upload the CSV to dataclean.to. The platform identifies date columns, URL fields, author names, and text content. It flags date formatting inconsistencies, broken URLs, and encoding issues in titles and descriptions.
3
Normalize article metadata
Clean all fields to meet Article schema requirements. Publish and modification dates convert to ISO 8601. Author names standardize to consistent formatting. URLs are validated. Titles and descriptions are trimmed, decoded from HTML entities, and checked for appropriate length.
4
Map columns to Article schema properties
Select Article, NewsArticle, or BlogPosting as the schema type and map your columns: headline, datePublished, dateModified, author (as Person), publisher (as Organization), description, image, articleSection, and mainEntityOfPage.
5
Generate and deploy Article JSON-LD
Export JSON-LD markup for each article. Each record produces a complete Article schema object with proper nesting of Person (author) and Organization (publisher) types. Deploy via hosted API for automatic page-level markup or download for manual integration.
Frequently Asked Questions
Should I use Article, NewsArticle, or BlogPosting schema?
Use NewsArticle for timely news content from a recognized news source. Use BlogPosting for blog-style content with opinions, tutorials, or personal writing. Use Article as a general-purpose type for other long-form content. All three share the same core properties, so the data cleaning process is identical.
Does Article schema help my content rank higher?
Article schema doesn't directly boost rankings, but it helps Google understand your content's metadata (authorship, publish dates, topic) and makes your pages eligible for rich results like Top Stories, article carousels, and enhanced search listings. These enhanced presentations can improve click-through rates.
How should I handle articles with multiple authors?
If your CSV has multiple author names in a single column (separated by commas or semicolons), dataclean.to can split them into an array of Person objects for the author property. Each author becomes a separate Person entry in the JSON-LD output with their own name property.
Example: Input → Output
title
author
date
category
url
10 Tips for Better Data
Jane Smith
2026-03-01
Technology
https://example.com/tips
10 tips for better data
jane smith
March 1 2026
technology
https://example.com/tips
Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.