CSV File Converter

This CSV File Converting tool takes a CSV (spreadsheet saved as .csv) file and converts the data into and HTML Table, XML schema, JSON object, or extjs format for the SimpleStore object.

Why might you want to do such a strange thing? Mostly because it's cool. If you're a programmer, you might also find it rather handy to quickly generate static data for testing and prototyping. You might even think it useful to create extjs combo boxes and grids with static data.

You can download the source code, browse the SVN repository or check it out using this command: svn co https://zentrack.svn.sourceforge.net/svnroot/zentrack/devtools/convertcsv/.

Which is nice, since this tool isn't limited to the formats above. It's very easy and, dare I say, fun to create new templates--most of them average about fifty lines of code.

Want to give it a try? Download this spreadsheet, and then try it below using Node Depth of 3. See what you get :)

CSV File Converter

CSV File to Convert The first line of the file is expected to contain the keys (column names)
Any line beginnigng with ## in first column is skipped.
Blank lines are also skipped.
Column heading can have same name or no name
To create arrays instead of keyed objects (json only), leave the column headings blank. Output Format

Node Depth: This determines the levels of hierarchy (how many cols are used as keys)
The columns must be ordered according to the tree structure.
For example, if depth=2, then col 1 is the first level, and col 2 the second, and col 3+ is the data
A 0 here means everything is contained at the root node.
Extjs store ignores this setting. Compress JSON: When checked, json/extjs output is minimized to conserve bytes. Use XML Attributes: When checked, xml nodes are named by col heading with attribute containing value (instead of value as node name). Verbose CSS tags: When checked, html output will contain css styling tags where possible.