Import Excel document into Google Sheets: a tutorial
When it comes to complex formulas, lists, or automated dependencies, Excel is often the first choice. However, if you want to open or edit an Excel file, you don’t necessarily have to use the Microsoft spreadsheet. The files can also be opened with various Microsoft Excel alternatives – including Google Sheets, the search engine’s very own spreadsheet program on the Google Workspace.
In this tutorial, we’ll show you how to upload Excel spreadsheets into Google Sheets and transfer your Excel project to Google Sheets step by step.
Open Excel spreadsheets in Google – a quick guide
The Google Workspace programs, such as the Google Docs text editor and Google Sheets, are free to use. One of the greatest advantages of the online suite is its compatibility with files from the Microsoft Office suite, which makes it easy to open and edit Excel spreadsheets, among other things.
Just follow these five steps to import your Excel projects into Sheets or other Google Workspace apps like Google Docs:
- Go to Google Drive in the browser of your choice or launch the Google Drive app.
- Upload your Excel file.
- Right-click on the Excel file and select “Open with”.
- Select the Google app (recommended: Google Sheets) that you want to use to open the Excel file.
- Now you can review, edit, save, and send the Excel file in the usual way.
Upload and edit Excel data in Google Sheets: step-by-step guide
The following sections are a step-by-step guide to importing Excel files into Google Docs or opening and editing them in Google Sheets.
Step 1: Open Google Drive
To upload Excel or CSV files to Google Sheets or other apps from the Google Workspace, you need an active Google account. In case you don’t have one yet, head over to Google to register.
If you have a Google account, first log in with your credentials. Then open the app menu (top right). Click on the Google Drive icon to launch the online storage in your browser.
Smartphone and tablet users can launch Google Drive just as easily by using the corresponding app for Android or iOS.
Step 2: Upload Excel file to Google Drive
Once you’ve opened Google Drive, you’ll see a plus sign in the upper left corner, labeled “New”. Click on the button and select “File upload”.
An Explorer window opens that lets you browse the location where the Excel spreadsheet is stored. Select the Excel file and click “Open” to finish. Once the Excel file is uploaded to Google Drive, you’ll receive a message to confirm.
Prefer to access Google Drive without an Internet connection? Activate the Offline function in Google Drive.
Step 3: Open Excel spreadsheet in Google Docs and Google Sheets
Once you’ve uploaded the Excel file to Google Drive, you decide how you want to open the spreadsheet document. Select the file by right-clicking on it. A dialog window will pop up prompting you to “Open with”.
Depending on the file type, Google will automatically suggest apps that are best suited to opening your file. For example, Google Docs is always recommended for Word documents. To open and edit Excel spreadsheets, Google Sheets will be the suggested choice by default.
Step 4: Edit and save Excel file
Now that you’ve opened your Excel spreadsheet or imported a CSV to Google Sheets, you can edit it as usual. For example, you can add and adjust data or optimize the display format of your Excel spreadsheet.
When working with Excel spreadsheets in Google Workspace, keep in mind that for all its similarities, there are also crucial differences between Google Sheets and Excel.
Step 5: Save and share Sheets
Once you’ve successfully edited your spreadsheet, you can save the document as a Google Sheet. Click “File” and then “Save as Google Sheet”. This is especially useful if you plan on sharing the spreadsheet via Gmail.
To do this, launch the Google Mail app, select “Write” and input the sender from your Google Contacts. To share your saved Google Drive spreadsheet, simple click the “Paste file from Google Drive” icon.
If you want to save the file as an Excel document, select the “Download” via the “File” menu item and choose the XLSX format. This way you can save the Excel table on your PC in a folder of your choice.
The best format for storing your spreadsheet depends, among other things, on which collaboration tool you tend to use at work. Do you know the pros and cons of comparing the “Google Workspace vs Microsoft 365”?
Optimal teamworking is guaranteed with HiDrive cloud storage from IONOS! Together with your personalized email address, it makes for the perfect solution to manage data. If you’re switching over from a Gmail account, just set up Gmail forwarding. It’s as easy as 1-2-3!
Related articles
Google Docs: working on your documents offline
So, you want to work on your documents on the go, but you will not have access to an internet connection. If you want to use Google Docs offline, all you need is the Google Chrome extension and adequate space on your hard drive to store your documents locally. We will go over how to work on your projects in Google Docs offline.
The most important Google Docs shortcuts at a glance
Google Docs is one of the most widely used collaborative tools for word processing. The program offers a number of practical shortcuts that allow you to create and edit documents more efficiently. We’ll show you the most important Google Docs shortcuts and how to view a list of all keyboard shortcuts directly in the Google tool with just a few clicks.
optimarcShutterstock 30 Excel shortcuts to speed up your work
Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.
How to recover an Excel file
Recovering Excel files can be time-consuming and nerve-wracking. Windows and Excel offer a wide range of options for recovering unsaved or overwritten Excel documents if the program crashes or you accidentally close it without saving. In this tutorial, we’ll present helpful solutions and practical tips for recovering lost or unsaved Excel files.
