Note that this documentation is under development and incomplete.
TableTop is a lightweight tool for viewing, editing, sharing, and converting tabular information. I wrote it as an alternative to unwieldy spreadsheet programs. Spreadsheets are primarily about numbers. TableTop is all about text! Tables are not spreadsheets so why use the wrong tool? <smile>
When you boot up TableTop it displays a simple Demo Table…
This should look very familiar. TableTop is Mobile First and should work with any modern browser regardless of display size. (The screen shot above approximates how it will look on a tablet.) Let’s summarize the major elements starting from the top…
- “TableTop” in the upper left serves as the Main Menu. Click or tap it obviously.
- The current Table Name appears next (if there’s room).
- The Search Box allows you to see only rows that match what you type.
- The Save Button (disabled in this example) turns amber when you make changes.
- Column Letters
- Column Titles
- Column Totals (not yet!)
TableTop uses a “good enough” approach to security. Each table has a unique identifier in the form of a random string of letters and digits. (This is the same principal used for flight confirmation numbers and sharing calendars.)
The table ID in this example is ezX6LbZp8C3q. (IDs are case sensitive.) For obvious reasons it is important that you bookmark the link or otherwise save the ID for your new table.
TableTop assumes that each column is a field and each row is a record. The row numbers on the left allow you to reorder the table (and delete rows) as needed. To move a particular row up or down just click on its number. You will see a cluster of controls and a number entry field. To move row #3 up between #1 and #2 replace the 3 with a 1. The next time the table is saved the third line will become the new #2, pushing the former #2 down to #3. Note that entering zero will delete the row. Clicking the Trash icon does the same thing.
Clicking the # icon will open all rows for editing as shown above. Use the Tab key to close the current row and move to the next. After you’ve edited the order click Save to sort the table.
It is also possible to sort based on the contents of a particular column. To do so first open the column head for editing. Then click either the Sort or Reverse Sort button. This will sort the table and send the results to the server.
Sorting by column will handle different data types intuitively.
Click or tap on the title to access the function menu…
New Row/Column (always visible)
Table Info (title, author, email)
Link to Read-Only Version
Click or tap on the Upload command to import data in .tsv or .csv formats. You should check the First Line is Header box to treat the first row as column headings.
Click or tap on the Download command to save your table in one of the four formats listed. The data will be tab delimited by default (the native format). You may also convert your tabular data into comma delimited, HTML or SQL formats. (Note that HTML and SQL formats will be available in a future version of TableTop.) You have the option to include column headings (or not).