How to Import Data from Excel to Google Sheets

Moving a spreadsheet from Excel to Google Sheets is a simple task that opens up powerful possibilities for real-time collaboration and cloud-based access. Whether you're switching your team over to Google Workspace or just need to share a file more easily, the process is straightforward. This guide will walk you through a few different methods for importing your data, so you can pick the one that works best for your specific needs.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Move Excel Files to Google Sheets?

While Microsoft Excel is a powerhouse for data analysis, Google Sheets offers unique advantages, especially for teams. Before jumping into the "how," here's a quick look at the "why":

• Real-Time Collaboration: The biggest advantage is the ability for multiple people to work on the same spreadsheet simultaneously. You can see your colleagues' cursors, use a built-in chat, and leave comments directly in the cells.
• Cloud Accessibility: Your data lives in the cloud, securely backed up and accessible from any device with an internet connection - no more emailing different versions of the same file back and forth.
• Version History: Google Sheets automatically saves a detailed history of all changes. You can easily view previous versions of the spreadsheet and restore them if you make a mistake.
• Integration with Google Workspace: It seamlessly connects with other Google tools. You can embed charts into Google Slides, import data from Google Forms, or connect to other services using Google Apps Script.
• It's Free: For personal or small business use, Google Sheets is part of the free suite of Google apps, making it an incredibly cost-effective solution.

Method 1: The Direct Import Feature (Most Reliable)

This is the most common and reliable method for transferring an Excel file into Google Sheets. It gives you the most control over where and how the data appears, preserving formatting and formulas as much as possible.

Step-by-Step Instructions:

1. Open a new Google Sheet: Start by going to sheets.google.com and opening a blank spreadsheet.
2. Go to the "Import" menu: In the top menu bar, click on File > Import. This will open the "Import file" dialog box.
3. Upload Your Excel File: In the dialog box, you'll see a few tabs. Click on the "Upload" tab. You can then either drag and drop your Excel file (.xlsx or .xls) directly into this window or click the "Select a file from your device" button to browse your computer for the file.
4. Choose Your Import Options: After you upload the file, Google Sheets will ask you how you want to import it. You have three main choices for the "Import location":

• Create new spreadsheet: This option will create an entirely new Google Sheet file in your Google Drive, leaving your current blank sheet untouched. This is a great choice if you just want to convert the Excel file on a one-to-one basis.
• Insert new sheet(s): This will import all the tabs from your Excel file as new sheets within the current Google Sheet you have open. This is useful if you want to add data from an Excel file to an existing Google Sheets file.
• Replace spreadsheet: This will completely overwrite the Google Sheet you have open with the data and sheets from your Excel file. Use this with caution, as it will delete any existing data in your current file.

1. Click "Import data": After picking your import location, simply click the green "Import data" button. Google Sheets will process the file, and in a few moments, your Excel data will appear in a nice, new Google Sheet format.

Method 2: Upload Files Directly Through Google Drive

If you prefer to work from your main cloud storage hub, you can easily convert an Excel file directly from within Google Drive. This method is handy if you've already saved your Excel files to your Drive folder.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Instructions:

1. Open Google Drive: Go to drive.google.com.
2. Upload the Excel File: If your Excel file isn't already in Google Drive, upload it. You can either drag the file from your computer directly onto the Drive window or click New > File upload in the top-left corner.
3. Open the File with Google Sheets: Find the uploaded Excel file in your Drive. Its icon will have an "X" or "XLSX" on it to show it's an Excel format. Right-click on the file.
4. Select "Open with": From the right-click menu, hover over "Open with" and then select "Google Sheets" from the list of options.
5. A new Google Sheet is created: Google Drive will automatically create a new, separate Google Sheets version of your file in the same folder. Your original Excel file (.xlsx) will remain untouched. You can now work with the file in Google Sheets format, with all its collaborative features.

Method 3: The Simple Copy and Paste

Sometimes you don't need to import an entire file, just a small table or a specific range of data. In these cases, a quick copy and paste is often the fastest way to get the job done. However, be aware that this method can sometimes lead to formatting issues.

1. Open your spreadsheet in Microsoft Excel.
2. Select the range of cells you want to move.
3. Copy the cells by pressing Ctrl+C (on Windows) or Cmd+C (on Mac).
4. Open the destination Google Sheet.
5. Select the starting cell where you'd like your data to go.
6. Paste the data by pressing Ctrl+V (on Windows) or Cmd+V (on Mac).

Most of the time, this works perfectly for simple data values. However, complex formatting, charts, and certain formulas might not transfer correctly using this method. It's best used for quick, simple data transfers.

Troubleshooting Common Import Issues

While the import process is generally smooth, you might run into a few hurdles, especially with very complex spreadsheets. Here’s what to watch out for:

Formatting Flaws

Ninety-nine percent of your formatting — colors, fonts, borders, text wrapping — will come across just fine. However, sometimes intricate conditional formatting rules or very specific Excel cell styles don't translate perfectly. Always give your spreadsheet a quick visual check after importing and be prepared to make minor adjustments.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Broken Formulas

The vast majority of Excel formulas and functions work identically in Google Sheets (e.g., SUM, VLOOKUP, IF). However, there are subtle differences. For example, some advanced Excel array formulas or less common functions might not have a direct equivalent. Test your key formulas after an import to make sure everything is still calculating correctly.

One example is IFERROR. The formula works in both, but Google Sheets also has its own variant IFNA, which is more specific. Both ecosystems have a few unique functions.

External Links to Other Files

If your Excel workbook contains links to cells in other separate Excel files, those links will break during the import. Google Sheets cannot reference data from a local Excel file stored on your computer. You'll need to manually rebuild these links by first importing all necessary spreadsheets into Google Sheets and then using the IMPORTRANGE function to connect them.

Charts and Pivot Tables

Pivot Tables usually transfer very well, retaining their structure. You might just need to refresh them to ensure the data is accurate. Charts, on the other hand, can be a little more hit-or-miss. While the chart and its data will typically appear, its styling (colors, axis labels, titles) often gets converted to the Google Sheets default. You'll probably want to spend a minute or two tidying them up to match your original design.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

VBA Macros vs. Google Apps Script

This is the most significant compatibility barrier. Excel's macros are written in a language called VBA (Visual Basic for Applications). VBA macros will not work in Google Sheets. Google Sheets uses its own JavaScript-based language called Google Apps Script for automation. If your workflow depends on Excel macros, you will need to rewrite them from scratch using Apps Script to get them to work.

Final Thoughts

Moving a spreadsheet from Excel to Google Sheets is a simple and fast process. Whether you use the direct "Import" feature, convert a file in Google Drive, or do a simple copy and paste, you can get your data where it needs to be in just a few clicks. While you might need to fix some light formatting or tweak a chart, the benefits of real-time collaboration often make it worthwhile.

Moving data between tools like Excel and Sheets is a necessary step for collaboration, but it's often a symptom of a larger data puzzle. That manual struggle — downloading CSVs, cleaning spreadsheets, and uploading them somewhere else — is surprisingly time-consuming. We built Graphed to create a much more direct path from your data to your insights. By directly connecting your data sources like Google Analytics, Ads platforms, your database, or even Google Sheets itself, we help you get live dashboards and reports in seconds without the intermediary busy work. Instead of constantly importing files, your data can flow directly into the real-time reports your team needs to make smarter decisions.