Skip to content
All posts

Confluence11 min readYamuno Team

Create a Confluence Table from Excel, and Export It Back

Create a Confluence Table from Excel, and Export It Back

Short answer: The quickest way to create a Confluence table from Excel is to copy the cells in Excel and paste them into a Confluence Cloud page while you edit it. Confluence turns the range into a native table you can edit, sort and extend. If Excel should stay the master copy, attach the workbook or embed it from Excel on the web instead, and if the data is a list of records, import it as a CSV into a Confluence database.

Which one to use depends on what happens to the data after today. This guide covers all four routes, the table tools you need once the data is in, and how to get a table back into Excel, which Confluence has no button for.


Four ways to get Excel data into Confluence

Route What you get Who keeps it current Best for
Paste the cells A native Confluence table People editing the page Snapshots, small reference tables, decisions
Attach the workbook The file on the page, with a preview Whoever owns the file Workbooks with formulas or many sheets
Embed from Excel on the web The live workbook inside the page People editing in Excel Trackers the team keeps working on in Excel
Import a CSV into a database Structured records with views People editing the database Inventories, registers, lists with fields

A common mistake is pasting a sheet that the team keeps updating in Excel. A week later the page and the workbook disagree, and nobody knows which one is right. Paste when Confluence will become the home of the data. Attach or embed when it won't.

Paste a range as a table

  1. In Excel, select the cells you want, including the header row, and copy them with Ctrl + C (Cmd + C on a Mac).
  2. Open the Confluence page and select Edit.
  3. Put the cursor on an empty line and paste with Ctrl + V (Cmd + V).
  4. Confluence creates a table with one row per Excel row. Check the first row, then publish.

The same works from Google Sheets and from Excel on the web.

What comes across is the cell values as Excel displays them. Formulas become their results, so a total is pasted as a fixed number and won't update if you change a cell above it. Number formats come over as text, which is usually what you want for dates and currency. Most styling doesn't survive the paste, conditional formatting included, and merged cells can arrive split or misaligned. Pasting hyperlinked cells is hit and miss, so check links after the paste.

If the paste lands as plain text instead of a table, you probably copied from a cell in edit mode or pasted into an existing table cell. Press Esc in Excel so the range is selected rather than one cell's text, and paste on an empty line outside any table.

Clean up the table after pasting

A pasted table needs a minute of tidying before it is easy to read:

  • Header row. Select the table and use the table options in the floating toolbar to turn on the header row style, so the first row is shaded and bold. In long tables the header stays visible as readers scroll.
  • Column widths. Drag the column borders, or select columns and choose Distribute columns to make them equal. Turn on Fixed column widths if you don't want widths to change as people type.
  • Table width. Use the resize handle on the right edge, or switch between the centred, wide and full-width sizes.
  • Numbered column. Turn it on from the table options when people refer to rows by number in comments.
  • Cell colour. Select cells and pick a background colour from the cell menu to flag status. Keep it to one or two colours that mean something.

Add rows, columns and sorting

These are the tools people search for most once a table exists:

  • Add a row at the bottom: put the cursor in the last cell and press Tab.
  • Add a row above or below: Ctrl + Alt + Up or Ctrl + Alt + Down (Cmd + Option + Up or Down on a Mac), or use Add row above and Add row below from the row handle.
  • Add a column left or right: Ctrl + Alt + Left or Right (Cmd + Option on a Mac), or Add column left and Add column right from the column handle.
  • Insert from the edge: hover over the line at the left of a row or the top of a column and select the plus sign that appears.
  • Sort: select the column handle and choose ascending or descending.
  • Move a row or column: drag it by its handle. Hold Shift to select several.
  • Merge cells: select the cells and choose Merge cells from the cell menu. Split cells undoes it.

To start a table from scratch instead, type /table in the editor. You get three columns and three rows with a header row, and Table size in the toolbar changes that.

Attach the workbook instead

When the workbook has formulas, several sheets or charts, a pasted table throws most of it away. Attach the file instead: drag the .xlsx file onto the page while you edit it. Confluence shows it as a file card or a thumbnail, and readers can open a full-screen preview or download it.

The Office Excel macro goes one step further and shows a rendering of the attached workbook in the page, with a selector for the sheet. Use it when readers need to see the numbers without opening the file. Both options show the file as it was when it was uploaded: to update the page, upload a new version of the attachment with the same name.

Embed the live workbook

