how to upload an excel file to google sheets

If your Excel File is not uploaded in the Drive then you can use other options available. Therefore, the data from Excel File is imported into Google Sheets. From there search for the Excel file name if you uploaded the Excel file earlier.Īgain, another dialog box will appear with the Excel File.To open a google sheet either you can search Google Sheets or you can go there from Drive. You can use the Import option in both ways. The Google Sheets also gives us the opportunity to use the Import option from the File menu to import data from an Excel file into it. Read More: How to Convert Excel Sheet to Google Sheets (3 Easy Ways)Ģ. Now, data will be imported from Excel to Google Sheets. Then, from Open with > select Google Sheets.Now, select the Excel File > right-click on it to bring Context Menu bar.The Excel File will be uploaded to the Drive. First, go to Drive > then click on New.It’s a very much handy and useful way to do it. You can use Google Drive to import data from Excel to google sheets. Using Google Drive to Import Data from Excel Here, I created an Excel file with some data from a particular store and Saved it in a particular place to Import these into Google Sheets.ġ. Then all of the data will show up in the spreadsheet.Importing Data from Excel to Google Sheets.xlsmĢ Ways to Import Data from Excel to Google Sheets 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 an excel file to google sheets