Comments and sheet summaries appear on separate tabs in the exported workbook.

Once you open the Excel file, you can add the equal sign back and modify the syntax to make the formulas work in Excel. To work around this, remove the equal sign at the beginning of the formulas to store them as texts, and then save the sheet. Formulas are not preserved: Due to the differences between Excel and Smartsheet formula syntax, formulas aren’t preserved on export.Exporting a Gantt chart to Excel will export only the task list it’s based on. Gantt charts are excluded: Excel doesn’t support a Gantt chart format.The exported data may not appear in Excel exactly as it does in Smartsheet. To export any sheet or report from Smartsheet for use in Microsoft Excel, select File > Export > Export to Excel. Send the entire sheet or report through email as a PDF or Excel (.xls) attachment. 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: Use Send as Attachment to generate recurring exports Use the keyboard shortcut Crl+J on Windows or Command+Option+L on macOS.

To quickly locate the exported file, open the Downloads folder on your browser.

To include attachments, create a backup of the sheet instead. Groupings and summary rows are excluded and attachments are dropped. Not everything is included with your export. It’ll store the file you exported in a folder based on your browser settings. In the Smartsheet app, you can export any sheet or report to the following formats:Īfter exporting a sheet or report, your browser will save it on your computer.

Convert pdf chart to excel