JavaScript Project – Create CSV file from Google Spreadsheets

JavaScript Project – Create CSV file from Google Spreadsheets

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 0h 50m | 222 MB

Explore how you can use JavaScript to create a clickable link to download a JavaScript generated CSV file

Did you want to create a download file option for your web visitors – downloading content from data and even a Google Spreadsheet?

No libraries, no shortcuts just learning JavaScript making it DYNAMIC and INTERACTIVE Web Application. All are done with JavaScript.

Course Covers

  • Setting up a default data object
  • Generating a downloadable text file on the fly using JavaScript
  • Generating a downloadable CSV file on the fly
  • Element select and style manipulation
  • Adding event listeners to elements
  • Elements as objects in JavaScript
  • createObjectURL method to create file URLs
  • Cleaning and restructuring of data objects for CSV
  • Adding elements and removing elements from the web page
  • Use of regex to search and JavaScript to update strings
  • Use of fetch to get Google Spreadsheet JSON feed
  • Setup of Google Spreadsheet JSON
  • Restructuring JSON to array format for CSV file
  • Source Code is included so you can try the code and build your own version of the application.

Allow web visitors to download a current copy of the spreadsheet from a link – all front-end and done dynamically with JavaScript. Start building your own version of the game today!!!!

This course is designed to get you started quickly with step-by-step training. The source code is included so you can try it for yourself.

What You Will Learn

  • How to use JavaScript
  • How to create elements dynamically
Table of Contents

Introduction to creating a mini application that generates Text and CSV files
1 Introduction to development of application Google Sheet to CSV.

JavaScript application to create files – Google Sheet data to CSV file
2 Setup CSV Maker web application using HTML and JavaScript
3 Setup Data Values to use a placeholder content
4 Process CSV Data using JavaScript
5 Avoid Memory Leaks when creating a download file URL – JavaScript
6 Create CSV File using code
7 Export Fixer and cleaning of structure of data.
8 Google Sheet Data to export to CSV file using JavaScript
9 Fetch Data from JSON data to use as application data
10 Google Sheet to CSV final code tweaks and updates