TableTop is a lightweight tool for 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 best way to learn TableTop is to start a new table…
Enter a title, author and contact email for the table. All these are optional but certain features will not work without a valid email address. Click the start button and you’re in business!
You will see a simple 3×3 table ready to accept your data. Click on any of the green buttons to edit cells, headings and more. The toolbar provides additional functions: Main Menu, Add Row, Add Column, and Save.
Adding a row does what you expect, likewise for columns. Administration is discussed below.
Saving Your Work
When you make additions or changes to your table the Save icon turns orange. Click or tap the icon to save your table to the server. If you don’t wish to save your changes just refresh the page to go back to the previous version.
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).