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://wp2.kaizen.co.uk//",
 "potentialAction": {
 "@type": "SearchAction",
 "target": "https://query.https://wp2.kaizen.co.uk/search?q={search_term_string}",
 "query-input": "required name=search_term_string"
 }
 "publisher": {
 "@type": "Organization",
 "name": "Kaizen",
 "logo": {
 "@type": "ImageObject",
 "url": "https://wp2.kaizen.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.

poly background

Get a monthly roundup of our insights in your inbox

Comments

Latest Blog Posts

What Digital Channels Will Work For My Business?

An emarketer report forecast that UK ad spend would surpass £19.5bn in 2019.  Even with Brexit uncertainty, it looks likely to exceed that milestone by the end of the year, with over 66% of that to be in digital media. This reflects the scale in which advertisers are investing in digital channels to promote their […]

BrightonSEO 2019 – Insights and Takeaways

On a sunny Friday morning in Brighton, 4,000 SEO and digital marketing enthusiasts gathered to celebrate and learn about the intricacies of SEO. The bi-annual conference, which initially began in a room above a pub, aims to connect digital marketers from across the globe and inspire new thinking in SEO through a range of inspiring […]

Google’s Changing the Game For Digital PR

The 10th September marked good news for those in the combined world of SEO and Digital PR. Google released a news update about upcoming changes to the way that they will be identifying the nature of links, for crawling, indexing and ranking across the web.  These are the new changes being put forward to differentiate […]