ExcelJsonTable

ExcelJsonTable is an excel add-in to import table from json and export table to json. It is written for users to input table-like data by Excel easily and export data to json format for being read by program correctly.

Where can I get it?

Visit Release page to get latest add-in install file.

Example

Those are card data of famous game Hearthstone. (Data was collected from https://hearthstonejson.com)

You can easily update data within excel. After exporting data, following json file is saved. TemplateTable might be usuful to read and write json table.

[
  {
    "Id": "AT_001",
    "Name": "Flame Lance",
    "Type": "Spell",
    "Rarity": "Common",
    "Text": "Deal $8 damage to a minion.",
    "...": "..."
  },
  {
    "Id": "AT_002",
    "Name": "Effigy",
    "Type": "Spell",
    "Rarity": "Rare",
    "...": "..."
  },
  "..."
]

Create

With json-file, you can build table as json looks like.

• Click Create button and choose file, table data will be created from json.

Import

Basically it is almost same with Create. But import keeps original excel layout if possible.

• Click Import button and choose file, table data will be imported from json.

Export

• Click Export button and choose file, table data will be exported to json.