How to Use Spreadsheets in Confluence (Without Exporting to Excel or Google Sheets)

Confluence tables are fine. Until you need to do spreadsheet work — the kind you automatically reach for in Excel or Google Sheets. The catch is, Confluence doesn’t offer spreadsheet functionality out of the box. But this doesn’t mean you have to export anything.

In this guide, we’ll break down the main ways teams handle spreadsheets in Confluence and show a few practical workflows using third-party macros.

Key takeaways

• Native Confluence tables aren’t Excel: They don’t support spreadsheet-style formulas, calculations, and other familiar features.

• You have three main options for using spreadsheets in Confluence: embed external files with Smart Links, use a Marketplace spreadsheet app to work directly in Confluence, or choose a holistic app such as Table Filter, Charts & Spreadsheets for Confluence if you need real analysis and reporting, not just display.

• A super app like this covers the most common spreadsheet workflows in Confluence: creating and editing spreadsheets, importing an existing Excel file, converting native Confluence tables (including Jira work items) into spreadsheets, and reusing a spreadsheet across multiple pages within an instance.

Why would you need Excel-like spreadsheets in Confluence?

Because native Confluence tables only go so far, many teams end up needing Excel-like spreadsheets. Here are the most common scenarios where that comes up:

• You need formulas and calculations, not just a table that displays data.

• You rely on spreadsheet-only features Confluence tables can’t replicate, such as conditional formatting and dropdown lists.

• You prefer a predictable grid interface you already know.

• Your data is scattered across multiple Excel files and shared via email, so you want to consolidate it and improve team workflows.

• You need multiple people to contribute at the same time, without passing files back and forth or reconciling edits later.

• You need reliable versioning so it’s easy to see what changed and who changed it, and roll back if needed.

• You want spreadsheet data to sit alongside the project context (specs and documentation) rather than in a separate file.

• You want to analyze and present the data without exporting to Excel or Google Sheets, using things like filtering, pivots, and charts in the same workspace.

Overview of options for spreadsheets in Confluence

When teams say they need spreadsheets in Confluence, it usually comes down to whether they want to embed an external sheet, create spreadsheets directly in Confluence, or build a broader reporting workflow around their data.

Below is a quick overview of the three most common options, along with the downsides you should know upfront.

Option 1: Confluence’s Smart Links

If your spreadsheet already lives in Google Drive, OneDrive, or SharePoint, the fastest way is to paste its link into Confluence using a Smart Link so the content appears right on the page, without leaving the platform.

Downsides: Confluence doesn’t inherit permissions from non-Atlassian apps. A user needs to be logged in to Google or Microsoft 365 and have access to the embedded sheet to view it, which can create unwanted friction when sharing.

Option 2: Spreadsheet apps from the Atlassian Marketplace

There’s a growing category of Marketplace apps that focus specifically on giving Confluence an Excel-like interface. These can be useful for teams that want spreadsheets to live inside Confluence rather than as embedded external files.

Downsides: If you need broader reporting capabilities, you may end up stitching together multiple apps or workarounds and quietly making your Confluence admins hate you.

Option 3: A single super app that covers spreadsheets and much more

If you want a fully-fledged reporting toolkit without creating app sprawl, consider a Confluence app like Table Filter, Charts & Spreadsheets that provide a more holistic approach to data analysis and reporting.

In the spreadsheets lane specifically, you get three macros that cover most real-life scenarios:

• Table Spreadsheet: Creating and editing an Excel-like spreadsheet directly in Confluence.

• Spreadsheet from Table: Converting an existing Confluence table or a table generated by another macro (e.g., Jira work items) into a spreadsheet view.

• Table Spreadsheet Include: Reusing a range from one spreadsheet on other pages.

Downsides: It’s a powerful toolkit, which means it may take a bit of setup and learning, but it’s the good kind of complexity (the kind you only learn once, and it pays off).

How to work with spreadsheets in Confluence

Below are a few practical, day-to-day spreadsheet workflows teams run in Confluence when native tables aren’t enough, using macros from Table Filter, Charts & Spreadsheets for Confluence.

Create and edit an Excel-like spreadsheet

Use the Table Spreadsheet macro to add a spreadsheet to your Confluence page and work with it like you would in Excel. Use formulas, calculations, and other spreadsheet features you simply can’t recreate with native Confluence tables, like conditional formatting and dropdown lists for consistent data entry.

