---
id: video/1QuV_vkbNVU
type: video
title: Introducing Spreadsheets for Business Central
summary: Demo of spreadsheets in the advanced spreadsheet and reporting app for Business Central (expanded from the advanced financial reporting app). It covers Excel-like cells with BC functions (TODAY, WORKDATE, CALCDATE) and regions that connect BC data (tables with write-back, charts, queries, budgets, pages for preview and print). It also covers virtual fields, read-only or edit sharing permissions, and a bring-your-own-key AI agent that builds SQL query regions.
tier: community
language: en
tags:
  - spreadsheets
  - regions
  - data connectivity
  - virtual fields
  - charts
  - permissions
  - ai agent
  - queries
  - excel integration
  - preview mode
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:18:12.449Z"
  flags: []
generated:
  at: "2026-10-07T23:18:12.542Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 8841942ce73542a4732b1a6a020c22bafabfa45d46da8522cb686c27a50ae70a
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=1QuV_vkbNVU&t=13s
    title: Introducing Spreadsheets for Business Central
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 13
    quote: a spreadsheet that is running inside Business Central and it's a spreadsheet that have Business Central in it
  - kind: video
    url: https://www.youtube.com/watch?v=1QuV_vkbNVU&t=23s
    title: Introducing Spreadsheets for Business Central
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 23
    quote: we have expanded our financial advanced financial reporting app to also include the spreadsheet.
  - kind: video
    url: https://www.youtube.com/watch?v=1QuV_vkbNVU&t=90s
    title: Introducing Spreadsheets for Business Central
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 90
    quote: I operate this exactly like you I would type this exactly the same way as I would do it in Excel
  - kind: video
    url: https://www.youtube.com/watch?v=1QuV_vkbNVU&t=211s
    title: Introducing Spreadsheets for Business Central
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 211
    quote: A region is where we connect Business Central directly into the into the spreadsheet
  - kind: video
    url: https://www.youtube.com/watch?v=1QuV_vkbNVU&t=462s
    title: Introducing Spreadsheets for Business Central
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 462
    quote: Very important. So, you can configure whether a user have permissions to to use the right back functionality or not
links:
  learn: []
  objects:
    - object/table/3
    - object/table/18
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: 1QuV_vkbNVU
channel: yt-hougaard
source_name: Erik Hougaard
url: https://www.youtube.com/watch?v=1QuV_vkbNVU
published_at: "2026-09-21T19:14:15.000Z"
duration_s: 1006
captions: derived
audience:
  - functional consultant
  - administrator
  - end user
  - developer
chapters:
  - t: 0
    title: Introduction to spreadsheets in Business Central
  - t: 50
    title: Excel muscle memory and spreadsheet basics
  - t: 116
    title: Business Central functions and cell formatting
  - t: 199
    title: Regions and data connectivity types
  - t: 338
    title: Working with tables and editing data
  - t: 487
    title: Virtual fields and calculations
  - t: 631
    title: Charts and page regions for presentation
  - t: 753
    title: Sharing and permissions management
  - t: 816
    title: AI agent for query generation
  - t: 951
    title: Additional features and access information
features:
  - name: Spreadsheets for Business Central
    status: unclear
    t: 0
    verified: false
    status_source: video
  - name: Regions
    status: unclear
    t: 211
    verified: false
    status_source: video
  - name: Virtual Fields
    status: unclear
    t: 511
    verified: false
    status_source: video
  - name: Page Regions
    status: unclear
    t: 700
    verified: false
    status_source: video
  - name: Permissions and Sharing
    status: unclear
    t: 792
    verified: false
    status_source: video
  - name: AI Agent
    status: unclear
    t: 827
    verified: false
    status_source: video
  - name: Chart Regions
    status: unclear
    t: 631
    verified: false
    status_source: video
  - name: Business Central Functions
    status: unclear
    t: 126
    verified: false
    status_source: video
  - name: Scenarios
    status: unclear
    t: 961
    verified: false
    status_source: video
  - name: Conditional Formatting
    status: unclear
    t: 973
    verified: false
    status_source: video
objects_mentioned:
  - table Payment Terms
  - table Posted Sales Headers
  - table Customer
  - table Ledger Entries
quotes:
  - t: 13
    text: a spreadsheet that is running inside Business Central and it's a spreadsheet that have Business Central in it
    check: exact
  - t: 23
    text: we have expanded our financial advanced financial reporting app to also include the spreadsheet.
    check: exact
  - t: 90
    text: I operate this exactly like you I would type this exactly the same way as I would do it in Excel
    check: exact
  - t: 211
    text: A region is where we connect Business Central directly into the into the spreadsheet
    check: exact
  - t: 462
    text: Very important. So, you can configure whether a user have permissions to to use the right back functionality or not
    check: exact
