← All posts

BAMFLOW Sheet: turn NocoBase into a spreadsheet like Google Sheets (free plugin)

by BAMFLOW • • 7 min read • Updated 22 Oct 2026

A free, open-source plugin that opens every NocoBase table as a spreadsheet: smooth scrolling over millions of rows, in-cell editing, paste from Excel, filter – group – summarise, Kanban / Calendar / Form views — all within NocoBase permissions. Installation file and 24-page guide included.

sheet-cover

If you use NocoBase for day-to-day work, you have probably been here: you need to fix the price on a few dozen orders, change a status in bulk, or paste a column of figures from Excel — and you end up opening one form after another. NocoBase is excellent for building applications, but when you simply want to review and edit data quickly, the way you would in Google Sheets, the default forms and tables are not the fastest tool.

So BAMFLOW built BAMFLOW Sheet — a plugin that opens every NocoBase table as a spreadsheet, right inside NocoBase. It is free and open source under Apache-2.0, has no external dependencies and sends no data anywhere. The installation file and the illustrated user guide are at the end of this post.

What it does

  • Virtual grid: tables with millions of rows still scroll smoothly, and you can jump to any row in under a second — only the visible part is loaded.
  • Edit like Excel: click a cell and type, paste whole ranges from Excel / Google Sheets, drag the fill handle to continue numbers, dates or codes; 50-step undo / redo.
  • Saved views per table: nested filters, multi-column sort, 3-level grouping, hidden / frozen columns, row colours, footer aggregates — shared with the team or kept personal, and lockable.
  • Several view types: Grid, Kanban, Gallery, Calendar, Form, List.
  • Import / export: CSV import, CSV or Excel download that follows the current view, bulk update.
  • Public view links (read-only, with password and expiry) for partners who have no account — off by default.

Most importantly, every read and write goes through NocoBase permissions. Which tables a user sees and which fields they can edit is still decided by their role; workflows and the Created by / Updated by columns behave exactly as when editing through a form. Sheet never widens anyone's access.

Edit data like a spreadsheet

Click a cell and type to replace its value; Enter saves and moves down, Tab moves right, Esc cancels. Select a range and the status bar shows Count · Sum · Average just like Excel; Ctrl+C copies the range to Excel.

A 2×2 range selected in the Amount column: the status bar shows count, sum and average
A 2×2 range selected in the Amount column: the status bar shows count, sum and average
  • Paste from Excel: select a range in Excel or Google Sheets, Ctrl+C, click the top-left target cell in the grid, Ctrl+V. Numbers and dates are understood in both Vietnamese (1.234,5, 16/10/2026) and English formats. Paste past the last row and the plugin offers to add new rows.
  • Two save modes: Autosave writes as soon as you leave a cell; Batch marks edited cells with an orange corner and Ctrl+S writes them all in one transaction (one invalid cell and nothing is written).
  • No silent overwrites: if a colleague changed the same row after you loaded it, the cell flashes red and asks whether to reload or overwrite.
  • Create fields inside Sheet: administrators click the + after the last column to add text, number, single / multiple select with colours, date, link-to-table fields and more. The field is created through NocoBase's own collection API, so it works in every other block and form.

Filter, group, summarise — and save it as a view

A question like "which orders in the Hanoi branch are still unpaid?" takes a few clicks: Filter, pick field – operator – value, nest and / or groups up to 3 levels. Date fields offer relative dates (today, this week, last 7 days, last month…), user fields offer Me.

Filter Status is Paid — the row count in the status bar updates immediately
Filter Status is Paid — the row count in the status bar updates immediately

Need revenue by status? Group by Status and pick Sum in the footer of the Amount column. Aggregates cover every row that matches the filter, not just the visible ones: sum, average, min, max, median, % filled… Colour rows by a select field (e.g. Branch) or by a condition (e.g. Amount > 5,000,000).

Amount sorted descending, footer sum, the column menu and rows coloured by Branch
Amount sorted descending, footer sum, the column menu and rows coloured by Branch

