Skip to content

App tutorials

2 min read

How to Import Data into Google Sheets

By Justin Pot · April 16, 2019
import-data-google-sheets primary img

Google Sheets is a powerful online spreadsheet, but what if your data currently lives in another app like Microsoft 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.

Click File then Import

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

Upload your data to Google Sheets

You'll have a few options.

Google Sheets import 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.

Google Sheets imported data

Automatically Import Data From Any Website

Scraping email addresses using ImportXML in Google Sheets

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 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.

Collect new Typeform responses as rows on Google Sheets

  • Typeform logo
  • Google Sheets logo
Typeform + Google Sheets
More details
    Forms are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a Typeform, saving the results to a new row on Google Sheets so you don't have to do it yourself.

    Save new Mailchimp subscribers to rows in Google Sheets spreadsheets

    • Mailchimp logo
    • Google Sheets logo
    Mailchimp + Google Sheets
    More details
      Save your new Mailchimp subscribers to a Google Sheets spreadsheet so that it's easier to share your list with teammates. This integration will automatically add new Mailchimp subscribers to a new row in a Google Spreadsheet.

      Add new Facebook Lead Ads leads to rows on Google Sheets

      • Facebook Lead Ads logo
      • Google Sheets logo
      Facebook Lead Ads + Google Sheets
      More details
        Spreadsheets make it easy to filter and sort through new prospects, but take time to build. Use this Facebook Lead Ads-Google Sheets integration to link your records directly to your ads so you can keep your mind on marketing. After being set up, every new ad lead on Facebook will trigger this Zap, automatically creating a new row on Google Sheets with all those valuable details for you. Learn more in our

        You could also automatically capture information from your email inbox.

        Save new Gmail emails matching certain traits to a Google Spreadsheet

        • Gmail logo
        • Google Sheets logo
        Gmail + Google Sheets
        More details
          Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from:

          Add new Gmail emails matching searches to Google Sheets rows

          • Gmail logo
          • Google Sheets logo
          Gmail + Google Sheets
          More details
            Emails can get lost in your inbox easily. If you need to keep a record of specific emails, though, this integration is just the ticket. After you set it up, each new email matching a specified search in your Gmail account will be automatically added to a row in a specified Google Sheets spreadsheet.

            These are just a starting point. You can create your own automations by signing up for Zapier, so dive in.

            Read more: How to use IMPORTRANGE in Google Sheets

            Get productivity tips delivered straight to your inbox

            We’ll email you 1-3 times per week—and never share your information.

            Related articles

            Improve your productivity automatically. Use Zapier to get your apps working together.

            A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'