Video: Cross-platform CSV tools

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.

Often, designers need to convey simple data without the overhead of a relational database such as MySQL. This course introduces web technologies that make it easy for a designer or developer to store, retrieve, and display data online.

First, 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.

Cross-platform CSV tools

In this lesson, we'll take a look at the representativeselection 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 basedExcel 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 foldercalled RUSTOcsv. So, I'll choose File and then go to my webbrowser where I have the Exercise files, chapter 2, 0203, there'sroux_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 inthat 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.And once you're done, you can save it to your online account at zoho.com,which range from free to $5 per month.Or you can export it to a wide range of formats.That's a pretty button down site and I say that with total respect.So, let's take a look at something a little bit more out there.Csvsick.com works with CSV files from a more structural pointof view, as opposed to a data point of view.So, let's upload our CSVfile to see how it works. I'll choose File, pick ROOstores.csvagain click Open and Upload.

Now, there are a great number of options for filtering and outputtingthe file on top of the Data view that you see here.In the data area itself you can modify the headers but the data is locked.However, one reallycool feature is the ability to drag your columnsinto a new position or add an entirely new column.So, if I wanted to switch the position forsculpture and oils, I can very easily do that.Or change the name of UU ID to just Store ID.

Also pretty easy to do. You cannot, however, add new data.Once you've modified your data structure,you can either download it or preview it in a CSV format.Now, there's one more site that I want to show you, and that's textfixer.comwhich has a terrific tool for converting CSV text files to an HTML table.Something that I've had to do way more times than I want to think about.Now, rather than uploading the file, Text Fixer works by pasting in your CSV code.

So, let's head over to our code editor, and I'm going to open up anotherCSV file. Also from 02_03 so again I'm going tochoose ROOstores.csv, open that and there it is in a raw csv format.So, I'll Select All > Copy it and now lets head back to Text Fixer.Scroll down a little bit here, and I'll paste it in.Now,as you can see I'm using commas and quotationmarks here so I'll choose that as the separator.

And once that's done, click make HTML table code and there we have it.So, let me copy this code and now let'shead back to the code editor one more time.I have, in the file 02_03, csv2table.htm, which is just a blank HTML document,and I can paste in my code. Let's save it.Now, let's take a look at the codein my code editor's default browser.

And there's a standard table filled with the CSV data, ready and able to go online.There are quite literally tons of CSV-relatedtools like these online and many that arededicated to converting your CSV data to a specific format, like XML, JSON or others.Just do a quick search on CSV online converter andhave at it.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Already a member ?

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships.
Learn more

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about lynda.com and our online training library:

new course releases

newsletter

general communications

special notices

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

new course releases

newsletter

general communications

special notices

Here’s our privacy policy with more details about how we handle your information.