![]() Google Sheets has nearly as many functions as Excel-just shy of 500-and that includes a number of Google-specific functions to detect languages, insert images, translate text, find stock prices, and more. How to enrich data in an Excel spreadsheet with Diffbot.How to generate new leads from an Excel spreadsheet.How to do competitive research in an Excel spreadsheet.How to perform market research in an Excel spreadsheet.How to monitor the news in an Excel spreadsheet. ![]() ![]() Here are some ways to use Diffbot Search and Enhance in Excel: Use Search when you want to find new data-with a new window to create detailed queries to find companies, people, and articles. Use Enhance when you already have some details about companies or people, and want to enhance it or add more info-with a sidebar to tell Diffbot which columns your data lives in, and what info you want it to find. With Diffbot’s sidebar open, you have two options: Enhance or Search. You’ll find it on the right of your Home tab, or from the Insert -> Office Add-ins button where you can search through all your Excel add-ins to find Diffbot. So, to use Diffbot in Excel, you’ll need to use the Diffbot sidebar. Your core spreadsheet works the same as before, then when you want to use Diffbot, you can use its features inside Excel to add data from the sidebar. For everything else, Excel relies on add-ons, where the newest add-ons like Diffbot come in a sidebar. How to use Diffbot in ExcelĮxcel comes with over 500 built-in functions-everything from ABS to ZTEST. Now that there’s a robot in your spreadsheet, it’s time to put it to work. Tip: If you use a text expander app like TextExpander, Alfred, or PhraseExpander, you could save your API key to enter it easily later. If not, and you get prompted to add it again (or if you use another Office or Google account, and need to re-add DiffBot), just copy the Diffbot code again from your Diffbot dashboard, paste it into your spreadsheet, and get back to letting Diffbot find data for you on its own. Your spreadsheet should remember your Diffbot API Token and keep working on its own. Either way, paste in your API code, and your spreadsheet can now use Diffbot to find knowledge for you. In Google Sheets, click Add-ons -> Diffbot for Sheets -> Login to Diffbot in Excel, click the Diffbot Add-in icon, then click Sign-in in the sidebar. Open your Diffbot dashboard, click the API Token button in the top right corner, and copy the code.īack in your spreadsheet, start the Diffbot add-in. You’ll then need to connect your spreadsheet to your Diffbot account. Search for Diffbot and install the add-on (or, click here for Diffbot for Google Sheets and Diffbot for Excel, respectively). Then open the add-ins tool: Click Insert -> Add-ins in Excel, or Add-ons -> Get Add-ons in Google Sheets. Open Google Sheets or a recent version of Excel-either Excel with a Microsoft 365 subscription, Excel 2019, or Excel Online in your browser. It’s like a robot research assistant in your spreadsheet. With Diffbot’s spreadsheet integrations you can quickly research potential leads, find competitors, surface articles about a topic, and enrich your existing data to fill in the blanks for you. But now they take some of the most common productivity-boosting tools (spreadsheets) and have made them even more powerful.
0 Comments
Leave a Reply. |