Spreadsheet Forms

Spreadsheet Forms is a Python library for working with data in JSON format from forms contained in spreadsheets.

It includes functions to:

• Create a blank spreadsheet form for collecting data
• Populate a spreadsheet form with existing data for review
• Extract JSON data from a spreadsheet form for storage and processing

The above functions require a guide form spreadsheet that specifies the structure of the form.

There can be several functions to achieve the same thing, based on what level of performance you need.

• Examples
  • A Guide Form spreadsheet
  • Extracting data from a spreadsheet
  • Populating a spreadsheet form
• Requirements
• Python API
  • make_empty_form function
  • get_data_from_form function
  • get_guide_spec function
  • get_data_from_form_with_guide_spec function
  • put_data_in_form function
• Guide Form
  • Single field
  • Down field
  • Right field
  • JSON Keys