All of that — columns, widths, filters, groups, colours, aggregates — is saved as a view. Each table can have as many views as you like, shown as tabs above the grid. Shared views are seen by the whole team; personal views are yours alone; lock an important view so only its creator and administrators can change its setup.

Kanban, Calendar, Form and more

Same table, different angle — click + View:

  • Kanban by a single-select field: drag a card to another column to change its status.
  • Calendar by month / week on a date field: drag an event to another day to reschedule it.
  • Gallery with cover images from an attachment field.
  • Form for internal data entry with only the fields you choose.
  • List with tall rows, good on phones; self-referencing tables show as a tree.
Kanban view by Status: one column per option with a card count, drag cards to change status
Kanban view by Status: one column per option with a card count, drag cards to change status
Calendar view by Order date: each order is an event, drag it to another day to change the date
Calendar view by Order date: each order is an event, drag it to another day to change the date

When to use it

SituationFeature
Review and fix prices or statuses on a few dozen ordersGrid — type in cells or paste a column from Excel
"Which orders in the Hanoi branch are unpaid?"Filter, saved as a reusable view
Revenue by status or by monthGroup + footer aggregates
Track order progressKanban view
Import a customer list from an old Excel fileSave as CSV UTF-8 → Import CSV
Let a partner see a list without editing itPublic view link (read-only, password)

Install in 4 steps

Requirements: NocoBase 2.2.21 and an administrator account. Works in both the /admin and /v/admin interfaces.

  1. Download bamflow-plugin-sheet-0.1.4.tgz at the end of this post.
  2. Sign in to NocoBase as an administrator → Plugin manager → Add & update → Upload plugin, choose the .tgz file → Submit.
  3. Find BAMFLOW Sheet in the list and switch it on.
  4. Open Settings → BAMFLOW → Sheet → Open Sheet, or go straight to /admin/bf-sheet.

By default only the root and admin roles can open Sheet; add other roles under Roles allowed to open Sheet on the settings page. The plugin adds no menu item on its own — if you want one, add a Link menu item pointing to /admin/bf-sheet.

No slowdown: until someone opens Sheet, each NocoBase page loads one extra shell file of about 6 KB. The Sheet interface itself (about 300 KB) is downloaded only the first time a user opens it.

To upgrade, upload the new .tgz through Add & update — no need to remove the old version; views and settings are kept.

Limits

  • Main data source (main) only.
  • CSV import up to 50,000 rows at a time, bulk update 5,000 rows, Excel download 20,000 rows.
  • On tables with hundreds of thousands of rows, filtering / sorting by an unindexed column can take a few seconds — Self-check in the settings suggests which columns to index.
  • Not yet: lookup / rollup columns, Timeline / map views, real-time collaboration, embedding Sheet as a block in a NocoBase page.

The plugin installation file and the 24-page user guide (in Vietnamese, with real NocoBase screenshots numbered where to click, a shortcut table and common errors):

Downloads

  • BAMFLOW Sheet plugin 0.1.4 (.tgz)Installation file for NocoBase 2.2.21 — Plugin manager → Add & update → Upload plugin · 155 KB · 63 downloads
    Download
  • BAMFLOW Sheet user guide (PDF, 24 pages, Vietnamese)Installation, settings and every feature, with numbered screenshots · 2.3 MB · 31 downloads
    Download

If you need help with installation, training or building a NocoBase system for your business, get a consultation or message us on Zalo at +84 986 238 723.


BAMFLOW Sheet is a free plugin under the Apache License 2.0, developed by BAMFLOW. NocoBase is a trademark of NocoBase Pte. Ltd.; this plugin is not an official NocoBase product. Excel is a trademark of Microsoft; Google Sheets is a trademark of Google.

BAMFLOW Solutions and Training Company Limited is an authorized NocoBase Partner, providing you with channel distribution and professional services based on NocoBase products. The service relationship between our company and you is negotiated and contracted independently between us. NocoBase does not supervise the service process and assumes no responsibility for our company’s service quality, project delivery, or after-sales support. For service-related inquiries, please contact our company directly.

Đọc bản tiếng Việt RSS