Publish Google spreadsheets data on website

Hey.. do you want to publish the data from Google spreadsheet to on your web site. The below is the solution you have to follow step by step.

1. Open

2. Create a new spread sheet as below


3. Create data as below


4. Now, this sheet has to be published then it will be available for the public access. Click on the File > Publish to the web..


5. Publish the spreadsheet as below


6. It will generate the public link for the spread sheet as below. Please copy to the any notepad


For example the link as like below and take the red highlighted key and paste as shown below


For your reference and to help I am providing below that link[KEY]/od6/public/values?alt=json

7. Once you have ready the above link please open in browser, you can see the json return data as below


8. Copy the text showing on the browser and open the site : .

9. Paste on the text tab and click on the viewer , It will show JSON data clearly to us as shown below


10. Now we got the JSON data, this JSON data can be published on any website using below code.

<!DOCTYPE html>
<title>Google Spreadsheet test</title>
<script src=""></script>

var sheeturl = "";
$.getJSON(sheeturl, function (data) {
	var dt = data.feed.entry;
	var tbl = "<table border='0'>";
	$.each(dt, function (i) {
		tbl += "<tr>";
		tbl += "<td>" + dt[i].gsx$name.$t + "</td>";
		tbl += "<td>" + dt[i].gsx$phone.$t + "</td>";
		tbl += "<td>" + dt[i].gsx$email.$t + "</td>";
		tbl += "</tr>";
	tbl += "</table>";

	<div id="content">
		Display items here

11. Open the page in browser and check the result.

12. The page will be displayed as below.


All the best .. Please comment below.


Vijay Bhaskar from Hyderabad. Here in the IT industry for years and during these days I have enjoyed working with Microsoft Technologies such as Office 365, SharePoint 2013/2010, MOSS 2007, Asp.Net, C#.Net and Ajax, jQuery, JSON, ECMA, Angular etc. Currently working for Capgemini and Microsoft certified developer for SharePoint. During this period worked on various concepts like Office Apps, SharePoint Apps ( Provider hosted, SharePoint hosted), Azure, Workflows, Web part development, SSOM, CSOM, JSOM, SPServices, SharePoint Master Pages, SharePoint custom pages, SharePoint on Azure.

Leave a Reply

Your email address will not be published. Required fields are marked *