Import data sets and spreadsheets
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)
- 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.
- Custom: Choose a custom character to split your data.
- 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?