

Finally, with everything set, click on Untitled spreadsheet at the top and give a name to your document to save it. Alternatively, you can select any other option from the list as per your requirements. If you are working on a new spreadsheet, click Replace spreadsheet and hit Import data. You will now see a prompt asking you to select the import location. Select the (.html) file and click Choose for Upload. Navigate to the folder where you downloaded the Google Docs. In the Import file window, tap on Upload and hit the Select a file from your device button. Alternatively, you can choose some other Sheets template as per your requirements. Click on Blank under the Start a new spreadsheet section to create a new spreadsheet. Next, open Google Sheets in a browser and sign-in to your account. zip format), and select the unzip tool to unzip its content. Alternatively, if you are on Windows, open the file in File Explorer, right-click on the downloaded file (in. This will automatically extract the contents of the file for you. To do this, open Finder and double-click the zip file.

Since Sheets does not support the (.zip) format, you need to unzip this file to get the (.html) file inside it. When you download the Docs document in Web page format, you get the file in the (.zip) file. As such, you need to select Web page (.html, zipped) from the Download options. This is so because it makes more sense to import a document that contains data in a tabular format on Sheets than some other format. Generally speaking, the kind of Docs document that you would likely import to Google Sheets will have some form of tabular presentation of data in it. Google Sheets supports the following formats: xls, xlsx, xlsm, xlt, xltx, xltm, ods, csv, txt, tsv, tab, and html. Now, depending on what (and how) information is present on this document, you need to choose its download format. With the document open, go to File > Download. Find the document you want to export to Sheets and open it. Open Google Docs in a web browser and sign-in to your account.
