You can import a spreadsheet in many file formats, like .xls, .csv, .txt, and more.
- On your computer, open a spreadsheet in Google Sheets.
- Open or create a sheet.
- At the top, click File Import.
- 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
- 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.
- 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 or detect a semicolon as a separator.
- Tab
- Comma
- Custom: Choose a custom character to split your data.
- Click Import.