How to make an exhibit from an EditGrid spreadsheet

From SIMILE Widgets
Jump to: navigation, search

You should follow the Getting Started Tutorial first. This tutorial is just for getting data out of spreadsheets and into Exhibit's JSON format.

(1) Create an EditGrid account at EditGrid.

(2) Log into EditGrid and create a new spreadsheet.

(3) Carefully select just the text in the following table and copy it to your clipboard:

label type favorite-color homepage:url
Stefano Mazzocchi Person blue
Ryan Lee Person red
David Huynh Person blue; eggshell

(4) Paste the date from #3 above into the EditGrid spreadsheet. Save the EditGrid Spreadsheet.

(5) Highlight all of the filled data cells in the EditGrid spreadsheet and select Copy to Clipboard under the edit menu.

(6) Highlight all of the data on the clipboard and select copy from the web browser menu.

(7) Browse to Babel.

(8) Select

  • "Tab-Separated Values" from the "from format" list, and
  • "Exhibit JSON" from the "to format" list.

(9) Pick "the data is text I can paste into this web page" in the "data to convert" column.

(10) Paste the table you copied into the big text box.

(11) Click on the "Upload and Preview" button.

You should now see an exhibit of 3 items. This "trick" works with data copied straight from Excel spreadsheets or from Google Spreadsheets, too.

Note that the first row must contain the property names, which must include "label" in one of the columns. Also note that you can store the type definition for a column by appending a :type to the end of a column name, such as homepage:url, and babel will add it to the schema at the end of the json output.

You can now click on the Download Raw Data button in that Exhibit to get the Exhibit JSON data. Note that you could have gotten that data from the Babel page, too, by clicking the "Upload and Convert" button. For more information, refer to Babel's documentation.

Now that you have the data, following the Getting Started Tutorial for how to make the HTML page.

Personal tools