grunt-csv-to-json

Generate static JSON from CSV key/value data.

Getting Started

This plugin requires Grunt ~0.4.0

If you haven't used Grunt before, be sure to check out the Getting Started guide, as it explains how to create a Gruntfile as well as install and use Grunt plugins. Once you're familiar with that process, you may install this plugin with this command:

npm install grunt-csv-to-json --save-dev

Once the plugin has been installed, it may be enabled inside your Gruntfile with this line of JavaScript:

grunt.loadNpmTasks('grunt-csv-to-json');

The "csvjson" task

Overview

This task builds JSON structures from key/value data defined in CSV format. Multiple JSON resources can be defined per CSV document.

The following CSV document:

| key | bob | sue | | ---- | ----- | ------ | | name | Bob | Sue | | sex | male | female | | age | 54 | 24 |

Will generate two JSON resources:

// dest/bob.json
{
	"name": "Bob",
	"sex": "male",
	"age": 54
}

// dest/sue.json
{
	"name": "Sue",
	"sex": "female",
	"age": 24
}

In your project's Gruntfile, add a section named csvjson to the data object passed into grunt.initConfig().

grunt.initConfig({
	csvjson: {
		test: {
			src: 'test/src/*.csv',
			dest: 'test/dest'
		}
	},
});

Options

options.parserOptions

Type: Object

CSV parser options: see node-csv-parse#parser-options.

options.parserOptions = {
	auto_parse : true
};

options.processValue

Type: Function

Hook to process field value.

options.processValue = function (key, value) {
	return value;
};

CSV format

The expected format is one row per value, with resource names defined in the first row, and field keys in the first column.

| key | resource-a | | ------- | ---------- | | key-one | value-one | | key-two | value-two |

Object hierarchy

Object hierarchy is expressed with dot notation in the key.

The following data:

| key | bob | | ----------- | ----- | | person.name | Bob | | person.sex | male | | person.age | 54 |

Will generate:

{
	"person": {
		"name": "Bob",
		"sex": "male",
		"age": 54
	}
}

Implicit array syntax

Arrays of values can be implicitly defined by duplicating keys.

The following data:

| key | list | | ------------- | ------- | | shopping.day | Sunday | | shopping.list | fruit | | shopping.list | candy | | shopping.list | pasta | | shopping.list | spinach |

Will generate:

{
	"shopping": {
		"day": "Sunday",
		"list": ["fruit", "candy", "pasta", "spinach"]
	}
}

Explicit array syntax

Arrays of values can be explicitly defined by using integer keys.

The following data:

| key | list | | --------- | ------- | | list.0.0 | fruit | | list.0.1 | candy | | list.1.0 | pasta | | list.1.1 | spinach |

Will generate:

{
	"list": [
		["fruit", "candy"],
		["pasta", "spinach"]
	]
}