How to create the table macro

Page view mode

Go to any Confluence page, then click the Excel-like Tables for Confluence icon at the top right menu. The app dialog will be displayed, and you choose how you want to create the table.

Page edit mode

In page edit mode, type ‘/excel’, then the Excel-like Tables macro will appear in the list.

Click the Excel-like Tables macro, and a new window will appear on your screen.

7 ways to create a table

1. Create from scratch

2. Create from templates

3. Upload from a file

4. Convert from Confluence table

5. From Excel-like Tables URL

6. Create from Jira Issue Sheets

7. Create from existing attachment

Option 1: By creating a new table from scratch.

If you choose the first option, the app will open the Excel-like Tables for Confluence app.

Option 2: Create from templates

If you choose the second option, you can create a table from pre-built templates or templates created by you or your team. You only can view the template if you have permission to view that page. Learn more about creating a new template here.

Option 3: Upload from a file

If you choose the third option, you can upload a file by ‘drag and drop’ it into the upload box. The app support .xlsx or .ssjon format.

Option 4: Convert from Confluence table

Directly convert your existing Confluence tables to Excel-like tables, making it easier for you to perform calculations and create charts from your existing data.

Option 5: From Excel-like Tables URL

If you want to reuse existing Excel-like tables for different purposes, simply copy the table URL then use that link to create a new one.

Option 6: Create from Jira Issue Sheets

You can also create a spreadsheet directly from your JQL query. Just define your query, apply the necessary filters, select your project, and you're all set. This allows you to pull precisely the data you need for deeper analysis, all in a matter of clicks!

Dive deeper into configuring your Jira Sheets Here.

Option 7: Create from existing attachment

Already have a CSV or Excel file attached to your Confluence page? You can turn that attachment into a fully interactive spreadsheet in seconds no need to re-upload or switch tools.

Editing a table created from an existing attachment does not modify the original file. Instead, it creates a separate copy of the data for in-page editing. This ensures your source file remains untouched.