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.
约 8 分钟A 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.
PlotSet 中从空白模板到完成图表的具体点击路径。
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.
从已加载示例数据的 Table 模板开始，再替换成你自己的数据。
打开模板最后一段路对每种图表都一样：「Share」（分享）把图表变成一个在线的公开链接和一段嵌入代码，「Export」（导出）把它输出成静态文件。
打开嵌入代码和公开链接的开关，图表就发布出去了。链接可以放心发给任何人；嵌入代码以 iframe 的形式放进任意页面，悬停提示和交互效果都会保留。之后修改了图表，点「Recreate」就能把改动同步到链接和嵌入代码两边。
「Export」会按你需要的尺寸输出一份静态副本。SVG 放到多大都清晰，还能在设计工具里继续编辑；幻灯片和文档用 PNG 或 JPG 最稳妥。想让图片在高分屏上够锐利，关键就是那个倍数设置。
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.
不确定 Table 是否是正确选择？查看它是什么、何时使用以及何时不使用。
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.
免费开始，300+ 模板任选。无需信用卡。
