Skip to content

eviltester/grid-table-editor

Repository files navigation

Node.js CI

Wallaby.js

Data Grid Table Editor and Data Generator

A simple Data Table Editor that generates Markdown, CSV or JSON. It can also be used to interchange data between the formats, supporting editing in the grid.

  • Grid interface
  • drag and drop rows to re-order
  • drag and drop columns to re-order
  • import csv from file
  • import csv, markdown, and json from editor
  • generate csv, markdown, json and javascript from grid
  • export csv, markdown and json files
  • add and delete columns
  • add and delete rows
  • randomly fill data with Test Data
  • configure export options

Use The Editor

The application is live at AnyWayData.com

  • Or clone and run locally by opening index.html in a browser after starting a web server in the folder e.g. python3 -m http.server

To Generate Test Data

Expand the "> Test Data" section.

Enter a spec.

The spec is a paragraph of text where each line is either a 'name' or a 'rule':

name
rule
name
rule
  • name will be used as a column name
  • rule will be used to generate the data

A rule can be a regex string e.g.

  • (connie|bob) which would generate 'connie' or 'bob'
  • [1-9][0-9]{0,4} which would generate number between 1 and 99999

A rule can also be a faker API call.

Faker API can be found here: https://marak.github.io/faker.js/

e.g.

  • faker.name.firstName
  • faker.hacker.noun

The fake method is also supporter, which takes a mustache template style string combining api methods e.g.

  • faker.fake {{name.lastName}}, {{name.firstName}}

So a sample test data spec might look like:

name
faker.fake {{name.lastName}}, {{name.firstName}}
desc
faker.lorem.paragraph
collects
faker.hacker.noun
prefers
(Connie|Bob)

Similar Apps

Looking for similar apps to compare features sets and functionality?

There is a maintained list in the documentation:

References

Libraries Used

Tool Categories

This tool falls in to the categories:

  • online markdown editor
  • markdown table generator
  • markdown table editor
  • Online Test Data Generation
  • Online CSV Editor