how to upload excel file to google sheets

Convert Excel to Google Sheets Automatically The result is the same as in the previous section: The Excel file is converted to Google Sheets. Right-click on the file in Google Drive.If you already have an Excel file in Google Drive, you can easily convert it to Google Sheets. When you open the file, it has the same content and structure as the original Excel file, shown in the picture below. In the Open window, select an Excel file and click Open.Īs a result, the Excel file is uploaded to Google Drive and converted to a Google Sheets file with the same name.Click on the New button in Google Drive.Say you have an Excel file containing the data pictured below that you want to convert to Google Sheets.

Convert an Excel File Upload to Google DriveĪn Excel file can be converted while uploading it from a computer to Google Drive. Then all of the data will show up in the spreadsheet.This tutorial demonstrates how to convert an Excel file to a document in Google Sheets.Īn Excel file may be converted to Google Sheets in two ways: by uploading a file from a computer or by converting an existing file from Google Drive. When you press Enter, you’ll see a loading status for a few seconds. Click on the cell where you want the imported data to go. You can import the data directly from such a CSV file into your Google Sheets spreadsheet using the IMPORTDATA function.ġ. For example, the Census Bureau provides lots of data files in CSV format, such as population totals by state at the following link: The file needs to be stored on a web server online, and accessible via a direct link. Using the IMPORTDATA FunctionĪnother approach to bringing in data from an Excel file saved in CSV format is by using the IMPORTDATA function in Google Sheets. Once you’ve made your conversion options, select Import data to bring the CSV file data into your Google Sheets spreadsheet. Also configure whether you want the text from the CSV file converted to the appropriate data type (numbers, dates, and formulas). You can also configure whether you want to open the data in a new spreadsheet, to replace the current sheet, or append to the current sheet.

How to upload excel file to google sheets