From the course: Google Sheets Essential Training (2021)

Importing spreadsheets from Excel and OpenOffice - Google Sheets Tutorial

From the course: Google Sheets Essential Training (2021)

Start my 1-month free trial

Importing spreadsheets from Excel and OpenOffice

“

- [Instructor] You can import and convert spreadsheet files created in Microsoft Excel or OpenOffice into Google Sheets. When you import and convert an Excel file or an OpenOffice file into Google Sheets, you'll be able to edit and share that spreadsheet with Google Sheets. Let's talk about some 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 document 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 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. I'll show you how to import and convert these spreadsheet types into Google Sheets. You can convert Microsoft Excel files or OpenOffice spreadsheet files into Google Sheets. Please note that password-protected files can't 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. I'll start by opening a new sheet in Google Sheets. At the top I'll click file, import. Since my Excel spreadsheet's on my desktop, I'll click upload, select a file from my device, and select Solar Panel Chart and click open. Now I'll select an import option. I'll select replace spreadsheet because I don't have any data in this spreadsheet anyway. I'll click import data. Google Sheets converts my Excel spreadsheet into a new Google Sheets spreadsheet. It named the tab for this spreadsheet but it didn't name the spreadsheet itself. So I'll rename this spreadsheet Solar Panel Chart. The Google Sheets version of the file contains all the same data and formatting as my 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. Now 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'm going to open and convert this sunshine chart in Excel and insert it as a new sheet into the Google Sheets document. From the Google sheets menu tab, I'll select file, import. Again, I'll click upload, select file. This time I'll select the sunshine chart. This time though, I'm going to insert it as a new sheet in the spreadsheet. You have the choice of importing the theme. I'm not going to do that. I'm just going to import data. So I will click the import data button in the bottom of the pop-up and the sunshine and location chart appears as a second tab within the solar panel chart spreadsheet. 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.

Contents