If the workbook lives in OneDrive or SharePoint and people keep working on it in Excel, embed it so the page always shows the current version.

Pasting a OneDrive link gives you a Smart Link, and if Confluence offers the Embed view for it, readers see the file in the page with their own Microsoft access. For a frame you can size and caption, use Excel on the web: open the workbook, choose File > Share > Embed, and copy the src address from the code it gives you. Our guide to embedding an iframe in Confluence covers the iFrame macro and why an embed sometimes shows up blank.

HTML Macro+ for Confluence has an embed template for this. Type /html, open Embed templates, pick Microsoft 365 file, paste the src address, and the app writes a responsive frame that follows Confluence's light or dark theme. You can add a caption or put the workbook next to a chart in the same macro. The embed templates guide lists the link each service needs.

An embedded workbook is only as visible as its sharing settings allow. If readers can't open the file in Microsoft 365, they won't see it in Confluence either.

Import a CSV into a Confluence database

When the sheet is really a list of records, such as a vendor list, an asset register or a risk log, a Confluence database fits better than a table. Each column becomes a field, and you get views, filters and per-field types.

  1. In Excel, choose File > Save As and pick CSV UTF-8. Only the current sheet is saved.
  2. In Confluence, create a database, open the ••• menu and choose Templates and import.
  3. Under Import, upload the CSV and confirm.

Two things to check after the import: dates are not detected as date fields automatically, and they are read month first, so a UK date such as 03/11 becomes March 11. Set the field types and spot-check a few rows.

Export a Confluence table back to Excel

Confluence Cloud has no export button for a single table on a page. What works:

  • Copy and paste. View the page (not in edit mode), select the table from the first cell to the last, copy, and paste into Excel. Simple tables come across cleanly. Merged cells, macros inside cells and images do not.
  • Database export. If the data is in a Confluence database, open the ••• menu and choose Export. CSV is the option meant for spreadsheets; HTML and PDF are there too.
  • Keep Excel as the source. If people need the data in Excel every week, that is a sign the attach or embed route fits better than a pasted table.

For pages full of tables that go to people outside Confluence, a PDF export is often what they actually want. See how to export Confluence to PDF for the options.

Turn the table into a chart

Once the numbers are in Confluence, the built-in Chart macro can draw them. Insert it with /chart, put a table of your data inside the macro, and choose pie, bar, line or area as the type. Fill empty cells with 0, because blank cells cause errors. Our guide to making a pie chart in Confluence walks through the chart macro and an interactive alternative.

If your tables come out of a script or a docs repository as Markdown, you don't need Excel in between at all. Markdown Importer for Confluence converts Markdown tables, including column alignment, into native Confluence tables; see how to import Markdown into Confluence. Teams that keep reference tables in Confluence long term may also like our technical documentation setup.

Frequently asked questions

Can I import an Excel file as a Confluence table?

Not directly. Confluence has no Excel import for pages. Copy the cells and paste them into the editor, which creates a native table. To keep the file itself, attach it or embed it from Excel on the web. To turn rows into records, save the sheet as CSV and import it into a Confluence database.

Why does my pasted table lose formatting or formulas?

Confluence tables hold values, not formulas, so a pasted formula becomes its result. Conditional formatting and most cell styles don't carry over either. Add header styles and cell colours in Confluence after pasting, or attach the workbook if the formulas matter.

How do I add a row to a Confluence table?

Press Tab in the last cell to add a row at the bottom. Elsewhere, press Ctrl + Alt + Down (Cmd + Option + Down on a Mac) to add a row below the current one, or use Add row below from the row handle.

How do I export a Confluence table to Excel?

Open the page in view mode, select the whole table, copy it and paste it into Excel. There is no native export for a single table. Data in a Confluence database can be exported as CSV from its ••• menu.

Can a Confluence table update when the Excel file changes?

A pasted table can't. It is a copy. To show current numbers, embed the workbook from Excel on the web or OneDrive, or attach it and upload a new version when it changes.

Is there a size limit for tables pasted from Excel?

Atlassian doesn't publish a row limit for tables, but very large tables make the editor slow and the page hard to read. For more than a few hundred rows, attach the workbook or use a database.

Try it

Copy a small range from Excel, paste it into a test page, then turn on the header row and press Tab in the last cell to see how the table grows. If the sheet is one your team keeps updating, embed it instead: HTML Macro+ for Confluence turns an Excel on the web link into a responsive frame in a couple of clicks.

Related articles

All posts