Utility module which generates JSON Schema from Excel Spread sheet
Last updated 2 years ago by hugorper .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install @hugorper/excel-2-jsonschema 
SYNC missed versions from official npm registry.

js-standard-style Dependency Status Build Status

A tool to generate JSON Schema files from Excel Sheet


JSON Schema creation is difficult, especially for non-technical people. Excel is widely used and proves to be a good tool for defining schema

Excel-2-jsonschema CLI tool?

The excel-2-jsonschema CLI tool, allows to generate JSON Schema from Excel Sheet table.

Excel Table (input)

Name Property Type Description
Hotel Id string Hotel unique identifier.
Hotel description string Hotel description.
Hotel displayName string Display name of hotel.
Hotel capacity string Capacity of the hotel, ex: 44 people.
Hotel image string Image URL representing the hotel.

JSON Schema (output)

    "$schema": "http://json-schema.org/draft-07/schema#",
    "title": "hotel",
    "description": "hotel",
    "type": "object",
    "properties": {
        "id": {
            "description": "Hotel unique identifier.",
            "type": "string"
        "description": {
            "description": "Hotel description.",
            "type": "string"
        "displayName": {
            "description": "Display name of hotel.",
            "type": "string"
        "capacity": {
            "description": "Capacity of the hotel, ex: 44 people.",
            "type": "string"
        "image": {
            "description": "Image URL representing the hotel.",
            "type": "string"
    "required": []

CLI Tool (global mode)

CLI install

npm install -g @hugorper/excel-2-jsonschema

CLI Usage

How to Execute (with default args -e -v):
  excel-2-jsonschema -i ./sample.xls -s Schema -o ./dist 

Usage: excel-2-jsonschema [options]
  -i, --inputExcelFile <inputExcelFile>  'File Localtion' which contains Schema definations
  -s, --sheetName <sheetName>            'Sheet Name' which contains Schema definations
  -o, --outputDir <outputDir>            'Output Directory' where JSON Schema files should be generated## Install
  -e, --embedded <embedded>              'Embedded' If embedded Schema should be generated (default: false)
  -v, --versionSchema <versionSchema>'    Contains Schema version (default: http://json-schema.org/draft-07/schema#)



npm install @hugorper/excel-2-jsonschema --save-dev


Generate schemas.

const generateJSONSchema = require('generate-json-schema');
const path = require('path');

var options = {
    inputExcelFile: path.join(__dirname, 'example/sample.xlsx'),
    outputDir: path.join(__dirname, 'dist'),
    sheetName: 'Schema',
    embedded: false,
    versionSchema: 'http://json-schema.org/draft-07/schema#'  

generateJSONSchema(options.inputExcelFile, options.sheetName, options.outputDir, options.embedded, options.versionSchema);

Generate json example files.

const generateJSONExample = require('./src/generate-json-example');
const path = require('path');

var options = {
    inputExcelFile: path.join(__dirname, 'example/sample.xlsx'),
    outputDir: path.join(__dirname, 'dist'),
    sheetName: 'Schema'  

generateJSONExample(options.inputExcelFile, options.sheetName, options.outputDir);

List Gulp Tasks

  • clean: clean all output files
  • schema: Use generate json
  • example: Run example json output
  • build: Build project
  • lint: execute lint

For more informations about npm run-script, go to scripts of file package.json.

Excel sample files

Current Tags

  • 0.4.2                                ...           latest (2 years ago)

5 Versions

  • 0.4.2                                ...           2 years ago
  • 0.4.0                                ...           2 years ago
  • 0.3.6                                ...           2 years ago
  • 0.3.1                                ...           2 years ago
  • 0.3.0                                ...           2 years ago
Maintainers (1)
Today 0
This Week 0
This Month 1
Last Day 0
Last Week 1
Last Month 1
Dependencies (7)
Dev Dependencies (17)
Dependents (0)

Copyright 2014 - 2016 © taobao.org |