If you’re like most people, you probably use Google Sheets to keep track of data. But if you want to import an Excel document into Sheets, there are a few things you need to know. First, make sure that your spreadsheet is open in Google Sheets. If it isn’t, open it and try again. Next, select the sheet that you want to import from. In our example, we’ll select the Sheet1 sheet in our spreadsheet. Now click on the “Import” button at the top of the sheet’s window. This will take you to a dialog box where you can choose which files to import. We’ll choose “All Files.” This will copy all of the files in our spreadsheet into Google Sheets. Now we need to tell Google Sheets where we want our new data to live. We’ll type “Google Sheets:///Users/YourUserName/Documents/Sheet1” into the text field at the top of the dialog box and click on OK. Now we can start tracking our new data in Sheets!
Did someone send you an Excel document, but you don’t have Excel? Giving up on Microsoft Office and making the change to Google Drive? No problem; Google Sheets lets you import your Excel files. And while it might not support some of the same features and effects of an Excel document, it works pretty well.
How to Import an Excel Document into Google Sheets
To view an Excel document on Google Sheets, you must first upload the file to your Google Drive. Open Google Drive, click “New,” and then click “File Upload” to get started.
RELATED: How to Create a Drop-Down List in Google Sheets
Navigate to your file(s) and then click “Open.”
Alternatively, you can drag and drop a file from your computer directly into the web browser for an easy upload.
Once your file uploads, right-click it, point to “Open With” on the context menu, and then select “Google Sheets.”
RELATED: 5 Google Sheets Features You Should Know
Google then converts your document into a Google Sheets file on your Drive account.
After you’ve finished editing your file, you can either share it with others or download and export your document back into a Microsoft Excel format by going to File > Download As and then clicking the “Microsoft Excel” option.
RELATED: How to Create Shareable Download Links for Files on Google Drive
If you’d rather download your document in PDF, ODS, CSV, or other formats, you can do that too.
The file is then downloaded to the browser’s default download folder.
