Study Learn Grow
JavaScript Project - Create CSV File From Google Spreadsheets

JavaScript Project - Create CSV File From Google Spreadsheets

You’ll learn how to develop dynamic and interactive web applications with just JavaScript – without using any libraries or shortcuts.

Overview

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.

Course Information

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

Get to grips with using JavaScript
Create elements dynamically

Beginners to JavaScript
Anyone who wants to practice writing JavaScript
Web developers
Anyone who wants to learn to make a JavaScript game without any libraries

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs