Note that this documentation is under development and incomplete.

Welcome!


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>

The Basics


Getting Started

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…

Title Bar

  • “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 Headings

  • Column Letters
  • Column Titles
  • Column Totals (not yet!)

Row Numbers

  • one
  • two
  • three

 

 

 

Access/Security

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.)

1b-url-with-id

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.

Advanced Features


Sorting

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.

2a-sort-default

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.

Column Sort

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.

2b-sort-by-column

Sorting by column will handle different data types intuitively.

2-sorting

Administration


Menu

Click or tap on the title to access the function menu…

3-mainmenu

New Row/Column (always visible)

Table Info (title, author, email)

Link to Read-Only Version

Upload

Download

Misc. Tools

Revert/Refresh

Quick Reference

Full Documentation

 

Upload

5-upload

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.

Download

6-download

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).