What you will build

Import an Excel (.xlsx) workbook into Google Sheets without replacing the sheet you already have. Use the Item, Qty, Amount sample as your reference so you can compare the imported sheet with the source.

Learning objectives

Open the practice workbook

HANDS-ON PRACTICE

Practice in your own copy

Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.

Make a Google Sheets copy (access required) ↗View original

Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.

The verified _result workbook before import, showing the Item, Qty, Amount source table with all three rows.

Hands-on practice

Step 1: Check the source table first. A1:C4 should contain the headers Item, Qty, Amount and the rows Pen | 3 | 15, Notebook | 2 | 40, and Folder | 1 | 12. Keep this table unchanged so you have a reference after the import.

Step 2: Choose File > Import. Google Sheets opens the Import file dialog. Choose Upload, then click Browse (or drag an .xlsx file into the upload area) and select the Excel workbook you want to import.

File menu open in the _result workbook with the pointer placed directly on Import.
The Import file dialog on the Upload tab, with the Browse control visible for selecting an Excel workbook.

Step 3: In the import options, choose Insert new sheet(s), then click Import data. Open the newly imported sheet and confirm Item, Qty, and Amount are in separate columns with all three rows unchanged. If the result is wrong, remove only the imported test sheet and repeat the import with the correct option.

The Import file options show Insert new sheet(s) selected and the Import data button ready.
The imported Example (1) sheet shows Item, Qty, Amount and all three rows unchanged, while the original Example sheet remains separate.

Checkpoint

ItemQtyAmount
Pen315
Notebook240
Folder112

Checkpoint for “Import Excel workbooks”: the Item, Qty, Amount columns and sample records must still match this table after the lesson action.

Common mistakes and fixes

If the imported columns or values do not match, compare them with A1:C4 in the source table, delete the imported test sheet, and repeat File > Import with Insert new sheet(s).

Independent practice

For independent practice, use a small Excel workbook with one additional row, import it with Insert new sheet(s), verify the extra row appears in the imported sheet, then delete that imported practice sheet.

Key takeaways

  • ✓Start with File > Import, then choose Upload in the Import file dialog.
  • ✓Choose Insert new sheet(s) to protect the current sheet during practice.
  • ✓Confirm Item, Qty, and Amount import into separate columns.
  • ✓Verify all three sample rows after import.
  • ✓Remove the test sheet and retry if the wrong import option was used.
QUICK CHECK

Check your understanding

Answer four questions about the practice sheet.

1. What starts the Excel import workflow?
2. Which import location is safest for this practice?
3. What should you verify after import?
4. What should you do if the wrong import option overwrites or misplaces data?

Next lesson

Continue in recommended learning order with Organize spreadsheets in Google Drive.