Want advanced Google Workspace features for your business?
You can import a spreadsheet in many file formats, like .xls, .csv, .txt, andmore.
- 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.
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.