Database
Collections, Hillnote's databases, are organised folders where every row is its own page and the columns are that page's properties. Open any row to write notes inside it. On disk, a collection is a folder with one Markdown file per row, and each file's YAML header holds that row's values, so other apps and AI agents can read it too. A collection can show its rows in several ways, called views.

Collections suit up to a few thousand rows. For big tables of plain data, use a sheet (see Sheets for big tables below).
Creating a collection
To create a collection, click + (Create new) in the sidebar. Under Organised Folders, choose New collection, or open Templates and pick one: TaskList, Calendar, Blog or Map. Type a name and click Create. Manage Columns opens so you can set up your columns straight away.

A blank collection starts with Title and Tags, and its dialog is called New Table. The templates come ready for their job:
| Template | Starts with |
|---|---|
| TaskList | Status, Priority and Due Date; opens as a board |
| Calendar | start and end dates, Category and Recurring; opens as a calendar |
| Blog | Author, Status, Tags and Cover Image; adds board and gallery views |
| Map | Location and Category; opens as a map |
Columns
Once you create a collection, the next step is defining the columns you'd like to track across your rows. Click the gear (Manage columns) in the toolbar. This opens Manage Columns, where you can add, edit, reorder or delete columns. Use the arrows next to a column's name to move it, or click Add Column to add a new one.

Every column has 3 values.
Name: what the column is called
Type: the kind of value it holds
Default Value: an optional value filled in on every new row
Types of columns
There are 15 types of columns.
- Text
- Number
- Select: choices with colours
- Multi-select: choices with colours
- Date
- Date & Time
- Checkbox
- URL
- Person
- Status (only 1 allowed per collection)
- Recurring (only 1 allowed, and only once the collection has a Status column)
- Location: a place, coordinates or a maps link
- Image: a cover for gallery and board cards
- Formula: worked out from other columns, or by AI
Special column settings
Some column types have extra settings to help manage how they are tracked.
Status
As you add status options, you can give each one a state: Normal, Done or Archive.
- Normal: treated like every other choice.
- Done: rows with this status count as completed and show struck through. This helps in tracking end dates, reminders, etc.
- Archive: rows here get less emphasis. On a board, archive columns fold into a stack you can expand.

Date
Date columns can be given the Start Date or End Date role, with the calendar button next to them in Manage Columns. Calendars and gantt timelines use these roles. Each role can go on only one column per collection.

Recurring
If a collection has a Status column, you can also add a Recurring column. It sets up tasks that repeat, like a weekly review, and it's set per row. Click a task's cell in that column, then Set recurring.... Pick a Frequency and how often it repeats, then choose what to Reset status to. Next reset shows when it happens, and you can change it. On or after that date, finished tasks go back to that status and get their next date.

Formula columns
Choose Formula as the column type, then pick a mode:
- Formula: a calculation such as
{Price} * {Qty}, with column names in braces. Use+ - * /,&to join text, comparisons such as=and<>, and functions such asSUM,ROUND,IF,CONCAT,TODAYandDAYS. Show as and Decimals format the result. - AI formula: describe the calculation in words, then click Generate formula.
- AI answer: a prompt run once per row, like
Summarize {Notes} in one sentence. Answers are saved and can be edited. Turn on Fill new rows automatically, or hover a cell and click refresh (Regenerate with AI) to run it again.
Formula results update live and aren't saved in the files. In a collection they can't be filtered or sorted. In a sheet you can filter them (see Sheets for big tables below).
Once a collection has an AI answer column, an AI columns button appears next to the gear in the toolbar. Its Fill empty cells in … item fills every empty cell of that column in one go. For more ways to use AI with your rows, see AI while you write.

Views
Views allow you to see and organise the same rows differently. Each view keeps its own filters, sort and hidden columns. To add one, click + next to the view tabs, pick a type (Table, Board, Gallery, Calendar, Chart, Gantt, Dashboard, Map or Custom), name it and click Create View. Drag the tabs to reorder them. Every view except the first has a ⋯ menu with Edit View (its name, type and grouping) and Delete View.

