Export a sheet or report

In the Smartsheet app, you can export any sheet or report to the following formats:

• Microsoft Excel
• Image (PNG) (Gantt Chart Only)
• Google Sheets
• Microsoft Project (Gantt Chart Only)
• PDF

After exporting a sheet or report, your browser will save it on your computer. It’ll store the file you exported in a folder based on your browser settings.

Not everything is included with your export. Groupings and summary rows are excluded and attachments are dropped. To include attachments,create a backup of the sheet instead.

To quickly locate the exported file, open the Downloads folder on your browser. Use the keyboard shortcut Crl+J on Windows or Command+Option+L on macOS.

Use Send as Attachment to generate recurring exports

To send yourself or others a PDF or Excel version of your sheet or report through email on a recurring schedule, see the following help articles:

• Send the entire sheet or report through email as a PDF or Excel (.xls) attachment.

• Share a Report as an Attachment in Email

---

Export to Microsoft Excel

To export any sheet or report from Smartsheet for use in Microsoft Excel, selectFile>Export>Export to Excel.

The exported data may not appear in Excel exactly as it does in Smartsheet. Here is a list of some key differences:

• Gantt charts are excluded:Excel doesn’t support a Gantt chart format. Exporting a Gantt chart to Excel will export only the task list it’s based on.
• Formulas are not preserved:Due to the differences between Excel and Smartsheet formula syntax, formulas aren’t preserved on export.
  To work around this, remove the equal sign at the beginning of the formulas to store them as texts, and then save the sheet. Once you open the Excel file, you can add the equal sign back and modify the syntax to make the formulas work in Excel.
• Comments and sheet summaries appear on separate tabs in the exported workbook
• Reports are limited to 20,000 rows:If your report has more than 20,000 rows, you can create multiple reports that pull in fewer rows and export each report as a separate Excel file. For more information about working with reports, seeCreating Reports.
  If a sort was applied to your report, fewer than 20,000 rows may be exported.
• Not all column types are supported in Excel:Excel doesn’t support Dropdown, Contact List, Checkbox, and Symbols ( Harvey Balls, etc.) columns. When you export sheets that use these column types, only text values will be exported. Values in Boolean column types (Checkbox, etc.) will be exported asTrueorFalse, according to the state of the item in the cell.

---

出口到图像(PNG格式)

To export any sheet or report that includes a Gantt chart to a PNG format, follow these steps:

1. Open the sheet you want to export.
2. On the toolbar, switch the sheet or report toGantt View.
3. SelectFile>Export>Export Gantt to Image (PNG).
4. In theSelectionsection of theExport Gantt to Image (PNG)form, choose to export the entire sheet or selected rows.
   • If theSelected Rowsoption isn’t available, close theExport Gantt to Image(PNG)form, select the rows to print, and then reopen the form.
5. In theOptionssection, select which columns to include in the image.
   • By default, only the Primary Column is included, but you can select thePrimary Columnname—or theEditbutton—to include additional columns.

Customize the printed timeline in your image export

If you use aCustom Date Range, the time span shown depends on your Timeline Display choice. For example, in theProject Settingsform, you set thePrimary headingof your timeline display toYears. You also choseMarch 1as your start date andJune 30as your end date. The PDF will show a complete year because of your timeline choice.

To narrow the printed timeline, in theTimeline Displaytab of theProject Settingsform, change thePrimary headingchoice toQuartersorWeeks. For more information, seeModify Dependency and Gantt Settings.

---

Export to a Google Sheet

To export any sheet or report from Smartsheet to Google Sheets, selectFile>Export>Export to Google Sheets.

Similar to files exported in Excel, files exported to Google Sheets won’t appear exactly as it does in Smartsheet. Here’s a list of key differences:

• Gantt charts are excluded:Google Sheets doesn’t support a Gantt chart format. Exporting a Gantt chart to Google will export only the task list.
• Not all column types are supported in Google Sheets:Similar to Excel, Google Sheets doesn’t support Dropdown, Contact List, Checkbox, and Symbols (Harvey balls, etc.) columns. When you export sheets that use these column types, only text values will be exported. Values in Boolean columns (Checkbox, etc.) will be exported asTrueorFalse, according to the state of the item in the cell.
• Sheet summaries appear on a separate tab in the exported workbook
• Formulas are not preserved on file exports:Smartsheet’s formula syntax differs from Google Sheets.
  To work around this, remove the equal sign at the beginning of the formulas to store them as texts, and then save the sheet. Once you open the Google Sheet, you can add the equal sign back and modify the syntax to make the formula work in Google Sheets.
• To revoke Smartsheet's access or change the Google account you're exporting to, see Google's instructions toremove site or app access.

Can’t find your download? Check your personal Google Drive. That’s where Smartsheet places your export(s).

---

Export to Microsoft Project

Any sheet that includes a Gantt chart can be exported to Microsoft Project format. This option is not available for reports.

1. Open the sheet you want to export.
2. On the toolbar, switch the sheet toGantt View.
3. To download the sheet in XML format, selectFile >出口>出口女士Project.
4. To import the XML file, open Microsoft Project.

Because Smartsheet and Microsoft Project differ in their functionality, the exported sheet may display differently in either application. In these cases, you may want tocopy data from one program, and paste it into the otherusing keyboard shortcuts Ctrl+C and Ctrl+V (Windows) or Command+C and Command+V (macOS).

---

Export to PDF

To export a sheet or a report to PDF format, selectFile>Export>Export to PDF.

When exporting a sheet or a report to PDF format, you can set up its layout, and choose which columns to include.

In theOptionssection of thePDF Setupform, you can’t choose which columns to include in the PDF file if your sheet or report isn’t in Gantt View. Learn more about creating a printable PDF in thePrint a sheet or report from Smartsheethelp article.