Skip to content

Convert spreadsheet to JSON document lists (Couchbase conversion / import tool)

Notifications You must be signed in to change notification settings

nathanverrilli/odf2json

Repository files navigation

odf2json

Convert a spreadsheet to JSON documents. Intended to support ODS, but currently supports only Microsoft Office Open XML (.xlsx files). Looking for a decent way to support ODS without significant pain.

  • Assumes data header is in first row.

Usage

  • --debug log data to STDERR as well as log file
  • --infile string filename to process
  • --outfile string Output JSON file
  • --type string Name of record type conversion (default "record")
  • --verbose Lots of information (default true)

odf2json --infile zodmo.xlxs --outfile zodmo.json

Notes

Log data is written to odf2json.log

TODO

  • Add ODS support (open to suggestion)
    • Either autodetect XLXS/ODS format, or add flag
  • Make logfile dynamic rather than hard-coded
  • Better flag handling.

About

Convert spreadsheet to JSON document lists (Couchbase conversion / import tool)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages