how to upload an excel file to google sheets

This page was easy: I clicked the temperature, and it was the only item selected.

(Foundry is Computerworld’s parent company.) In the image below, I visited the National Weather Service page for Needham, MA, the location of Foundry corporate headquarters. If they are, click on the ones that you want to remove from your selection. Other areas of the page may be green or yellow, too. The trick is to make sure you’re only selecting that. Install the SelectorGadget Chrome browser extension, activate it by clicking the browser tool icon, and then click on the section of the page you want to scrape. (There’s a less-than-2-minute video on the site demonstrating how it works.)

Fortunately, there’s an easy-to-use point-and-click tool that helps you do just that: SelectorGadget. Google Sheets needs an “XPath” selector to pluck just a portion of data from a web page. Find the “XPath” for the part of the web page you want to scrape (The default will be “Untitled spreadsheet,” but you can click on that to change it to something that will better identify it in your list of documents.) 2. Title the sheet anything you want, and you’re ready to begin.

How to upload an excel file to google sheets