Clicking a card, event, bar or pin opens that row side by side. On board and gallery cards, ⋮ ▸ Open opens the row's page instead. Every view is live: when another app or an agent edits the files, the view updates by itself. Hillnote currently supports the following types of views.
Table view
A grid of your rows. Click a cell to edit it, click a header to sort (click it again to reverse the order), and drag a column's edge to resize it. Long tables show 200 rows per page.
Boards
A board (kanban) sorts cards into columns by a Select, Multi-select or Status column. Drag a card to another column to change its value, or click New item in a column to add a row with that value set. Row Group By (Optional) in Edit View adds swimlanes. Cards show checklist progress and comment counts.
Cards without a value sit in a No Value column. In the desktop app, a card's ⋮ menu also has Delegate to agent, to hand the card to an agent, and Schedule move…, to move it to another column at a set time. See Agents in your workspace and Automations.

Calendar views
A calendar puts rows on their dates, using the column with the Start Date role, or else the first date column. Today and the arrows move through time, and Month, Week and Day change the range (Day needs a Date & Time column). Drag an event to move it, or its edge to change its length. Click a day, or drag across days, to add a row with those dates. Recurring rows repeat, and the colour button colours events by a column.

Gallery
A gallery shows rows as cards. With an Image column, the Cover menu sets the cover's shape: Square, Landscape, Portrait or No cover.
Gantt
A gantt view draws each row as a bar from its Start Date to its End Date column. Drag a bar to reschedule it, or an edge to resize it. A row with one date shows as a milestone. Drag the dot at a bar's end onto another bar to link them. View options turns on Progress fill, Dependencies and Group by, and Day, Week and Month zoom the timeline.
You set the two roles in Manage Columns (see Date under Special column settings above). A row with no dates gets an empty lane: drag across it to schedule the row. To add a row, drag in the bottom lane or click New row. To unlink two bars, click the arrow between them, then × (Remove dependency). Progress fill comes from the row's status, or from the checklist in its page.

Map
A map pins rows from a column of places: city names, addresses, "lat, lng" coordinates or Google Maps links. Choose the Location column, a Map style (Colorful, Minimal, Detailed or No labels) and Color pins by. A chip counts the rows pinned and not found; hover it for tips. Click Drop pin, then click the map to add a row at that spot (Esc cancels), and Fit zooms to show every pin. Looking up place names needs the desktop app, and a map shows up to 5,000 rows.

Charts and dashboards
A chart view draws a bar, horizontal bar, line, area, pie, donut or scatter chart. Set Group by:, an optional Split by: and a Value:, such as a row count or the sum or average of a number column. When you group by a date, Bucket: groups it by Day, Week, Month, Quarter or Year. Options sets sorting, the top groups and stacked or grouped bars. A chart counts up to 200 rows, one page of results.
A dashboard is a grid of Chart, Stat, Upcoming dates and Recent documents widgets. Click Add widget or Add starter widgets, and drag a widget's header to move it. Hover a widget to Resize, Edit widget, Duplicate widget or Delete widget. Each widget can have its own filters and reads up to 10,000 rows.

Custom views
A Custom view shows your rows in an HTML tool of your choice: a card deck, flashcards, a leaderboard, anything. Click + next to your views and choose Custom. Then pick one of Your tools, start from Templates (such as Card deck, Chart or Flashcards), or describe what you want in Build with AI and AI builds it for the collection's columns.
The view's filters, search and sort apply to the tool too, and edits the tool makes (moving a card, changing a status) save straight back to your rows. If a tool asks for other data, click Allow or Deny: tools only reach the data you allow. Change tool, Edit with AI and Reload tool are there later. You can also start from Tool Forge: Link data picks the collection or sheet a new tool is built for. Custom views need the desktop app. More on making tools is in Tools.

Filters in views
Click Filter, then pick a column, a condition and a value, such as Status is any of In progress or Due is before Today. The conditions depend on the column's type:
- text: contains, is, is empty and more
- numbers:
>,≥,<and≤ - dates: is before and is after, with shortcuts such as Today, Tomorrow and In a week
- choices: is any of and is none of
- checkboxes: Checked or Unchecked
Add more with the dashed Filter chip, and Clear all removes them. Hide picks the columns the view shows, and the search icon finds rows by text.
The first view's filters are temporary: click Save as View to keep them as a new view. Other views save their filters automatically.

