Table Maker

Table Usage Tips

* Tips for after you start your table

Click the Design button on the top right of the table to style the table headers and paginator with a consistent theme
Click column headers to alter the styles of the cells for that column
Log In or Sign Up to save your tables for later and share tables with people you know. You can control their read or write access.
You can drag columns into different ordinal positions and save the order.
When you make changes in a pop up editor, make sure you click the save button to apply all your changes.
Use + Row to add a row to the end of your table. To add a row before a specific row, select that row's checkbox in the first column and then click the + Row button.
Scrolling horizontally - scroll the table body (not headers) for headers to keep up
Labels are a powerful feature. Double click a row to add a label above it:
On wider screens when you want to vertically drag a row to resize it and the resize cursor won't show up, make sure you're scrolled to the bottom of the cell's text if a scrollbar is present in the cell.
You can resize the full table height, column headers' height, and set a uniform data row height by clicking the aforementioned Design button
Drag and drop an image into a column header to serve as the header
Paste links in cells and let us try to obtain more info about the links

How to Make a Table

There are a variety of ways to generate a data table. You can create a table in 1 click using the Column button or the Row button which instantly creates a 1 column by 1 row table ready for you to edit the first cell and build upon with those same buttons as needed. Or you can tell us the number of rows and columns you want. We'll instantly build the table, then it's up to you to edit all the column and cell values. For users that already have some data in a file, url, or structured into an acceptable text format, our table maker converts json, common delimited text formats (csv, tsv, psv), and flat files to a data table. So far, there are 4 ways in which we intake these text formats. You can select a file from your device, drag and drop a file, paste or enter the raw text into the textarea, or paste or enter a URL pointing to a resource whose internet media type and format is one of the accepted types. Excel spreadsheets and workbooks (xls and xlsx) can be selected from your files and if tabular data exists, we'll make it into a data table and present options to dynamically re-fill the table with any distinct tabular data within all the other worksheets in your workbook. Besides generating a data table, we also help you visualize your data by creating pie charts where applicable. Lastly, some useful stats are displayed for any given column of data if possible like column average, minimum, maximum, sum (if numbers), mode, and more.

Interactive Table

Manipulate data in your table using almost impossibly nifty column filters and sorts developed to handle as many columns as needed at once. But the filtering capabilities don't end there. Besides checking if column values are equal to a desired input, you can also filter based on what values do not equal an input. For numbers and dates, filter what's greater than or less than an input. Edit any cell value or column name in your table. Another useful feature is the ability to hide columns. Simply click the minus symbol in the top right of any column to hide it. The first column also has the ability to be frozen if the width of the table necessitates scrolling horizontally. Look in the top left corner of the first column in a table with many columns and you'll see an icon that can toggle freezing that first column.

Pagination of Rows

Pagination makes it easy to work with as many rows of data as your hardware can load and process. You have the option of 25, 50, or 100 rows per page. To date, using a Dell Inspiron i3 desktop (4 core CPU), we've successfully loaded (~7 secs) and performed filters and sorts on a table with 300k rows and a dozen columns - an 84 MB csv file. Your PC or mobile device will determine how much data can be handled.

Custom Table

Use the table designer to customize your table's baseline theme styles and colors. The color related changes you make in the form that opens when you click the 'Design' button above the table will affect the column headers, paginator, the outer border of the table, and each row's bottom border. Additionally, the table and row heights can be modified. Alternate between center and default alignments for rows as well. Number columns appear right aligned by default.

Control columns individually by clicking on column headers, namely the column name text to avoid other controls (like filters) on the headers that trigger actions other than what we will detail here. Edit column names here, but the primary purpose of these controls is to tailor a specific columns' cells. You can adjust all the cells in a column's text color or background. For numeric columns, take advantage of the heat map feature. It's a perfect way to draw an audience to data that suggests something needs attention. Adjust the entire column width as well. Over time, more it's likely that more controls will be introduced.

Add Labels to your Table

Use labels as subheaders, to group data, or for any noteworthy reason you come up with. Style and edit labels. To create a label, select a row and click the that appears beside the first cell value in the row. You can also double click a row to insert a label above it. Labels are always added above the row with the plus sign you clicked. Labels are not really new rows. They do not affect the underlying data that your table represents. Merge cells horizontally in a "row" of labels to better serve the purpose of having labels. Please read below about how labels are short term additions to your table that help with presentation in a finished state.

Beware, labels are fleeting. Once you filter, sort, or move to a new page the label will be lost because after taking such actions, data has been re-arranged and the label placement and meaning is likely no longer valid. Think of labels as finishing touches on a table view you are ready to share, print, or convert to an html table. We will preserve the labels on the screen in the output for all of these actions.

Print or Export Your Table

As mentioned above, print your table with your theme colors and take it with you on the go to share in person, export to any of the accepted input formats, or export to an HTML table with all your styles and up to rows. You'll receive the raw txt file and the html file.