In this article:

How to Copy an Excel Sheet to Google Sheets (Easiest Way in 2024)

October 25, 2024

In this article, we will show you exactly how to copy an Excel sheet to Google Sheets in just a few simple steps. Simply follow the steps below.

how to copy excel sheet to google sheets

How to Copy an Excel Sheet to Google Sheets

You can copy an Excel sheet into Google Sheets in two ways: by using the copy-paste method or by uploading the Excel file directly. Choose the option that works best for you.

Method 1: Copy and Paste

Here's how to copy an Excel sheet to Google Sheets using the copy-paste method: 

1. Open Excel File and Google Sheets to Start the Process

Ensure your Excel file is open. Then, go to Google Sheets in your browser and open a new or existing spreadsheet where the Excel data will be copied.

uploading excel spreadsheet to google sheets

2. Copy Data from Excel

Select the cells from your already open Excel file, and copy them by using Ctrl + C (or Cmd + C on Mac).

convert excel file to google sheets format

3. Paste Data into Google Sheets

Go to the Google Sheets file, select the starting cell where you want to paste the data, and press Ctrl + V (or Cmd + V on Mac) to paste. You can then format the data to your liking.

from excel sheet to google sheet

Method 2: Upload to Google Drive

Follow these steps to upload your Excel sheet to Google Sheets:

1. Upload the Excel file to Google Drive 

To upload, click the “New” button in the top left corner of the page, then select “File Upload.” When the file explorer opens, find the Excel file you wish to upload and click “Open.”

excel to google sheet conversion guide

Note: If you prefer, upload your Excel file directly to Google Drive by dragging it into the Drive window.

2. Open the Excel File in Google Sheets Format

Upload the Excel file to Google Sheets. Note that it will be saved as “.xlsx”. Right-click on it in Google Drive and choose "Open with>Google Sheets" to automatically convert the file.

transfer excel file to google sheets

Disclaimer: Please keep in mind that some features in Excel may not fully convert to Google Sheets. This includes the amount of data, complex formulas, macros, and some formatting options. Always double-check your data after conversion to ensure accuracy.

We hope that you now know how to copy Excel Sheets to Google Sheets. If you enjoyed this article, you might also like our articles on how to copy a Google Sheet and how to automatically import Excel to Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->