Adding a row
Click the New Row button in the top right of the collection (New in other views) to open Add New Row. Fill in the fields, or write a sentence under Describe, like "go for a run at 6am every day", and press ⌘↵ (Ctrl+Enter on Windows) or click Review. AI fills in the fields for you to check, trying a free on-device engine first. Then click Add Row and you are done!

You can also click any table cell to edit it, or hover a title and click View to open the row side by side, or the arrow beside it to open the row's page. On a row's page the columns show as properties, and a property you add there becomes a column. To delete rows, select them and delete them together.
Sheets for big tables
A sheet keeps all its rows in one CSV file with a fast local index, so it stays quick however large it grows. Its rows are plain data, with no page each, and the whole sheet syncs as one file. Use a sheet for big tables, exports, logs or anything from a spreadsheet, and a collection for up to a few thousand rows that each need notes. You can switch later (see Switching between a sheet and a collection below).

Creating or importing a sheet
To make one, click + (Create new) in the sidebar, then Sheet (CSV) under Datasets. Type a name and click Create, or click Start from a CSV file…. You can also drop a .csv or .tsv file onto the window. Imports take CSV, TSV and Excel (.xlsx, .xls) files up to 100 MB.
Hillnote guesses each column's type from the data, and each Excel worksheet that has data becomes its own sheet. Import Files, in the menu under the workspace name, brings spreadsheets in as sheet unless you switch them to as markdown (see Files panel and importing).

Adding rows from another file
In an open sheet, click Import CSV and choose a file. Then choose where each of its columns goes: an existing column, ➕ Create new column, or Skip.
Turn on Update existing rows when row ids match to update the rows the sheet already has instead of adding them again, for example from a copy of its data.csv that you edited elsewhere. Left off, every row is added as a new one.

Editing, sorting and filtering
Sheets work like collection tables:
- Click a cell to edit it. New Row opens Add New Row, which can fill the fields from a sentence (see Adding a row above).
- Filter adds the same filter chips as collections, and in a sheet you can filter formula columns too.
- Sort orders the rows by a column, and Clear sort resets it.
- The search icon finds rows by text.
- Select rows to delete them. This can't be undone.
Manage columns offers the collection column types plus Document Links, which link a row to pages in your workspace with @. Formula columns work here too.

Views on a sheet
Sheets offer the same filters and views as collections. To add a view, hover the view tabs, click + and pick a type in New View. Deleting a view never deletes rows, and Custom views need the desktop app. Calendar, gantt and map views show the first 5,000 rows, so add filters to narrow down a bigger sheet.

Editing data.csv outside Hillnote
A sheet's rows live in data.csv in the sheet's folder, so you can open it in a spreadsheet app or let an agent edit it, and Hillnote merges the changes row by row. When it does, the sheet shows Merged changes from data.csv.
If a row changed in both places, the file's version wins and a banner offers Review. In Review Conflicts, choose:
- Use mine to take back your edit
- Restore my row if the file deleted a row you'd edited
- Delete it again if you'd deleted a row the file kept
To reload the file by hand, click Reload from data.csv in the toolbar.

Some quick tips
Embedding a collection within a document
You can embed a collection in a page (Pages) by typing @ or [[, picking the collection and clicking Insert Database. This adds an interactive embed within the document, with its view tabs and rows. Its ⋯ (Show controls) bar adds search, filters and sorting and, for AI answer columns, AI columns ▸ Fill empty cells in ….

Switching between a sheet and a collection
A collection's ⋮ menu in the sidebar has Convert to Sheet, and a sheet's has Convert to Database. Notes inside row pages aren't carried over to a sheet, and the old files stay as backups.
Converting a sheet turns each row into a page, and its data.csv stays as a backup. So to make a collection from a CSV file, create a sheet from the file first (see Creating or importing a sheet above), then convert it.
Using triggers to start workflows from your collection
Triggers can act when a row is added, when its status changes or when a field changes. Click the workspace name at the top of the sidebar, then Triggers, and click New trigger. A trigger can start an agent CLI on your computer, send the event to a plugin, or fire a Hillnote routine on the server. More in Automations.