---

# Introducing Spreadsheets for Business Central

> Demo of spreadsheets in the advanced spreadsheet and reporting app for Business Central (expanded from the advanced financial reporting app). It covers Excel-like cells with BC functions (TODAY, WORKDATE, CALCDATE) and regions that connect BC data (tables with write-back, charts, queries, budgets, pages for preview and print). It also covers virtual fields, read-only or edit sharing permissions, and a bring-your-own-key AI agent that builds SQL query regions.

[Watch on YouTube](https://www.youtube.com/watch?v=1QuV_vkbNVU) · Erik Hougaard · 2026-09-21 · 16:46 · tier community · reviewed (checked by Opus)

## Overview

Erik Hougaard introduces a spreadsheet that runs inside Business Central and keeps Excel-style typing and formulas. Business Central data is brought in through regions, which can be tables, charts, financial reports, pages, KPI cards, budgets, queries, reports, pivot tables, flow fields, images and journals.

The demo covers Business Central date functions in cells (TODAY, WORKDATE, CALCDATE), editing table data, virtual fields with formulas, chart regions, and page regions for preview and printing. It also covers sharing with read-only or edit access, and an AI agent that builds queries from natural language using a bring-your-own-key AI provider. The video states it is free to use in a cloud sandbox.

## Key points

- A region is how Business Central data is connected into the spreadsheet; region types include table, chart, financial report, page, KPI card, budget, query, report, pivot table, flow field, image and journal.
- Cells support the Business Central functions TODAY, WORKDATE and CALCDATE.
- Virtual fields add formula columns to a table region without changing the underlying Business Central table.
- Page regions define what is printed and shown in preview mode; content outside them is not included.
- Sharing can be read-only or full edit. Writing data back requires the user to have the permission configured.
- The AI agent generates SQL queries and regions from natural language. It needs an AI provider configured with bring-your-own-key (Anthropic Claude, Azure OpenAI, Chat, Grok and Google are named).
- Scenarios (freeze a sheet state and revert to saved scenarios) and conditional formatting are mentioned. The video says the app is free in a cloud sandbox.

## Chapters

- [0:00](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=0s) Introduction to spreadsheets in Business Central
- [0:50](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=50s) Excel muscle memory and spreadsheet basics
- [1:56](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=116s) Business Central functions and cell formatting
- [3:19](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=199s) Regions and data connectivity types
- [5:38](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=338s) Working with tables and editing data
- [8:07](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=487s) Virtual fields and calculations
- [10:31](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=631s) Charts and page regions for presentation
- [12:33](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=753s) Sharing and permissions management
- [13:36](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=816s) AI agent for query generation
- [15:51](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=951s) Additional features and access information

## Features

| Feature | Status | At |
|---|---|---|
| Spreadsheets for Business Central | status not stated, demoed | [0:00](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=0s) |
| Regions | status not stated, demoed | [3:31](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=211s) |
| Virtual Fields | status not stated, demoed | [8:31](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=511s) |
| Page Regions | status not stated, demoed | [11:40](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=700s) |
| Permissions and Sharing | status not stated, demoed | [13:12](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=792s) |
| AI Agent | status not stated, demoed | [13:47](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=827s) |
| Chart Regions | status not stated, demoed | [10:31](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=631s) |
| Business Central Functions | status not stated, demoed | [2:06](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=126s) |
| Scenarios | status not stated | [16:01](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=961s) |
| Conditional Formatting | status not stated | [16:13](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=973s) |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- [table 3 "Payment Terms"](../objects/table/3.md) at [3:44](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=224s)
- table "Posted Sales Headers" at [14:52](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=892s)
- [table 18 "Customer"](../objects/table/18.md) at [15:06](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=906s)
- table "Ledger Entries" at [15:06](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=906s)

Not found in BC28-30: table "Posted Sales Headers", table "Ledger Entries".

## Quotes

- [0:13](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=13s) "a spreadsheet that is running inside Business Central and it's a spreadsheet that have Business Central in it"
- [0:23](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=23s) "we have expanded our financial advanced financial reporting app to also include the spreadsheet."
- [1:30](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=90s) "I operate this exactly like you I would type this exactly the same way as I would do it in Excel"
- [3:31](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=211s) "A region is where we connect Business Central directly into the into the spreadsheet"
- [7:42](https://www.youtube.com/watch?v=1QuV_vkbNVU&t=462s) "Very important. So, you can configure whether a user have permissions to to use the right back functionality or not"

Presenters (as heard): Eric.