Data Table Generator

You can create a table in 1 click using the + Column button or the + Row button, both of which instantly creates a 1x1 table ready for you to edit and build upon with those same buttons as needed. You also have the option to input the number of rows and columns you want to start with using the same named inputs ("Rows" and "Columns") located under the "Make a new Table" label. 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 or delimited text (csv, tsv, psv) 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 a dashboard of charts. These include pie charts for columns with limited distinct values, dot plots for date/numeric pairs of columns, and value distribution heat maps. Some useful stats are displayed in the dashboard too like average, minimum, maximum, total (if numbers), mode, and more.

Markdown tables organize and structure data in a simplistic way using simple text like pipes and hyphens to serve as column and cell borders. A major advantage to using DeeboData is the ability to instantly generate a markdown table from your data. Markdown tables can be exported for free with up to 100 rows. Numeric data will have all symbols and right alignment preserved in the final markdown. We will also honor cell center alignment if you select this option above the table.

We offer a variety of templates to get you started on a new table as well. You can begin a To-Do List, a Weekly Planner, and more using a professional template. The enterprise-level data table is the underlying structure that supports your Planner, List, or other project. Choose to edit data in the generated template or simply wipe the mock data and begin with a blank template. These are perfect for printing and then writing on for those who rather keep physical copies. When starting a new table from a template, you can still leverage all the data visualization tools described in below sections to undo or edit default styles.

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.

A dashboard of charts and data insights is automatically generated each time you load a dataset. You can find the dashboard below the table. Examples of charts created are pie graphs, bar charts, and dot plots. For numeric columns, value distribution charts truly help visualize a numeric column of data better. Currently, a major advantage of migrating to a data table on DeeboData is not only it's powerful filtering ability, but also the generation of these dashbords on the fly for only filtered or selected rows. The combination of these features can enhance data-driven decision-making to a level few other applications can. You'll easily be able to find and reward or double-down on a given set of attributes in your data that seems to be working for your business or operation. On the flip side, you'll be able to use the premium filtering feature to detect values for certain columns in your data set that are weak links and need action to be taken to mitigate losses or negative effects on your plan or project.

Pagination makes it easy to work with as many rows of data as your hardware can load and process. Any data you load or insert into a table on DeeboData is automatically paginated. 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.

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.

You can add styles to single cells in your table. Simply focus on a cell, and a paint icon will appear in the top corner. Above the table, you will also notice the single cell style menu become enabled, at which point the focused cell can be given bold font, simple decorations, and backgrounds.

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 add_circle_outline 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. Back to table

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

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. You have the option to export your table instantly to a markdown table.

Tips for after you start your table

• Use the Design button at the top right of your table to style the headers and paginator with your chosen theme
• Click column headers to alter the styles of the cells for that column
• * The save button on the top right of the table is the button you use to save work to your account across browsing sessions. Not the save buttons mentioned later in pop ups. Those are for applying styles within a session.
• 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
• 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 table height, column header height, and set data row heights by clicking the aforementioned Design button or clicking and dragging on desktop.
• Drag and drop images into column headers or select files from your device
• Copy and paste links in cells and we'll collect images and data about the link