July 20, 2024
Learn how to use Google Bard with Google Sheets
Moving from Google Bard to Google Sheets.
Illustration: Andy Wolber/TechRepublic

Google Bard may also help you create content material and calculations for Google Sheets. Within the first position, Bard serves as a wise record generator that produces content material in a desk so that you can export to a Google Sheet. Within the latter position, Bard’s responses show you how to devise Google Sheets formulation and capabilities. These makes use of of Bard provide capabilities that reach past the usual autofill and correction capabilities in Google Sheets.

SEE: ChatGPT vs Google Bard (2023): An in-depth comparability (TechRepublic)

For the actions beneath, you’ll should be signed in to an lively Google account licensed to make use of each Google Sheets and Google Bard. In the event you use a Google Workspace account for work or college, chances are you’ll have to contact an administrator to request entry to Bard. After getting entry, open Bard in any trendy browser to get began. Enter a pure language immediate, and Bard will present a response. Bard responses might differ — two individuals who enter the identical immediate might not obtain the identical response.

Soar to:

Learn how to acquire content material from Bard for a Google Sheet

With Bard, you may immediate the system for all kinds of comparisons and lists. For instance, a request to match two or extra merchandise may produce a desk with a column for every product and every row with a unique in contrast characteristic (Determine A). You may also immediate Bard for lists of issues, comparable to individuals, locations or issues. Since Bard accepts sequences, you may first immediate:

Checklist the ten cities in america with probably the most annual rainfall.

Then, after you obtain the preliminary response, immediate once more with:

Add a column for the inhabitants.

Determine A

Bard can help you quickly obtain all sorts of comparisons and lists. When Bard provides a response in a table, select Export To Sheets to create a new Google Sheet with the table contents.
Bard may also help you rapidly acquire all kinds of comparisons and lists. When Bard gives a response in a desk, choose Export To Sheets to create a brand new Google Sheet with the desk contents.

The tables Bard can generate as a response differ way more than typical autocomplete sequences out there in Google Sheets with the Instruments | Autocomplete | Allow Autocomplete Choice enabled.

In Google Sheets, you enter a predictable collection of alphabetical letters, numbers, days of the week, months or different commonplace patterns in two or extra cells. Then choose the cells and select-and-extend the nook of the field to cowl the whole vary of to-be-filled cells. For instance, should you kind Mon in a single cell and Tue in an adjoining cell, chances are you’ll choose these two cells after which drag the dot to fill one other 5 cells with the remaining respective three-character descriptions of days of the week in English. In distinction, the tables you may immediate Bard to create might comprise a a lot wider vary of listable knowledge.

Select Export To Sheets

When a response features a desk, choose the Export To Sheets possibility on the lower-right nook of the desk. This exports the desk to a brand new Google Sheet (Determine A). The system will use your immediate as each the identify of the newly created file and the preliminary sheet throughout the file. The contents of the desk will probably be positioned within the cells of the sheet, with the titles of the columns in Row A.

Immediate “in a desk”

Bard will typically robotically format comparisons and lists in a desk. When the system doesn’t do that, add the phrase “in a desk” to your request. This may make the immediate listed above to be:

In a desk, record the 20 cities in america with probably the most annual rainfall.

View different drafts or reset chat

Typically Bard gives both a partial response or an oddly formatted response. For instance, strive the immediate:

Checklist all 50 U.S. states sorted by inhabitants.

Bard returned a desk of 40 states, which is an incomplete response. In one other instance, a immediate for a:

Checklist of components by identify and atomic weight

In response, Bard produced an inventory formatted as a code snippet, not a desk. When a response isn’t what you count on, choose the View Different Drafts button to entry various drafts (Determine B). In some circumstances, a type of drafts will probably be formatted as a desk quite than a code snippet.

An alternative choice when this type of error happens is to pick out the Reset Chat button (as proven in Determine B on the higher left) after which strive the immediate once more. This may occasionally lead to a extra full or better-formatted response.

Determine B

View other drafts to access alternatively formatted responses, which sometimes display data in a table rather than a list format. In some cases, selecting Reset Chat and trying your prompt again may return a response in the format you want.
View different drafts to entry alternatively formatted responses, which generally show knowledge in a desk quite than an inventory format. In some circumstances, deciding on Reset Chat and attempting your immediate once more might return a response within the format you need.

Learn how to get assist from Bard with a Google Sheets calculation

It’s possible you’ll immediate Bard to elucidate and supply examples of Google Sheets formulation and capabilities. In contrast to Google Sheets assist pages, which give particulars and a static set of examples, chances are you’ll ask Bard for quite a lot of examples, together with an in depth description of how a characteristic works.

For instance, if you wish to be taught a bit extra about one of many new functions Google added to Sheets in March 2023, you may immediate:

How do I take advantage of the WRAPCOLS operate in a Google Sheet? Are you able to give an instance of how I would use it to group an inventory of worker names into teams of 4 individuals every?

The response from Bard (Determine C) included, in sequence:

  • An outline of how the operate is used
  • A code snippet instance of the syntax with every half listed
  • A pattern components to group an inventory right into a set of 4
  • An instance with demo names
  • Extra code examples to group an inventory into units of three, 5 or seven

Determine C

Not only can Bard explain Google Sheets functions, but it can also offer examples of how the function might be used.
Not solely can Bard clarify Google Sheets capabilities, however it might probably additionally provide examples of how the operate is likely to be used.

To discover extra Google Sheets capabilities, you may then immediate:

Are there different Google Sheets capabilities that obtain one thing related?

Bard tends to supply a couple of different capabilities that assist with associated points of your preliminary job.

As well as, Bard may also help you create the precise components you want, however it could be a little bit of a strategy of trial and error. For instance, say you wish to analyze climate knowledge to establish what number of days the wind was predominantly from the west. First, strive an preliminary detailed immediate (Determine D).

I've a Google Sheet with knowledge in cells F2 by way of F367. The information is all numbers, from 0 to 359, and represents wind route, with 0 being the north and 270 being the west. I would love a components to point the share of days that the wind is from the west, the place the worth is anyplace between 240 and 270 levels. Are you able to present that?

Determine D

With a sufficiently detailed prompt, Bard can respond with a detailed code snippet that contains a Google Sheets function. While not necessarily always accurate, this snippet can often serve as the basis for the precise formula you want.
With a sufficiently detailed immediate, Bard can reply with an in depth code snippet that incorporates a Google Sheets operate. Whereas not essentially at all times correct, this snippet can typically function the premise for the exact components you need.

The response returned an =COUNTIF components that threw an error. After a fast overview of the operate, immediate once more, primarily asking Bard to strive once more:

I feel the vary indicator portion must be totally different. Possibly a logical AND not a textual content area?

This time, the response included a =COUNTIFS components. Choose the Copy Code button, change to the Google Sheet, navigate to the supposed vacation spot cell after which select Edit | Paste so as to add the components. This time, with a little bit of tweaking, the code snippet labored as desired (Determine E).

Determine E

With minor tweaks, the code snippet response provided by Bard delivered the desired calculation.
With minor tweaks, the code snippet response supplied by Bard delivered the specified calculation.

And that’s a great snapshot of how that you must work with Bard. If the preliminary response meets your wants, that’s nice! However at all times take the time to verify the outcomes for accuracy and be ready to immediate once more — and immediate in a different way — to evoke a extra related, helpful or correct response.