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

Popular posts from this blog

Top Free APIs Every Developer Should Know About

Top Free APIs Every Developer Should Know About In the world of software development, APIs (Application Programming Interfaces) are essential for integrating various functionalities into applications. Here’s a curated list of top free APIs categorized by their functionality: 1. Weather APIs OpenWeatherMap API : Provides current weather data, forecasts, and historical weather data for any location. Weatherstack API : Offers real-time weather information, including forecasts and historical data. 2. Maps and Geolocation APIs Google Maps API : Enables integration of interactive maps, geocoding, and route optimization. Mapbox API : Provides customizable maps, navigation, and location search capabilities. 3. Finance and Stock Market APIs Alpha Vantage API : Offers real-time and historical equity and cryptocurrency data. Yahoo Finance API : Provides access to financial news, stock market data, and por...

Google Drive Proxy Video Player - Bypass Limits - JW Player - Embed drive videos

GooDrive :- https://goodrive.stream/ Google Drive Proxy Player #1 :- https://youtu.be/9VQK8W2iUkg Dev.to Article

Plyr.io Video Player - Integration - Skin Customizing - Adding Download Button

Plyr.io Video Player - Integration - Skin Customizing - Adding Download Button See the Pen Plyr.io Video Player - Skin Customizing to pink by SH20RAJ ( @SH20RAJ ) on CodePen . Integration :-  or Get Plyr CDNS From CDNJS Plyr <!-- Docs styles --> <link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/CDNSFree2/Plyr/plyr.css" /> or Use CDNJS for CDN <link rel="stylesheet" href=" https://cdnjs.cloudflare.com/ajax/libs/plyr/3.6.7/plyr.min.css" /> <!--Add a Simple HTML5 Video tag--> <video controls data-poster="https://cdn.plyr.io/static/demo/View_From_A_Blue_Moon_Trailer-HD.jpg" class="vid1"> <!-- Video files --> <source src="https://rebrand.ly/sample-video" type="video/mp4" size="576" /> </video> <script src="https://cdnjs.cloudflare.com/ajax/libs/plyr/3.6.7/plyr.min.js"...

Random Posts