---
title: "How to Import Data into Google Sheets"
description: "Here's how to import your data into Google Sheets. We'll start with manually uploading a file, then show you an automated solution for grabbing data from other web apps."
image: "https://images.ctfassets.net/lzny33ho1g45/import-data-google-sheets-p-img/a5d9e4c095959bef092086ba475405c1/file.png"
---

# How to Import Data into Google Sheets

Here's how to import your data into Google Sheets. We'll start with manually uploading a file, then show you an automated solution for grabbing data from other web apps.

Google Sheets is a powerful online spreadsheet, but what if your data currently lives in another app like [Microsoft Excel](https://zapier.com/blog/connect-google-sheets-with-excel/) or in a different format like CSV or TXT?

Here's how to import your data into Google Sheets. We'll start with manually uploading a file, then show you an automated solution for grabbing data from other web apps.

## How to Manually Import Excel Documents Into Google Sheets

If there's a file on your computer that you'd like to add to a spreadsheet in Google Sheets, you can. Google Sheets can import several different filetypes:

- Microsoft Excel (.xls, .xlsx, .xlxm, .xltx, .xltm)
- OpenOffice/LibreOffice (.ods)
- Comma Separated Variable (.csv)
- Tab Seperated Variable (.tsv)
- Text files (.txt)
- MapInfo (.tab)

Open the document you'd like to import data to, then click _File_ > _Import_.

From here you can browse files on Google Drive, or you can click _Upload_ to add a file from your computer.

You'll have a few options.

Here's a quick breakdown of what these choices mean:

- _Create new spreadsheet_ will create a new Google Sheets file using the imported data.
- _Insert new sheet(s)_ will add new sheets to your current spreadsheet using the imported data.
- _Replace spreadsheet_ will replace the current spreadsheet, in its entirety, with the imported data.
- _Replace current sheet_ will replace whatever sheet you have open in the current spreadsheet, in its entirety, with the imported data.
- _Append to current sheet_ will add the imported data to the current sheet, starting with the first empty row.
- _Replace data at selected cell_ will insert the data as if you pasted it at the currently active cell.

Pick what works best for you and the imported data will show up.

## Automatically Import Data From Any Website

Google Sheets includes a powerful function called _ImportXML_ allows you to grab data from any site on the web. You'll need to know a little bit about HTML to get started, but once you grasp the basics, this is a very powerful tool. Check out our [guide to ImportXML in Google Sheets](https://zapier.com/blog/google-sheets-importxml-guide/) for a complete overview.

## Automatically Import Data From Other Apps

Don't want to spend time manually importing data into Google Sheets? With Zapier you can connect Google Sheets with 1,500+ apps, allowing you to populate spreadsheets automatically as information comes in.

For example, you could collect information from Typeform, Facebook lead ads, Mailchimp, or Fulfillment by Amazon in a spreadsheet.

You could also automatically capture information from your email inbox.

These are just a starting point. You can create your own automations by [signing up for Zapier](https://zapier.com/sign-up/), so dive in.

**Read more:** [How to use IMPORTRANGE in Google Sheets](https://zapier.com/blog/importrange-google-sheets/)