JavaScript Project - Create CSV file from Google Spreadsheets

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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 fileBy 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 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

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Get to grips with using JavaScript
Create elements dynamically

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Export
  • Cleaning
  • Project
  • Web
  • Spreadsheet
  • Javascript
  • HTML
  • Javascript training

Course programme

Introduction to creating a mini application that generates Text and CSV files 1 lecture 02:28 Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files 1 lecture 02:28 Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. Introduction to creating a mini application that generates Text and CSV files: Introduction to development of application Google Sheet to CSV. JavaScript application to create files - Google Sheet data to CSV file 9 lectures 47:46 Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Create CSV File using code Learn HTML Course Section: Create CSV File using code Export Fixer and cleaning of structure of data. Learn HTML Course Section: Export Fixer and cleaning of structure of data Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates JavaScript application to create files - Google Sheet data to CSV file 9 lectures 47:46 Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Create CSV File using code Learn HTML Course Section: Create CSV File using code Export Fixer and cleaning of structure of data. Learn HTML Course Section: Export Fixer and cleaning of structure of data Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Learn HTML Course Section: Setup CSV Maker web application using HTML and JavaScript Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Learn HTML Course Section: Setup Data Values to use a placeholder content Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Learn HTML Course Section: Process CSV Data using JavaScript Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Learn HTML Course Section: Avoid Memory Leaks when creating a download file URL - JavaScript Create CSV File using code Learn HTML Course Section: Create CSV File using code Create CSV File using code Learn HTML Course Section: Create CSV File using code Create CSV File using code Learn HTML Course Section: Create CSV File using code Create CSV File using code Learn HTML Course Section: Create CSV File using code Learn HTML Course Section: Create CSV File using code Learn HTML Course Section: Create CSV File using code Export Fixer and cleaning of structure of data. Learn HTML Course Section: Export Fixer and cleaning of structure of data Export Fixer and cleaning of structure of data. Learn HTML Course Section: Export Fixer and cleaning of structure of data Export Fixer and cleaning of structure of data. Learn HTML Course Section: Export Fixer and cleaning of structure of data Export Fixer and cleaning of structure of data. Learn HTML Course Section: Export Fixer and cleaning of structure of data Learn HTML Course Section: Export Fixer and cleaning of structure of data Learn HTML Course Section: Export Fixer and cleaning of structure of data Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Learn HTML Course Section: Google Sheet Data to export to CSV file using JavaScript Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Learn HTML Course Section: Fetch Data from JSON data to use as application data Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates Learn HTML Course Section: Google Sheet to CSV final code tweaks and updates

Additional information

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

JavaScript Project - Create CSV file from Google Spreadsheets

£ 10 + VAT