How It Works
Learn how to get the most out of Table Hoarder.
menu_book How It Works expand_more
Lists
Lists are custom spreadsheet-style tables with user-defined fields. They're great for reference data like NPC rosters, item inventories, or encounter tables. A Sub-List is a special type that displays a filtered subset of rows from another list — useful for grouping or filtering a parent dataset without duplicating data.
Adding a List
- 1. Optionally select a folder in the sidebar to place the list inside it.
- 2. Click list_alt New List in the action bar.
- 3. Enter a name and optional description, then choose List or Sub-List.
- 4. For a regular list: click Define Fields to set up your columns. Once fields are defined, use Add Row or Import CSV to populate the data.
- 4. For a sub-list: click Select Parent List, choose the parent, and select which rows to include. You may also override values for fields marked as overridable.
- 5. Click Save List to finish.
Viewing a List
Clicking a list in the sidebar loads it in the main content area. All entries are displayed in a spreadsheet table with your defined fields as columns. The row count is shown in the top-right corner of the header.
- Regular lists — show all rows with each field value in its own column.
- Sub-lists — show only the selected parent rows. Any overridden field values are highlighted in blue; hover over them to see the original parent value alongside the override.
Editing a List
- 1. Click the list in the sidebar to select it.
- 2. Click edit_note Edit List in the action bar.
- 3. Make your changes to the name, fields, or row data, then click Save List.
Deleting a List
Deleting a list permanently removes all of its fields and row data. This action cannot be undone.
- 1. Click the list in the sidebar to select it.
- 2. Click delete Delete List in the action bar.
- 3. Confirm the deletion in the dialog that appears.
Sorting a List
Regular lists support saved sort rules that control the order rows are displayed. Sort rules are configured in the Edit List dialog and persist with the list.
- 1. Open Edit List. A Sort panel appears below the fields section.
- 2. Click Add Sort to add a sort rule. Choose a field and a direction — A → Z (ascending) or Z → A (descending).
- 3. Add additional rules to sort by secondary fields — they are applied in order (sort by … then by …).
- 4.
Optionally enter a Pattern to enable numeric group sorting.
The pattern
{d}[GP|SP|CP]groups rows by their suffix (GP first, then SP, then CP) and sorts numerically within each group. Rows that don't match any suffix are placed last.
Filtering and Sorting a Sub-List
When creating or editing a sub-list, the Select Parent List dialog lets you define filter and sort rules that are saved with the sub-list. These rules are re-applied every time the sub-list is viewed, so the displayed rows always reflect the current state of the parent.
Filtering — Simple mode
Click Add Filter to add a rule. Each rule specifies a field and a value to match (using contains by default). Multiple rules default to OR — a row is shown if it matches any rule. Use the Select All / None buttons to quickly select or deselect all rows that pass the current filter.
Filtering — Advanced mode
Switch to Advanced to unlock additional options for each rule:
- Operator — choose how the value is matched: contains, does not contain, starts with, ends with, equals, or does not equal.
- AND / OR connector — for each rule after the first, choose whether a row must match this rule in addition to the previous ones (AND) or instead of them (OR).
- Case sensitivity — click the Aa toggle to make a rule case-sensitive. By default all matching is case-insensitive.
-
Numeric patterns — use a
{d}token in the value to match a number inside a cell. Add a comparison operator to constrain the number:{d<=2}(2 or fewer),{d>=10}(10 or more),{d=5}(exactly 5),{d!=3}(not 3),{d~1,9}(1 through 9 inclusive). Plain{d}matches any number. You can combine literal text with the token — for example,{d~1,9} SPmatches "1 SP" through "9 SP". When a numeric pattern is detected, the operator is automatically treated as contains.
Sorting
The sub-list picker also has a Sort section that works the same way as sorting a regular list. Click Add Sort, pick a field and direction, and optionally supply a group pattern. Sort rules are saved with the sub-list and applied on top of the filter — the displayed rows are first filtered, then sorted.