Convert Excel to Google Sheets in Google Sheets
Create a Google Sheets copy by duplicating the Excel import sheet and renaming the duplicate exactly "Google Sheets copy". Keep the original Excel import sheet.
Verified by JosephineAbout 60 secondsCreate a Google Sheets copy by duplicating the Excel import sheet and renaming the duplicate exactly "Google Sheets copy". Keep the original Excel import sheet.
Step-by-step
Select the targetCreate a Google Sheets copy by duplicating the Excel import sheet and renaming the duplicate exactly "Google Sheets copy".
Apply the changeKeep the original Excel import sheet.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
The original imported worksheet and a visible Google Sheets copy both exist with the imported data preserved.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Undo the last change, reselect the intended range, and try again. The original imported worksheet and a visible Google Sheets copy both exist with the imported data preserved.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Product | Units | Revenue |
| Desk lamp | 12 | 540 |
| Monitor stand | 8 | 720 |
| Keyboard | 15 | 900 |
Video transcript
- Open the prepared Excel import spreadsheet.
- Select the target. Create a Google Sheets copy by duplicating the Excel import sheet and renaming the duplicate exactly "Google Sheets copy".
- Apply the change. Keep the original Excel import sheet.
- The original imported worksheet and a visible Google Sheets copy both exist with the imported data preserved.