Join Joseph Lowery for an in-depth discussion in this video Cross-platform CSV tools, part of Working with Data on the Web.
In this lesson, we'll take a look at the representative…selection of online cross-platform tools for working with your CSV files.…Many people use a commercial program like excel to do the bulk of their CSV work.…But it's important to understand that there are free or low cost alternatives.…Especially if you need to convert your data to other formats.…Speaking of excel, let me introduce you to a very dandy web based…Excel Viewer, which of course, can handle CSV file.…You'll find it at zoho.com and it's free to use.…
Let me demo with a CSV file found in the Chapter 2, 0203 folder…called RUSTOcsv. So, I'll choose File and then go to my web…browser where I have the Exercise files, chapter 2, 0203, there's…roux_stores.csv.…I'll click Open, and then View and there's our data.…As you can see, it's very similar to Excel.…This is great for those folks who are used to working in…that type of environment but don't have access on a local machine.…
You cannot only view the data, you can also make any necessary changes.…
Author
Joseph Lowery
Released
8/21/2013First, discover how data is collected via standard and advanced HTML5 forms. Then look at a client-friendly approach to storing that data using simple CSV files. Next, Joseph shows how to store, manage, and style data with the three big players: the granddaddy of static data, XML; the popular JavaScript-based JSON; and the recursively named YAML (YAML Ain't Markup Language), frequently used in Ruby-based projects. Plus, take a close look at basic HTML5 data options, including local storage and the flexible data attribute.
- Interacting with data through HTML forms
- Storing data as comma-separated values
- Saving, retrieving, and displaying data as XML
- Setting up and updating JSON data
- Creating a YAML data file
- Using HTML5 data storage solutions
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome53s
-
About the exercise files1m 9s
-
-
1. The State of Data on the Web
-
2. Handling Client-Friendly CSV
-
Parsing CSV files5m 6s
-
Cross-platform CSV tools4m 31s
-
3. Exploring XML
-
Understanding XML structure3m 26s
-
Saving data as XML10m 20s
-
Enhanced styling with XSLT8m 43s
-
-
4. Incorporating JSON
-
Setting up JSON data2m 55s
-
Interacting with JavaScript11m 10s
-
Updating your JSON data6m 1s
-
-
5. Investigating YAML
-
Understanding YAML2m 54s
-
Creating a YAML data file6m 21s
-
Parsing YAML with JavaScript10m 8s
-
Working with YAML tools4m 4s
-
-
6. Applying HTML5 Solutions
-
What's available in HTML53m 58s
-
Utilizing local storage8m 23s
-
-
Conclusion
-
Next steps15s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Cross-platform CSV tools