Export, preview, create templates, and more with these Google Sheets URL parameters.

Google Sheets has several built-in URL parameters similar to Google Docs that allow you to perform various helpful tasks to save time. The following is intended to be a reference guide for these URL parameters.

The following examples require the URL format https://docs.google.com/spreadsheets/d/SHEET_ID where SHEET_ID is the sheet ID.

Export

/export?format=pdf - Export the sheet as a PDF document.

/export?format=xlsx - Export the sheet as an Excel document.

/export?format=ods - Export the sheet as an OpenDocument spreadsheet.

/export?format=csv - Export the sheet as a Comma Separated Values document (first-sheet only).

/export?format=tsv - Export the sheet as a Tab Separated Values document (first-sheet only).

/export?format=zip - Export the document as a (zipped) HTML document.

/export?format=[type]&gid=[id] - Export a specific sheet. Replace [type] with the desired export type and [id] with the sheet gid.

Preview

/preview - Preview the document without the title and grid numbers.

Edit

/edit?rm=minimal - Edit the sheet without the title, menu or toolbar.

/edit?rm=demo - Edit the sheet with a toolbar.

/edit?rm=embedded - Edit the sheet with a menu and toolbar.

Mobile

/htmlview - View the sheet in mobile view.

Copy

/copy - Copy the sheet.

/copy?copyComments=true - Copy the document with sheet.

/copy?userstoinvite=email1,email2 - Copy the document and invite users to edit.

/copy?copyDestination=FOLDER_ID - Copy the document to a specific folder.

/copy?title=NewTitle - Copy the document with a new title.

/copy?copyCollaborators=false - Copy the document without collaborators.

/copy?includeResolvedCommentsOnCopy=true - Copy the document with resolved comments.

/copy?title=NewTitle&usersToInvite=email1,email2 - Combine parameters to create a custom copy URL. For example, to copy a document with a new title and invite users to edit.

Template

/template/preview - Create a new sheet based on a template.

.new

https://sheets.new - Create a new Sheet.

Embed

<iframe src="https://docs.google.com/spreadsheets/d/SHEET_ID/preview" width="100%" height="600px"></iframe> - Embed a sheet in an iframe.