Join Sally Norred for an in-depth discussion in this video Importing and converting Excel or OpenOffice spreadsheets, part of Google Sheets Essential Training.
You can import and convert spreadsheet files created in Microsoft Excel or OpenOffice, into Google Sheets. You can also insert and convert an Excel or OpenOffice spreadsheet, into an existing Goggle Sheet spreadsheet. When you import and convert an Excel or OpenOffice document to a Google Sheet Spreadsheet, you'll be able to edit and share that spreadsheet with Google Sheets. Let's talk about times when you might want to import and convert a file from Excel or OpenOffice. You may want to import and convert one of these file types if you work on a team that uses Google Sheets, and you have an Excel or OpenOffice file to share.
Or you may be trying to convert a number of files into a Google Sheets friendly format. Let's review the file types that you can import and convert into Google Sheets. You can convert Microsoft Excel files of types .XLS or .XLSX. You can also import and convert OpenOffice spreadsheet files with the extension .ODS. Please note that password protected files cannot be imported. Let's take a minute to see how to import and convert these spreadsheet types into Google Sheets.
I'll show you how with this Solar Panel Chart spreadsheet that was created with Microsoft Excel. Please note, the same process works for OpenOffice spreadsheets. Start in your Google Drive. First, you'll need to upload the original Excel spreadsheet to your Google Drive. To do that, click the New button in the upper left. Click File Upload. Select and open the file you'd like to upload and convert. I'll upload and convert this Solar Panel Chart in Excel format. Once you see the upload complete notification, the Excel file will appear in your Drive.
Now select the item you wish to convert to Google Sheets format. Click the More Actions icon in the upper right, and select Open with Google Sheets. This will automatically convert the original spreadsheet document into a new Google Sheets document. You'll see that the Google Sheets version of the file contains all the same data and formatting as the original Excel file. I can make edits to this document in Google Sheets and I can share the file with other people like any other Google document if I wish. Let's take a look back in Google Drive. Now notice that the original Excel document remains intact and accessible in your Google Drive.
You'll also see the new Google Sheets version of the document. You can rename this file now to give it a unique name. You can also import and convert an Excel or OpenOffice spreadsheet into an existing Google Sheets spreadsheet. I'll show you how to do this from within this new Solar Panel Chart spreadsheet in Google Sheets. I'll open it up, and I'm going to import and convert this sunshine chart in Excel spreadsheet format and insert it as a new sheet into this document. From the Google Sheets menu tab select File > Import.
Click Upload on the left menu, and drag or select the file you'd like to upload. I'll select this Sunshine Chart currently in Excel format. Click Open and the Import file dialog will pop up. Select one of the available import options that's listed. Please note that not all file types will have all six options. With this file type, I could create a new spreadsheet. This option creates a new Google spreadsheet from your imported file in a new browser tab. I could also insert new sheets. This option adds new sheets to your existing spreadsheet containing the data in your imported file.
I could replace the spreadsheet. This option replaces your existing spreadsheet with the data in your imported file. I'm going to select Insert New Sheet, and I'll insert the spreadsheet as a new sheet in the file I currently have open. I'll click Insert New Sheet, and then I'll click Import. The selected file will be imported and converted into a new sheet inserted in the original file. Most of the time, Google Sheets does a great job of converting data and formatting. Be aware that with highly formatted spreadsheets, the spreadsheet may not capture all the formatting detail, and the spreadsheet may not look exactly as it looked in the original file.
- Navigating Google Sheets
- Creating, naming, and saving spreadsheets
- Importing files
- Converting other file formats such as Microsoft Excel to Google Sheets
- Editing cells
- Inserting, deleting, and moving rows and columns
- Adding hyperlinks and images
- Formatting data
- Using formulas and functions
- Sharing spreadsheets
- Using the Google Sheets mobile app
Skill Level Appropriate for all
Q: This course was updated on 04/17/2018. What changed?
A: We revised five videos to reflect the latest features and enhancements in Google Sheets.
Q: This course was updated on 10/17/2018. What changed?
A: New videos were added that cover customizing your printed spreadsheet and automating tasks with recorded macros.