UPCOMING WEBINAR: Build it once. Use it again: Create reusable charts with AI Register now >>

Articles in this section

See more

How to Export a Document to Google Slides

  • Updated
Follow

Displayr can export charts and tables to Google Slides as native Google objects you can edit directly. The export creates a deck in your Google Drive, plus a Google Sheet that holds the chart and table data.

This article describes how to go from a Displayr document...

ExportToGoogleSlides_Displayr.png

...to Google Slides. 

ExportToGoogleSlides_GoogleSlides.png

NOTE: Some exported slides will not match Displayr one-to-one. The Google Slides and Google Sheets APIs don't support some Displayr chart options and will use the Google default instead. See Caveats and Limitations When Exporting From Displayr to Google Slides for more information.

This article is broken into the following sections:

If you would like to export data tables to Google Sheets, please see How to Export Displayr Tables to Google Sheets.

Requirements

  • A Displayr document with at least one output to export.
  • A Google account.

Method

  1. Select the page(s) or standalone output(s) to export in the Report tree.
  2. Go to Share > Export Report > Google Slides.
  3. Update Choose which pages/outputs to export to Export Selected if you want to export only the selected items. Otherwise, leave it set to Export All to export all items in the Report tree.
  4. If this is the first time you are exporting to Google Slides from Displayr, click Connect Google account and follow the prompts to allow Displayr to connect to your Google account.
  5. Click Export.
  6. When the export finishes, a report dialog links to the deck and its associated Google Sheet. It also lists any warnings about the export.

See Caveats and Limitations When Exporting From Displayr to Google Slides if some slides don't appear as expected.

If you want to disconnect your Google account from Displayr, go to Share > Export Report > Google Slides and click Google account > Disconnect.

Export as editable Google Slides

By default, visualizations with matching Google Slides chart types will be exported as editable visualizations to Google Slides. To ensure this, you can check the settings:

  1. Select the visualization(s) on a page or in the Report tree.
  2. From Properties26UI_ObjectInspector.png, update Appearance > Google Slides Export > Format to Native.
  3. Update Export as to Match Displayr or another chart type.
  4. OPTIONAL: Click Set as Default to make this the default exporting option for visualizations.

Tables will always export as editable tables.

See Caveats and Limitations When Exporting From Displayr to Google Slides when exporting from Displayr to Google Slides as editable Google Slides.

Export visualization(s) as an image (to match what is seen in Displayr)

To export visualizations as an image, i.e., WYSIWYG (what you see is what you get) to Google Slides, you can:

  1. Select the visualization(s) on a page or in the Report tree.
  2. From Properties26UI_ObjectInspector.png, update Appearance > Google Slides Export > Format to Image.
  3. OPTIONAL: Click Set as Default to make this the default exporting option for visualizations.

Tables will always export as editable tables.

Update existing Google Slides

Exporting the same document using the steps above overwrites the Google Slides from an earlier export. The earlier export stays available in the Google Slides version history.

Technical Information

  • The slides go into a folder named after the document, inside a Displayr folder at the top of your Google Drive. Both files (Google Slides and the Google Sheet) are named after the document.
  • Exporting to Google Slides from View mode is not currently available.
  • Charts become native charts built in the Google Sheet, with one tab per chart. Each slide chart stays linked to its tab, so readers can refresh the chart from the sheet in Google Slides.
  • Chart colors, fonts, axes, labels, and legends follow the Displayr settings where Google Charts has a matching setting.
  • Tables become native Google Slides tables. To keep exports fast, tables with more than 400 cells, or more than 75 rows or columns, are cut to the first 20 rows and 20 columns. The report warns you in the exporting dialog when a table is cut.
  • Text boxes become native Google Slides text, with bullets, links, spacing, vertical alignment, and shrink-to-fit kept.
  • Shapes, lines, and arrows become native Google Slides shapes, so you can edit them.
  • Items with no native Google equivalent export as pictures. A chart whose export setting was updated away from a chart also exports as a picture.
  • Page master items appear on every slide that uses that layout.
  • If an item fails to export, it is left out and listed in the export dialog warnings. The rest of the deck still exports. If the whole export fails, Displayr deletes the partial deck and sheet.
  • See Caveats and Limitations When Exporting From Displayr to Google Slides for more notes about differences in exports between Displayr and Google Slides.

Canceling the export

Sometimes you may need to cancel your export. Often, the export finishes before you realize it, but for larger, more complex reports, you can cancel the export by clicking Cancel in the export dialog.

Next

Caveats and Limitations When Exporting From Displayr to Google Slides

How to Export Displayr Tables to Google Sheets

Publishing to Excel, PowerPoint, and as a PDF

How to Create and Apply a Chart Template in Displayr

Related articles