The Ultimate Template for Structured Data Markup

Are you looking for an easy to use template to help you generate structured data for your website?
Check out our inhouse made (free) Google Spreadsheet, where you can easily create and edit the most common microformats which are currently supported by Google.

screen-shot-2016-11-25-at-11-52-17
The structured data types you can create in this template are:

1. Organization Schema

social-profiles01
Organization schema is the perfect opportunity to enhance the way your company is represented in Google’s search. Here is an example of Organization schema for Kaizen with searchbox:

<script type="application/ld+json">
 {
 "@context": "https://schema.org",
 "@type": "WebSite",
 "url": "https://https://www.kaizensearch.co.uk//",
 "potentialAction": {
 "@type": "SearchAction",
 "target": "https://query.https://www.kaizensearch.co.uk/search?q={search_term_string}",
 "query-input": "required name=search_term_string"
 }
 "publisher": {
 "@type": "Organization",
 "name": "Kaizen",
 "logo": {
 "@type": "ImageObject",
 "url": "https://www.kaizensearch.co.uk/wp-content/kaizen/img/kaizen-logo-amp.jpg",
 "width": 600,
 "height": 60
 }
 }
 </script>

2. Video Object Schema

videos01
Structured data markup for videos can make videos embedded on your site to appear in search results, which can be useful for “how to” or DIY videos.

Example:

<script type="application/ld+json">
 {
 "@context": "https://schema.org",
 "@type": "VideoObject",
 "name": "Title",
 "description": "Video description",
 "thumbnailUrl": "https://www.example.com/thumbnail.jpg",
 "uploadDate": "2015-02-05T08:00:00+08:00",
 "duration": "PT1M33S",
 "publisher": {
 "@type": "Organization",
 "name": "Example Publisher",
 "logo": {
 "@type": "ImageObject",
 "url": "https://example.com/logo.jpg",
 "width": 600,
 "height": 60
 }
 },
 "contentUrl": "https://www.example.com/video123.flv",
 "embedUrl": "https://www.example.com/videoplayer.swf?video=123",
 "interactionCount": "2347"
 }
 </script>

3. Article

articles01
Example for article structured data in microdata HTML format:

<div>
 <h2>Article headline</h2>
 <h3>By John Doe</h3>
 A most wonderful article
 <div>

<img src="https://google.com/thumbnail1.jpg" />

</div>
 <div>
 <div>

<img src="https://google.com/logo.jpg" />

</div>

</div>

</div>

4. Product Rating Schema

search-gallery-products

This markup lets you display product information, such as rating by your customers or its price directly in search results.

<script type="application/ld+json">
{
 "@context": "https://schema.org/",
 "@type": "Product",
 "name": "Executive Anvil",
 "image": "https://www.example.com/anvil_executive.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.",
 "mpn": "925872",
 "brand": {
 "@type": "Thing",
 "name": "ACME"
 },
 "aggregateRating": {
 "@type": "AggregateRating",
 "ratingValue": "4.4",
 "reviewCount": "89"
 },
 "offers": {
 "@type": "Offer",
 "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"
 }
 }
}
</script>

All of these structured data types can be generated in JSON and microdata (HTML).

How to use this template?

  1. Fill in your data in white cells within respective sheet
  2. Formulas will automatically generate appropriate schema in both JSON and Microdata formats (blue cell)
  3. Copy and paste one of the schemas (JSON or Microdata) and paste it as value only to the white cell with dotted frame
  4. Copy the schema from the FORMULA BAR of the red cell to the Google’s Structured Data Testing tool: https://developers.google.com/structured-data/testing-tool/

If your schema validates, you can now paste it to your source code.
You can access and download the template here.

Get a monthly roundup of our insights in your inbox

Comments

Related Blog Posts

Intern With Us

Want to work for a company that works in an office with a pool table, beers on a Friday and the occasional office dog? Of course you do. Kaizen is a Content Marketing agency that delivers award-winning, data-driven visual content campaigns for the UK’s leading brands. We are a vibrant, award-winning company who have recently … Read more

Starting Out on Social Media: Answering the Most Asked Questions about a Social Strategy

Social media has long been a huge topic of conversation, for brands, users, the media and businesses alike. Over the last ten years or so, it has become clear that channels like Facebook and Twitter have a huge potential to influence, whether it’s through political bias, improving (or ruining) brand sentiment, or trolling the least … Read more

How to Create Unique Content That Can’t be Ripped Off

How to Create Unique Content That Can’t be Ripped Off Imitation is the highest form of flattery, so they say. But when you’ve put time, effort and money into creating a piece of content, only to have someone produce their own version without giving you any credit, it doesn’t feel very flattering. Searching the web … Read more