A JavaScript Project to Create a CSV File from Google Spreadsheets [Video]
-
Free ChapterIntroduction to creating a mini application that generates Text and CSV files
-
avaScript application to create files - Google Sheet data to CSV file
- Setup CSV Maker web application using HTML and JavaScript
- Setup Data Values to use a placeholder content
- Process CSV Data using JavaScript
- Avoid Memory Leaks when creating a download file URL - JavaScript
- Create CSV File using code
- Export Fixer and cleaning of structure of data.
- Google Sheet Data to export to CSV file using JavaScript
- Fetch Data from JSON data to use as application data
- Google Sheet to CSV final code tweaks and updates
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 to make a 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 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 version of the game today!
All the code files are placed at https://github.com/PacktPublishing/JavaScript-CSV-File-Creator---Google-Sheets-to-CSV-Project
- Publication date:
- April 2019
- Publisher
- Packt
- Duration
- 0 hours 50 minutes
- ISBN
- 9781838825348