ExamplesΒΆ

A guide form spreadsheet is the template to show us where to expect data:

Pet SPREADSHEETFORM:SINGLE:pet
   
Toys:  
Title Does it squeak?
SPREADSHEETFORM:DOWN:likes/toys:title SPREADSHEETFORM:DOWN:likes/toys:squeak

A spreadsheet of:

Pet Dog
   
Toys:  
Title Does it squeak?
Plastic bone Oh Yes
Tennis Ball No

Will map to the data (and vice versa):

{
    "pet": "Dog",
    "likes": {
        "toys": [
            {"title": "Plastic bone", "squeak": "Oh Yes"},
            {"title": "Tennis Ball", "squeak": "No"}
        ]
    }
}

Note the SINGLE keyword is turned into a field, but the DOWN row is turned into a list. People can add as many or as few items to the DOWN table as they want.