26 column types
Text, number, date, checkbox, select, relation, lookup, rollup, formula, button, barcode, files, user references — and a dozen more.
Excel's flexibility, a database's reliability
26 column types, formulas across them, base- and column-level permissions, full change history. No migrations and no database administrators.
demo-стенд · Таблица «Сделки»
Демо-стенд скоро поднимется.Здесь будет настоящая публичная ссылка на «Таблица «Сделки»» из продукта.
Problem
Excel ends where permissions begin
Excel works well as long as one person owns the file. The moment you need to share edit access, hide salary columns, or prevent accidental deletes, the pain starts. Struktura gives you Excel's flexibility and a server-side permission model at the same time.
Features
A no-code data builder
Everything that usually needs a DB admin — configurable through the UI.
Formulas across columns
Compute sums, differences, percentages, concatenations, and conditionals. Server-side validation keeps errors out of the database.
Relations and lookups
Two-way links between tables. Pull fields from related records via lookup and aggregate with rollup.
Permissions in the base
Roles: owner / moderator / editor / viewer. Hide columns and filter records by role. Salaries are visible only to the owner.
Filters and views
Complex conditions like 'status = active AND department = marketing OR due < today'. Save views and share them by link.
Soft-delete and history
Deleted records go to the trash and restore with one click. Change history is kept for 90 days.
Import and export
Single-step CSV and Excel imports. Export to CSV, JSON, or via API. Files live in S3-compatible storage.
Performance
Virtualized rendering for tables with tens of thousands of rows, server-side pagination and search. No browser lag.
How it works
From XLSX to a configured workflow in half a day
- 1
Import Excel
CSV or XLSX uploads finish in a minute. Column types are suggested automatically.
- 2
Set permissions
Assign editors and viewers, hide sensitive columns from regular users.
- 3
Link tables
Two-way relations between employees, projects, clients, documents. Lookup pulls the fields you need.
- 4
Formulas and automations
Compute margins, lateness status, and budgets with formulas. Then build automations on field changes.
Scenarios
Two real-world table examples
The same builder handles HR registries and manufacturing logs.
Employee registry
A single source of truth about people: name, department, level, start date, projects, salary. Sensitive columns are visible only to the HR director and finance.
- Linked to the 'Projects' table via two-way relations
- Lookup pulls the project manager's name into the employee card
- Soft-delete — terminated employees move to archive without being lost
Equipment registry
Every machine is a record. Maintenance history is a linked table. The next PM date is calculated by formula, an automation notifies the engineer a week ahead.
- QR code prints straight from the card
- Repair requests arrive via a public form
- Rollup: number of failures per quarter appears right on the card
Comparison
How Struktura tables differ from Notion, Jira, and Excel
| Возможность | Struktura | Notion | Jira + Confluence | Excel + Google Drive |
|---|---|---|---|---|
| Typed columns | ✓ | basic | — | — |
| Formulas across columns | ✓ | — | — | ✓ |
| Relations and lookup | ✓ | ✓ | — | VLOOKUP |
| Column-level permissions | ✓ | — | via schemes | — |
| Per-row change history | ✓ | basic | ✓ | — |
| Open API | ✓ | ✓ | ✓ | — |
Move your Excel registries into Struktura
We'll help with import and permissions setup on the Business plan. Free for up to 5 users.