Versions Compared

Old Version 4

changes.mady.by.user Miguel Jesus

Saved on

compared with

New Version 5

changes.mady.by.user Miguel Jesus

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
nameintro

Learn how to add Google sheets to your Confluence pages.

Table of Contents

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.

GSheets-using 1.png

  1. Expand/collapse preview

  2. Show/hide toolbars

  3. Advanced editing toolbars

  4. 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;

    GSheets-start 2.png

  • [Optional] Select the macro and click the edit button to make adjustments (you can edit this later);

  • Publish the changes.

Tip

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.

GSheets-start 3.png

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.

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;

    GSheets-using 2.png

  • Publish the changes to the page.

Tip

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.