Search
Clear search
Close search
Google apps
Main menu

Import data sets and spreadsheets

You can import a spreadsheet in any of these file formats:

  1. On your computer, go to docs.google.com/spreadsheets/.
  2. Open or create a sheet.
  3. At the top, click File and then Import.
  4. Choose a non-password-protected file in one of these file types:
    • .xls (if newer than Microsoft® Office 95)
    • .xlsx
    • .xlsm
    • .xlt
    • .xltx
    • .xltm
    • .ods
    • .csv
    • .txt
    • .tsv
    • .tab
  5. Select an import option. Not all file types have all six options:
    • Create new spreadsheet: Create a spreadsheet from the imported data in a new browser tab.
    • Insert new sheets: Adds new sheets with the imported data to your existing spreadsheet.
    • Replace spreadsheet: Replace the open spreadsheet with the data in your imported file.
    • Replace current sheet: Replace the current sheet’s contents with the imported data.
    • Append rows to current sheet: Adds the imported data to the current sheet after the last row with any data.
    • Replace data starting at selected cell: Replace the data in a range of selected cells with the imported data.
  6. Click Import.

Note: If you import a plain text file, like .csv or .txt, you can pick what letter or symbol Google Sheets uses to separate cells.

Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.

Was this article helpful?
How can we improve it?