Skip to main content

Convert Google Spreadsheet into database - Free MySQL Database from Google Sheets - Papa Parse

Convert Google Spreadsheet into database - Free MySQL Database from Google Sheets - Papa Parse

papaparse - Convert Google Spreadsheet into database


This is a new method after tabletop.js :- https://github.com/jsoma/tabletop easy way to get your spreadsheet into a json format.

Tabletop was created in about 1995, back when we had to remember to disable call waiting when dialing into CompuServe. Now that it's 2020, Google is shutting down the infrastructure that Tabletop relies on.

Big surprise, right? But luckily, it's pretty easy to switch to a more modern way of doing things!

Instead of Tabletop, we're going to use Papa Parse. You still need to share your spreadsheet and all of that (see below), but the changes are actually pretty tiny! 


Firstly You have to import Papa Parse CDN :-


  
    <script src="https://cdnjs.cloudflare.com/ajax/libs/PapaParse/5.3.1/papaparse.min.js"></script>
  


Then Use it as JavaScript

  
// getcsv() function
  function getcsv(url) {  Papa.parse(url, {
          download: true,
          header: true,
          complete: function(results) {
            var data = results.data
            console.log(data);
            return data;
          }
        })}
//Calling getcsv(URL with ?output=csv in last) function will return us the json file of spreadsheet           
getcsv('https://docs.google.com/spreadsheets/d/1Ns40B5LSo3CgDnG1YrH6iBmn89IOscGFpRVfmutL4kg/pub?output=csv');
  


Note :- The Spreadsheet URL must Last with /pub?output=csv like this as shown in example https://docs.google.com/spreadsheets/d/1Ns40B5LSo3CgDnG1YrH6iBmn89IOscGFpRVfmutL4kg/pub?output=csv 


Here is the Result :- 

Our Spreadsheet

Output on Console



Now, You can Use JavaScript loops to print /show your json file/data on Website/Webpage.

Example Using For Loop.

  
//After storing getcsv('url') value in json variable
  for(var i = 0; i < json.length; i++) {
    var obj = json[i];
    console.log(obj.Message);
    document.write(obj.Message+"<br>");
 }
  



Some Applications Example :-

  • URL Shortener Website (Static/on Blogger) 
  • HTML5 Gaming Website
  • Simple Chat App (Static/on Blogger)
  • More may come sooner...


Some Example Apps :-

Comments

Random Posts