How to open local files from your computer into Google Docs directly?
To open your local file in Google docs spreadsheet,
Step 1: Click File → Open or press Ctrl+O.
Step 2: In "Open a file" dialog box, click "Upload" option and drag file into the area or click "Select a file from your computer".
Step 3: "File Upload" dialog box opens. Choose any excel file in xls or ods or xlsx format from the local system and click Open.
Step 4: File will start uploading into google docs spreadsheet.
Step 5: Uploaded file will be opened in a separate tab as given in the image below