ABCDE
1
Schema.org JSON-LD Bulk Editor and File Generator
2
{
"@context": "https://schema.org/",
"@type": "Product",
"name": "Executive Anvil",
"image": [
"https://example.com/photos/1x1/photo.jpg",
"https://example.com/photos/4x3/photo.jpg",
"https://example.com/photos/16x9/photo.jpg"
],
"description": "Sleeker than ACME's Classic Anvil, the Executive Anvil is perfect for the business traveler looking for something to drop from a height.",
"sku": "0446310786",
"mpn": "925872",
"brand": {
"@type": "Thing",
"name": "ACME"
},
"review": {
"@type": "Review",
"reviewRating": {
"@type": "Rating",
"ratingValue": "4",
"bestRating": "5"
},
"author": {
"@type": "Person",
"name": "Fred Benson"
}
},
"aggregateRating": {
"@type": "AggregateRating",
"ratingValue": "4.4",
"reviewCount": "89"
},
"offers": {
"@type": "Offer",
"url": "https://example.com/anvil",
"priceCurrency": "USD",
"price": "119.99",
"priceValidUntil": "2020-11-05",
"itemCondition": "https://schema.org/UsedCondition",
"availability": "https://schema.org/InStock",
"seller": {
"@type": "Organization",
"name": "Executive Objects"
}
}
}

This spread sheet and Google Apps Script will help you inspect and create JSON-LD for Schema.org.

Usage is simple:

1. Paste your JSON-LD "prototype" template into the cell to the left

2. In the JSON-LD Bulk Editor menu, click "Create schema editor"

3. Go to the Generator tab and fill in the values of your JSON-LD schema

4. In the JSON-LD Bulk Editor menu, click "Save JSON files to Drive"

5. Go to the URL provided in the pop-up to see your new JSON-LD files.

For more, see the Function Demos tab.

*Note: There is a known bug. Arrays of objects do not get recreated correctly. You'll see what I mean. And I'll get around to fixing it...


Find me on Twitter: @realtrevorfaux
Find me on LinkedIn: www.linkedin.com/in/trevormfox
3