Using Google Sheets in your pages
- Miguel Jesus
Learn how to add Google sheets to your Confluence pages.
About Google spreadsheets
Google spreadsheets are great for sharing information with your team, and with the Google Sheets app, you have everything in one place and always updated.
Expand/collapse preview
Show/hide toolbars
Advanced editing toolbars
Spreadsheet area
Adding a Google sheet to your page
Adding a Google sheet to your page is quite simple:
Copy the URL from the spreadsheet on the Google Sheets site;
On your Confluence page, enter edit mode;
Paste the URL
If you aren’t signed in yet, you’ll need to authenticate with your Google account to view the sheet content;
[Optional] Select the macro and click the edit button to make adjustments (you can edit this later);
Publish the changes.
All done. You can now view and edit your sheet on the Confluence page.
Authentication
All users must authenticate with a Google account to view and edit the spreadsheet on Confluence.
Layout options
You can edit the layout options at any moment. Select the macro in the page’s edit mode and click the edit button to change the layout options.
You're in control of the preview layout of your spreadsheet:
Width: You can define the width of the spreadsheet preview. The default is 100%.
Height: You can define the height of the spreadsheet preview.
Hide preview on load: If enabled, the spreadsheet loads when the page is open, but the preview is hidden. Users can click the chevron to open the preview.
Show toolbars: If enabled, editing toolbars are shown. Users can click the switch to hide the toolbars.
Layout options for publish mode:
Show headers: If enabled, column letters and line numbers are shown.
Show sheet tab: If enabled, the sheet tab is displayed.
Show interface: If enabled, the title and footer are displayed.
Removing a sheet from your page
To remove a spreadsheet from a page:
Enter the page edit mode;
Select the macro of the spreadsheet you want to delete;
Click the “Delete” button;
Publish the changes to the page.
All done. The spreadsheet won’t show anymore in your page but it’s still safe in Google Drive and you can add it again later if you need.
Wrap up
That's all about adding and using the Google Sheets app on your pages.
If you still have questions about any topics covered on this page, visit our support portal and send us your questions. Our team is always happy to help.