A simp A2A2 le 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
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
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
namewill be used as a column namerulewill 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://fakerjs.dev/api/
e.g.
faker.person.firstNamefaker.hacker.noun
The faker prefix is optional:
e.g.
person.firstNamehacker.noun
The fake method is also supported, which takes a mustache template style string combining api methods e.g.
helpers.fake("{{name.lastName}}, {{name.firstName}}")
So a sample test data spec might look like:
name
helpers.fake("{{name.lastName}}, {{name.firstName}}")
desc
faker.lorem.paragraph
collects
hacker.noun
prefers
(Connie|Bob)
Looking for similar apps to compare features sets and functionality?
There is a maintained list in the documentation:
- Faker.js for domain api
- RandExp.js for regular expression based random data generation
- AG Grid for the data table
- PapaParse for csv processing
This tool falls in to the categories:
- online markdown editor
- markdown table generator
- markdown table editor
- Online Test Data Generation
- Online CSV Editor
Test - npm test
Preview Docs - npm run previewdocs
Build for release - npm run anywaydata:win
- TODO: add a preview toggle for the 'text editor' to only show a few rows - should also disable editor to grid buttons
- TODO: convert all JS to TypeScript
- TODO: improve and expand the test data generation - written in TypeScript, don't use faker directly - create a full semantic abstraction
- TODO: create a DSL for the test data generation... probably just JSON initially
- TODO: convert UI to use React?