How to Import Excel into Google Sheets

The simplest way to get an Excel file into Google Sheets is to upload it straight to Google Drive. Google will automatically offer to open it as a Google Sheet.

Steps

1. Go to drive.google.com and sign in.
2. Click New → File upload, or simply drag the .xlsx file from your desktop into the Drive window.
3. Wait for the upload to finish (you'll see a progress indicator in the bottom right).
4. Double-click the uploaded file. Google Drive will open it in a Sheets-compatible preview.
5. If it doesn't open directly in Sheets, right-click → Open with → Google Sheets.

What gets preserved

Most formatting transfers well: cell values, formulas, basic conditional formatting, data validation, charts (converted to Google Sheets chart types), sheet names, and frozen rows/columns. Some advanced Excel features like macros, VBA, Power Query, and certain chart types won't carry over.

When to use this method

This is the go-to method for most people. Use it when you want to keep as much formatting as possible and don't mind uploading your file to Google's servers.

If the direct upload method mangles your dates, misreads numbers, or chokes on a large file, converting to CSV first gives you the cleanest import. CSV strips away formatting and gives Google Sheets pure data to work with.

Steps

1. Convert your Excel file to CSV using our free Excel to CSV converter (runs in your browser — your file stays on your device).
2. Download the CSV file.
3. Open Google Sheets and create a new blank spreadsheet.
4. Go to File → Import → Upload and select the CSV file.
5. In the import dialog, choose:
   • Import location: "Replace spreadsheet" (or "Insert new sheet" if adding to an existing file)
   • Separator type: "Detect automatically"
6. Click Import data. Your data appears instantly.

Why CSV is sometimes better than .xlsx

CSV files are plain text, so there's zero ambiguity about how data should be interpreted. This avoids the common gotchas with direct .xlsx uploads: date formats flipping between DD/MM and MM/DD, long numbers losing precision (like barcodes or IDs being displayed in scientific notation), and special characters getting garbled.

When to use this method

Use the CSV route when: you're seeing formatting issues with the direct upload, your file is very large (50MB+), you only need the raw data without formatting, or you want to keep your files private and avoid uploading to Google's servers.

If you already have a Google Sheet open and want to pull in data from an Excel file, you can import directly without leaving Sheets.

Steps

1. Open an existing Google Sheet (or create a new one at sheets.google.com).
2. Go to File → Import.
3. Switch to the Upload tab and drag your .xlsx file in, or click "Select a file from your device".
4. Choose your import options:
   • Create new spreadsheet — makes a brand new Google Sheet
   • Insert new sheet(s) — adds the data as new tabs in the current spreadsheet
   • Replace spreadsheet — overwrites everything in the current sheet
   • Replace current sheet — replaces only the active tab
   • Append to current sheet — adds rows below existing data
5. Click Import data.

When to use this method

Best when you're already working in Sheets and need to add Excel data to an existing spreadsheet, or when you want fine-grained control over where the imported data lands.

If your Excel data is published as a CSV on the web (for example, from a shared Dropbox link, a public GitHub file, or an internal data API), you can pull it into Google Sheets automatically using the IMPORTDATA function.

Steps

1. Get the direct URL to your CSV file. The URL must end in .csv or return CSV content directly (not an HTML download page).
2. Open a Google Sheet.
3. In any cell, type: =IMPORTDATA("https://example.com/your-file.csv")
4. Press Enter. Google Sheets will fetch the CSV and populate the sheet with the data.

When to use this method

Ideal for dashboards and automated reporting. If you have a data source that updates regularly and is available as a CSV URL, IMPORTDATA will refresh the data automatically (roughly every hour). This saves you from manually downloading and re-importing files.