Repository navigation
Tables market gap analysis #103
Description
Market analysis, focusing on the most common "tables" software solutions.
Status of Tables checked against master (2.4.0-dev, October 2026). Competitor cells are based on their public docs and pricing pages; ❓ means not verified yet, corrections welcome.
Legend: ✅ yes · ◐ partial · 🚧 open PR · ❌ no · 💰 paid tier only · ❓ not verified
| Feature | Nextcloud Tables | Microsoft Lists / SharePoint | Airtable | NocoDB | Baserow | SeaTable |
|---|---|---|---|---|---|---|
| Column types | ||||||
| Basic types (text, rich text, number, date/time, select, checkbox, rating, progress, link) | ✅ see #981 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Person / user / group | ✅ users, groups, teams | ✅ | ✅ | ✅ | ✅ | ✅ |
| Relation (link to rows of another table) | ◐ single value only (#2248); multi-value #2952; auto-link by key #3162 | ◐ lookup column | ✅ | ✅ | ✅ | ✅ |
| Lookup (show field of linked row) | 🚧 #2271, see #1794 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Rollup / aggregate over linked rows | ❌ see #1388 | ❌ | ✅ | ✅ | ✅ | ✅ |
| Formula / calculated column | ❌ #3161 (see #36, #888) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Auto number / UUID | ◐ row ID as meta column; UUIDs #3093 | ✅ ID | ✅ | ✅ | ✅ | ✅ |
| Created / modified by & at | ✅ meta columns (display names: #1258) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Files / attachments | ◐ link to Nextcloud files with image preview (#2946); direct upload #2890 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Email / phone | ◐ as text or link; mailto:/tel: #2680 |
◐ | ✅ | ✅ | ✅ | ◐ ❓ |
| Location / map coordinates | ❌ #403 | ✅ | ◐ via extension | ✅ | ❓ | ✅ |
| Button / action column | ❌ | ❌ | ✅ | ✅ | ❓ | ✅ |
| AI-generated column | ❌ | ❌ | ✅ | ✅ | 💰 | ❓ |
| Other suggested types (IP address, color, emoji, …) | ❌ see #981, #402 | ❓ | ◐ | ✅ color | ❓ | ❓ |
| Data quality | ||||||
| Mandatory fields | ✅ | ✅ | ◐ forms only | ✅ | ❓ | ❓ |
| Default values | ✅ | ✅ | ✅ | ✅ | ❓ | ✅ |
| Unique values | ◐ short text only (#1770); user column #2910 | ✅ | ❌ | ❓ | ❓ | ❓ |
| Validation formats (e.g. IBAN, postcode) | ❌ #3128, format packs #3129 | ✅ formula validation | ❌ | ◐ | ❓ | ❓ |
| Views | ||||||
| Saved views with filter & sort | ✅ AND/OR filter groups, multi-sort | ✅ | ✅ | ✅ | ✅ | ✅ |
| Hide / reorder columns per view | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Column width | ✅ setting (#1929); drag to resize #2085 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Grouping rows | ❌ #1625 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Conditional formatting / row colors | 🚧 #2538 (issue #360) | ✅ | ✅ | ✅ | 💰 | ✅ |
| Column summaries (sum, avg, count) | ❌ #606, #36 | ✅ | ✅ | ✅ | ❓ | ✅ |
| Tiles / gallery layout | ✅ (#2407) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Kanban view | ❌ no issue yet | ✅ | ✅ | ✅ | 💰 | ✅ |
| Calendar view | ❌ no issue yet | ✅ | ✅ | ✅ | 💰 | ✅ |
| Timeline / Gantt view | ❌ no issue yet | ❌ | ✅ | 💰 cloud | 💰 | ✅ |
| Form view (incl. public form) | ◐ row create dialog; public form #2664 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Charts / dashboards | ◐ possible with Analytics. Built in simple chart #2958; grid pages with widgets 🚧 | ◐ via Power BI | ✅ | ✅ | ✅ | ✅ |
| Print / PDF | ◐ print styles (#931); PDF export #3013 | ✅ | ✅ | ❓ | ❓ | ✅ |
| Editing | ||||||
| Inline editing | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Copy / paste from spreadsheets | ❌ #378 (dates: #2714) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Bulk edit selected rows | ❌ #61 (bulk delete and export: ✅) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Duplicate row / table | ◐ row ✅ (#2456); table #1965 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Undo / redo | ❌ see #1601 | ❓ | ✅ | ✅ | ✅ | ✅ |
| Real-time updates of other users' changes | ❌ #2128 (does work for Nextcloud Text fields) | ❓ | ✅ | ✅ | ✅ | ✅ |
| Collaboration & permissions | ||||||
| Share with users, groups, teams + permissions | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ |
| Sharing via public link | ✅ with permissions (#2483) | ◐ tenant dependent | ✅ | ✅ | ✅ | ✅ |
| Federated sharing (across servers) | ✅ (#2786) | ❌ | ❌ | ❌ | ❌ | ❌ |
| Row-level permissions | ◐ via filtered views (e.g. user column = me); view-only create #2901 | ✅ item-level | ◐ interfaces only | 💰 | ❓ | 💰 |
| Column-level permissions | ◐ read-only / mandatory per column per view | ❌ | ✅ | ❓ | 💰 | 💰 |
| Comments on rows | ❌ no issue yet | ✅ | ✅ | ✅ | 💰 | ✅ |
| Row history / audit trail | ◐ activity stream with changes; admin audit log 🚧 #3125 | ✅ version history | ✅ | ✅ | ✅ | ✅ |
| Notifications | ✅ (#2681); reminders on dates #1104 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Trash / restore deleted rows | ❌ archive for tables only | ✅ | ✅ | ❓ | ✅ | ✅ |
| Integration & automation | ||||||
| REST API | ✅ v1 + OCS v2; rows listing with filter, sort, search, paging #3095 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Webhooks / events | ✅ row events via Nextcloud webhooks (bug: #2132) | ✅ | ✅ | ✅ | ✅ | ✅ |
| Built-in automations | ❌ external only (Nextcloud Flow, n8n, Windmill) | ✅ rules, Power Automate | ✅ | ✅ | ✅ | ✅ |
| Scripting | ❌ | ◐ Power Automate | ✅ | ✅ | ❓ | ✅ Python, JS |
| Integration with other apps of the suite | ◐ Smart Picker, Analytics data source, unified search (tables only, rows #977), calendar event links (#3009); ❌ Forms can't store data in Tables (#2664) | ✅ Teams, SharePoint, Power Platform | ❌ no other internal apps | ❌ no other internal apps | ❌ no other internal apps | ❌ no other internal apps |
| Integration with 3rd party apps | ✅ API, webhooks, n8n | ✅ Power Platform | ✅ Marketplace | ✅ App store | ✅ Plugins, Zapier, n8n, Make | ✅ Integrations |
| Embed tables elsewhere | ◐ inside Nextcloud via Smart Picker; outside Nextcloud ❌ | ✅ | ✅ | ✅ | ✅ | ✅ |
| AI assistant (query, build, summarize) | ❌ no issue yet | ✅ Copilot | ✅ | ✅ | 💰 | ❓ |
| Import & export | ||||||
| Import CSV / XLSX / ODS | ✅ async with notification; extended report 🚧 #3071 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Import from Airtable / other tools | ❌ no issue yet | ❌ | ❌ | ✅ | ✅ | ❓ |
| Export | ◐ CSV (all, filtered, selected: #2485); export permission #2682; from/to Files #2859 | ✅ CSV, Excel | ✅ CSV | ✅ CSV, Excel | ✅ CSV, Excel, JSON, XML | ✅ |
| Structure export / import (schema) | ✅ table schemes (#2888); JSON Schema #3130 | ✅ list templates | ❓ | ❓ | ✅ | ✅ |
| App building | ||||||
| Bundle tables & views as an app | ✅ Applications; menu and grid pages 🚧 #3089, #3135, #3136, #3137, #3138 | ◐ Power Apps | ✅ Interfaces | ✅ | ✅ Application builder | 💰 Universal App |
| Add table/view as an app in top bar | ✅ | ❌ | ❌ | ❌ | ❌ | ❓ |
| Templates | ✅ six built-in | ✅ | ✅ | ❓ | ✅ | ✅ |
| Template directory | ❌ possibly use app store with a "Templates" category; template preview #1455 | ◐ built-in only | ✅ | ❓ | ✅ | ✅ |
| Platform | ||||||
| Large tables (10k+ rows) | ❌ all rows load into the browser; #2158, #1422, 🚧 #2242 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Mobile app | ◐ community Android app (not official); no iOS; mobile web #1414 | ❌ retired Nov 2025, mobile web only | ✅ | ❌ mobile web | ❌ mobile web | ◐ Android, iOS planned |
| Offline use | ◐ Android app only | ❌ | ❌ | ❌ | ❌ | ❌ |
| Self-hosting | ✅ | ◐ SharePoint Server | ❌ | ✅ | ✅ | ✅ |
| Open source | ✅ AGPL | ❌ | ❌ | ❌ source-available since Jan 2026 | ◐ MIT core, paid features proprietary | ◐ partly |
Additional notes
- Microsoft Lists is more specifically similar to Airtable or Tables. Its mobile apps were retired in November 2025.
- NocoDB moved from AGPL-3.0 to the Sustainable Use License (fair-code, not OSI open source) in January 2026.
- SeaTable is a partner organization of Seafile, but not fully open source: the Developer edition is free, but
dtable-serveris proprietary and row/column permissions and Universal Apps are Enterprise only (editions). - Baserow puts Kanban, Calendar, Timeline, row coloring and AI in its paid plans; the free plan has Grid, Form and Gallery.
- Google AppSheet is specifically for building apps from the data → version 2. But their interface and templates list might be helpful to check requirements.
- Microsoft Power Apps is very similar to Google AppSheet
- Anytype is related but very experimental
- Notion has interactive tables with different views
- Monday also does a lot of table-based organization
- AppFlowy is a Notion alternative which also has interactive tables
- Other apps in the no-code space https://www.producthunt.com/topics/no-code
Metadata
Metadata
Assignees
Type
Projects
- Status
Activity
jancborchardt commentedon Jan 18, 2023
@datenangebot these are the notes from our gap/market analysis, and we could see it as an ever evolving document. :) It seemed like you use SharePoint and/or Lists a bit more, so feel free to fill in the blanks too, or add links to issues.
juliusknorr commentedon Jan 24, 2023
One comment regarding the views is that there might have been some confusion about the wording. The comparison above lists views as different layouts (table/grid/form/kanban) however the planned approach for v2 as far as I understood @datenangebot was more to have views in terms of limiting/filtering visible/editable data for now. E.g. a view on a table could show only the entries created by yourself. For clarity this could mean for a vacation request process table you would have one view for your own vacation requests, the team lead could have a view to see all entries of the team members.
datenangebot commentedon Jan 24, 2023
Yes, Julius you are right. The "other" views thing I call view-mode and should be set in the view config later on.
The views are on the roadmap for v1, the view-modes for v2.
juliusknorr commentedon Jan 24, 2023
All right, thanks for clarifying 👍
almereyda commentedon Apr 20, 2023
For knowing about the FLOSS No code scene, feel free also have a look at what these do:
Edit: Adding relevant links as I find them.
[-]Tables market analysis[/-][+]Tables market gap analysis[/+]jospoortvliet commentedon Oct 26, 2026
@jancborchardt EDIT: updated the first post with newer feature gap analysis.