How to create the table macro
From Edit Page
To create a table, open a macro and search for Excel-like Tables.
![](../__attachments/4121067796/image-20231016-010812.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
Click the Excel-like Tables macro, and a new window will appear on your screen.
![image-20240528-095243.png](../__attachments/4121067796/image-20240528-095243.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
4 ways to create a table
By creating a new table from scratch.
Upload from a file.
Convert from Confluence table.
Create from existing Excel-like Tables URL
Option 1
If you choose the first option, the app will open the Excel-like Tables for Confluence app.
![](../__attachments/4121067796/image-20231016-010433.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
Option 2
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.
![ConvertFile.gif](../__attachments/4121067796/ConvertFile.gif?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
Option 3
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.
![ConvertTable.gif](../__attachments/4121067796/ConvertTable.gif?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
Option 4
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.
![ETC URL final.gif](../__attachments/4121067796/ETC%20URL%20final.gif?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
Once you have done with editing works, click the save icon at the top right to save, and the exit button to go back to your Confluence page.
![](../__attachments/4121067796/image-20231016-011214.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
The saved macro will shown on your Confluence edit screen, click Publish to view the Excel-like Tables.
![](../__attachments/4121067796/image-20231016-011041.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
Now you can see your Excel-like Tables on your Confluence page.
![](../__attachments/4121067796/image-20231016-011253.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
If you want to perform a quick simple update to the table, you can also edit your tables from the view mode.
From View Page
If you want to add a table directly from the view page, you can navigate your cursor to the top right menu button, and select Excel-like Tables
sub-menu
![Screenshot 2024-02-06 at 1.58.10 AM.png](../__attachments/4121067796/Screenshot%202024-02-06%20at%201.58.10%20AM.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
It will then prompt a dialog for the user to create a table,
![image-20240205-180116.png](../__attachments/4121067796/image-20240205-180116.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)
Click on Create and wait for the system to add a new table to your confluence page
![image-20240205-180236.png](../__attachments/4121067796/image-20240205-180236.png?inst-v=e7cfb899-2364-4b8c-bb82-56cd5c2b91e4)