With the same macro, you can also import an existing Excel spreadsheet and continue with calculations in Confluence.

Turn a Confluence table or Jira work items into a spreadsheet inside Confluence

Wrap an existing Confluence table (or a table generated by another macro) in a spreadsheet view so you can run formulas, validate totals, and do quick analysis directly on the page, without rebuilding the data manually.

Here’s how to do it:

1. Add the Spreadsheet from Table macro to your Confluence page.

2. Place the source table inside the macro body, and it will be rendered as an Excel-like spreadsheet.

In the same way, you can insert a Jira work items table on a Confluence page, then convert that table into a spreadsheet so you can calculate, sort, and work with that data in a familiar Excel-like layout.

Reuse spreadsheet ranges across Confluence pages without copy-paste

Create one source spreadsheet and include specific sheets or cell ranges on other pages to keep dashboards and status pages in sync. Updates happen once in the master spreadsheet, and every included snippet changes in real time.

Here’s how it works:

1. Create a source spreadsheet on a Confluence page with the Table Spreadsheet macro and put your master data there.

2. On another page, insert the Table Spreadsheet Include macro.

3. In the macro settings, select the source spreadsheet and specify what to include (sheet and range).

Less exporting, more shared visibility

When spreadsheet work moves into Confluence, the biggest win is less hassle. The data stays on the same pages where your team plans and reviews progress, so you’re not exporting anything to Excel, emailing files around, or rebuilding the same view every time something changes. With the right setup, spreadsheets become part of your Confluence workflow: editable and reusable across pages.

FAQs

How do I add a spreadsheet in Confluence?

In practice, you can embed a spreadsheet in Confluence from Google Drive or Microsoft 365 using Smart Links, or add an Excel-like spreadsheet directly to a page using a third-party app such as Table Filter, Charts & Spreadsheets, which provides Confluence macros for spreadsheet functionality.

How do I create a spreadsheet in Confluence?

There’s no Excel macro out of the box, so if you want the spreadsheet to behave like Excel inside Confluence, create it on a page using an Excel-like macro such as Table Spreadsheet. If you already have the file in Google Sheets or Excel Online and only need to display it on the page, Smart Links are often the fastest path.

How do I create an Excel-like spreadsheet document in Confluence?

If you mean a spreadsheet that lives on the page (not just an attachment preview), create it directly on the platform using a Confluence spreadsheet macro. With Table Filter, Charts & Spreadsheets, this is typically done in Table Spreadsheet, which provides a familiar grid for formatting, structured data entry, and spreadsheet formulas in Confluence.

How do I edit an Excel spreadsheet in Confluence?

It depends on how the spreadsheet is added. If it’s embedded via Smart Links, you’re editing the source file in Google or Microsoft 365, and access is controlled there. If you add a spreadsheet directly on the page using an Excel-like macro (for example, Table Spreadsheet), you can edit cells, formulas, and formatting without leaving Confluence. If you’re converting an existing Confluence table into a spreadsheet view, Spreadsheet from Table is the macro typically used for that workflow.

How do I link a dynamic spreadsheet in Confluence?

If “dynamic” means the Confluence page should always show the latest version of an external file, Smart Links keep the embed tied to the source spreadsheet (as long as viewers can access it). If you want the data to live in Confluence but appear across multiple pages, a common approach is to maintain one source spreadsheet and reuse parts of it elsewhere. In Table Filter, Charts & Spreadsheets, this is what Table Spreadsheet Include is designed to do: show a selected sheet or cell range from a source spreadsheet on other pages.

How do I make a spreadsheet editable in Confluence?

To make it editable inside Confluence, you generally need an Excel-like spreadsheet macro, such as Table Spreadsheet, on the page rather than an embed. The Table Spreadsheet macro covers the “create and edit directly on the page” use case. If your starting point is a Confluence table or a table generated by another macro, Spreadsheet from Table gives you a spreadsheet view you can work with.

How do I use spreadsheets in Confluence?

Most teams end up using spreadsheets in Confluence in three workflows. They create and edit spreadsheets directly on pages with Table Spreadsheet, they convert existing tables into spreadsheet views with Spreadsheet from Table (including tables generated by other macros), and they reuse spreadsheet ranges across pages with Table Spreadsheet Include to keep dashboards and status pages consistent with a single source. These macros are available as part of the Table Filter, Charts & Spreadsheets for Confluence bundle.