Search
Clear search
Close search
Google apps
Main menu

Import data sets and spreadsheets

You can import a spreadsheet in many file formats, like .xls, .csv, .txt, and more.

  1. On your computer, open a spreadsheet in Google Sheets.
  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. Optional: If you import a plain text file, like .csv or .txt, under "Separator character," you can pick what letter or symbol Google Sheets uses to separate cells.
    • Detect automatically: This will automatically find ways to split your data set. For example, it can detect fixed-width-formatted files.
    • Tab
    • Comma
    • Custom: Choose a custom character to split your data. 
  7. Click Import.

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?
false
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.