Blog
Library

JavaScript Project - Create CSV file from Google Spreadsheets

Features Includes:
  • Self-paced with Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App

Course Preview Video

Description

Explore how to create a clickable link to download a JavaScript-generated CSV file.

Do you want to create a download file option to enable your web visitors to download content from a Google spreadsheet? This course is just what you’re looking for. You’ll learn how to develop dynamic and interactive web applications with just JavaScript – without using any libraries or shortcuts.

This course covers the following:

  • Setting up a default data object
  • Generating a downloadable text file on the fly using JavaScript
  • Generating a downloadable CSV file on the fly
  • Selecting elements and style manipulation
  • Adding event listeners to elements
  • Using elements as objects in JavaScript
  • Applying the createObjectURL method to create file URLs
  • Cleaning and restructuring data objects for CSV
  • Adding and removing elements from a web page
  • Using regex to search and JavaScript to update strings
  • Using fetch to get Google spreadsheet JSON feed
  • Setting up Google spreadsheet as JSON output
  • Restructuring JSON to the array format for a CSV file

By the end of this course, you’ll be able to create a download file option to allow your web visitors to download a copy of the spreadsheet using a link generated with JavaScript. You can even build your own version of the application using the source code provided.

All the code files are available at https://github.com/PacktPublishing/JavaScript-CSV-File-Creator---Google-Sheets-to-CSV-Project

About the Author

  • Laurence Svekis is an instructor. He has 18+ years' work experience in web development, providing smart digital solutions online for both small and enterprise-level businesses. An experienced web application developer, he has worked on multiple enterprise-level applications, hundreds of websites and business solutions, and many unique and innovative web applications. His web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP, and MySQL—in short, anything to do with web creation and digital experience. He is passionate about everything to do with web application development and programming to online marketing with a strong focus on social media and SEO.

Basic knowledge
  • This course is for JavaScript beginners, web developers, HTML and CSS coders, and anyone curious about the Document Object Model and JavaScript methods

What will you learn
  • Get to grips with using JavaScript
  • Create elements dynamically
Course Curriculum
No of Lectures: 10 Total Duration: 00:50:14
Reviews

No Review Yet