Welcome!


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>

2-sorting

The Basics


Getting Started

The best way to learn TableTop is to start a new table

0-starting

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!

1-overview

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

1a-toolbar-unsaved

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.

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