If you have an Excel file that you want to directly linked to a Google Sheet, this can be accomplished using the steps outlined below. The Google Sheet that will be created will be automatically updated if the Excel file changes.
The first step is to upload your Excel file to Google Drive. The linking of the Sheet and Excel spreadsheet happens in the cloud. The original file and the new Google Sheet must in the same cloud service for this to happen. In this example we are using Drive, but this also works with Microsoft's OneDrive. As seen in the example above, an Excel file called Record employee time including night shift.xlsx has been uploaded to Drive.
After you have your Excel file uploaded to Google Drive, navigate to Sheetgo, go to Data Source, and choose Add source. Sheetgo will show you the files that you have in Google Dirve. In the picture below, it is showing the Excel file that we just uploaded. We will choose that file.
The destination will default to a Google Sheet named New Spreadsheet. You could go into Google Drive, create a new spreadsheet with any name you want, and add it to that if you wanted.
Below is the file opened in Sheets that was just created.
New File in Sheets
Now you have a Sheets file with the same data that the Excel file has in just a few, easy steps!
Disclosure: This is an independently owned website that, at times, receives compensation from the companies whose products are mentioned. Each product is tested by Prolific Oaktree and any opinions expressed here are our own.