A step by step walkthrough for turning a spreadsheet into a searchable, sortable data table in PlotSet, from setting column types to publishing or embedding the finished table.
About 8 minutesA data table only earns the name if readers can actually search and sort it, not just stare at a screenshot of a spreadsheet. Here is how to create a data table in PlotSet that does both, built straight from your own rows and columns: every column has the right type set (so a currency column sorts as a currency, not as text), the header stays put while the body scrolls, and the finished table is ready to publish, embed or export.
Eight minutes is what it takes once your sheet already has clean headers and consistent column types. Pulling columns out of a wider report, or fixing a date column that got saved as plain text somewhere along the way, adds another ten. The steps below assume a real, slightly messy source file, not a tidy demo.
One row per record, one header row, and one consistent data type per column: text, number, currency, percentage or date. Mixed types in a single column are the main thing to clean up before uploading.
| Region | Manager | Revenue | Growth | Last Updated |
|---|---|---|---|---|
| North America | Jordan Lee | 1284000 | 0.062 | 2024-01-15 |
| Europe | Priya Shah | 942000 | -0.014 | 2024-01-15 |
| Asia Pacific | Wei Zhang | 1103000 | 0.081 | 2024-01-15 |
| Latin America | Carla Nunez | 412000 | 0.033 | 2024-01-15 |
| Middle East & Africa | Omar Farouk | 298000 | -0.02 | 2024-01-15 |
Give every column a plain, short header. PlotSet uses the header row as the column label, so "Q1 Rev (USD)" becomes the label a reader sees at the top of that column.
Keep one data type per column all the way down. If a currency column has "1284000" in most rows and "$1.28M" typed into one cell by hand, that column stops sorting correctly.
Dates read best in a consistent format such as YYYY-MM-DD. A spreadsheet that silently mixes 1/15/2024 and 15-Jan-24 in the same column will not sort as dates in PlotSet either.
Leave blank cells blank rather than typing "N/A" or "-" into a numeric or date column. Text placeholders in an otherwise numeric column break sorting for that whole column.
The exact click path in PlotSet, from a blank template to a finished chart.
From the PlotSet dashboard, start a new project and choose the Table template. It loads with sample rows already in place so you can see how search, sort and column types behave before you touch your own file.
One row per record, one header row, no merged cells and no subtotal rows mixed into the data. If your source is a pivot table or an export with a totals row at the bottom, delete that row before uploading.
Import a CSV or .xlsx file from the data panel, paste rows straight from a spreadsheet, or connect a Google Sheet if you want the table to reflect edits later without a re-upload.
Go through the columns one at a time and confirm text, number, currency, percentage or date. This single step decides whether sorting a column does something sensible or sorts "100" ahead of "9" the way a text sort would.
Every extra column costs horizontal space on a phone, so drop anything that does not answer the question the table exists to answer. Then choose which column the table sorts by on load, usually the one a reader is most likely to rank by first.
Enable the search box so readers can jump straight to their row instead of scanning the whole table, and keep the header row frozen so column names stay visible as the body scrolls.
Turn on row striping or hover highlighting so the eye can track a line across a wide table, right-align numeric columns so digits line up by place value, and add an in-cell bar to one numeric column if you want a magnitude comparison without giving up the printed number.
Publish for a live table with working search and sort and a shareable link, grab the embed code to drop it into a page, or export a PNG, SVG or PDF if you need a static image for a report.
Start from the Table template with sample data already loaded, then swap in your own.
Open the templateThe last stretch is the same for every chart type: Share turns the chart into a live public link and an embed code, Export writes it out as a static file.
Activating the embed code and public link publishes the chart. The link is safe to send to anyone, and the embed code drops into any page as an iframe that keeps the hover tooltips and the interactivity. Edit the chart later and hit Recreate to push those changes out to both.
Export writes a static copy at whatever size you need. SVG stays sharp at any scale and can still be edited in a design tool; PNG and JPG are the safe choices for slides and documents. The scale multiplier is what gets you a crisp image on a retina screen.
Sorting, alignment and number formatting all follow from the column type, so fixing it after you have already styled the table means redoing that styling. Do this step first, every time.
Past fifteen rows a reader loses track of which column they are looking at once the header scrolls out of view. Freezing it costs nothing and fixes that immediately.
If one numeric column is the one readers want to compare at a glance, add a bar inside that cell rather than building a separate bar chart next to the table. It keeps the exact number and the shape of the comparison in one place.
A table with ten columns reads fine on a laptop and becomes an unreadable strip on a phone. Decide what the table is for, publish only those columns, and leave the rest in the source spreadsheet.
This means the column type is still set to text, so "100" sorts before "20" the way a dictionary would order them. Open the column settings and set that column to Number or Currency, then re-check the sort.
This happens when dates were typed inconsistently in the source sheet (one row as 1/15/2024, another as 15-Jan-2024), so PlotSet cannot read the whole column as one type. Standardize the format in your spreadsheet to YYYY-MM-DD and re-upload.
This is almost always too many columns rather than a settings problem. Go back to the column list and remove anything that is not answering the question the table exists for, rather than shrinking font size to compensate.
Not sure the Table is the right choice? See what it is, when to use it and when not to.
One header row and one row per record, with each column holding a single consistent type: text, number, currency, percentage or date. Mixed types within one column, such as numbers and the occasional "N/A", are the most common reason a table does not sort correctly after upload.
Free to start with 300+ templates. No credit card required.
