Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to export a Google Sheet into different formats.
How To Export a Google Sheet into Different Formats
You may need to export your Google Sheets data into a different file format for various reasons.
For example, you may want to share your data with someone who does not have a Google account. Or you may want to create a backup of your data that is accessible offline.
In this guide, we will show you how to export your Google Sheet data into several different formats including CSV, Microsoft Excel, web page, and PDF.
How To Convert a Google Sheet into Multiple Formats
Here’s how to convert a Google Sheet into multiple formats.
First, open up the Google Sheets document you want to convert into a different format.
In the File tab, hover over Download to reveal the file formats you can export the current Google Sheet as.
If you select the Microsoft Excel (.xlsx) or OpenDocument (.ods) option, you may now edit your file in the Microsoft Excel application or another spreadsheet application such as OpenOffice Calc.
If you select the PDF (.pdf) option, you’ll be redirected to a page where you control how the current sheet will be converted into a multi-page PDF. You may adjust the paper size, page orientation, and the scaling mode.
Click on Export to download the current sheet as a PDF.
We can also export a Google Sheet into an HTML file. Opening the output through a browser will show an output similar to the one seen below.
The Web page option maintains the row and column headers and other cell formatting options such as color.
We may also export a Google Sheets document into a CSV. You can open a CSV using any text editor.
The tab-separated values (.tsv) format is similar to CSVs but they use tabs instead as a delimiter. This may be preferred if you’re expecting to handle data that often uses commas.
This guide should be everything you need to export a Google Sheets into different formats.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to import in Google Sheets:
- Fix IMPORTRANGE Internal Error
- IMPORTRANGE From Another Tab
- IMPORTRANGE With Conditions
- IMPORTRANGE With Formatting
- VLOOKUP + IMPORTRANGE
- IMPORTRANGE Multiple Ranges
- Filter IMPORTRANGE Data
- Fix IMPORTRANGE Error Loading Data
- Fix IMPORTRANGE Formula Parse Error
- Open CSV File
- Create A CSV File
- Import Data Into Google Sheets
- Import Spreadsheet Into Google Sheets
- Export Google Sheets To Excel
- Download Google Sheets
- How To Use Importrange
- Import CSV
- Import Excel
- Save as a CSV
- Import Data From Another Sheet
- Import Google Sheets To Excel
- Import PDF
- Pull Data From Multiple Tabs
- Connect Google Forms To Google Sheets
- Open Excel In Google Sheets