How to use Google Bard with Google Sheets (Updated for 2024)

Google Bard tin assistance you make contented and calculations for Google Sheets. In the archetypal role, Bard serves arsenic a astute database generator that produces contented successful a array for you to export to a Google Sheet. In the second role, Bard’s responses assistance you devise Google Sheets formulas and functions. These uses of Bard connection capabilities that widen beyond the modular autofill and correction capabilities successful Google Sheets.

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

For the actions below, you’ll request to beryllium signed successful to an progressive Google relationship authorized to usage some Google Sheets and Google Bard. If you usage a Google Workspace relationship for enactment oregon school, you whitethorn request to interaction an head to petition entree to Bard. Once you person access, unfastened Bard successful immoderate modern browser to get started. Enter a earthy connection prompt, and Bard volition supply a response. Bard responses whitethorn disagree — 2 radical who participate the aforesaid punctual whitethorn not person the aforesaid response.

How to get contented from Bard for a Google Sheet

With Bard, you tin punctual the strategy for each sorts of comparisons and lists. For example, a petition to comparison 2 oregon much products mightiness nutrient a array with a file for each merchandise and each enactment with a antithetic examination diagnostic (Figure A). You mightiness besides punctual Bard for lists of things, specified arsenic people, places oregon things. Since Bard accepts sequences, you mightiness archetypal prompt:

List the 10 cities successful the United States with the astir yearly rainfall.

Then, aft you person the archetypal response, punctual again with:

Add a file for the population.

Figure A

Bard tin assistance you rapidly get each sorts of comparisons and lists. When Bard provides a effect successful a table, prime Export To Sheets to make a caller Google Sheet with the array contents.

The tables Bard tin make arsenic a effect alteration overmuch much than accepted autocomplete sequences disposable successful Google Sheets with the Tools | Autocomplete | Enable Autocomplete Option enabled.

In Google Sheets, you participate a predictable bid of alphabetical letters, numbers, days of the week, months oregon different modular patterns successful 2 oregon much cells. Then prime the cells and select-and-extend the country of the container to screen the full scope of to-be-filled cells. For example, if you benignant Mon successful 1 compartment and Tue successful an adjacent cell, you whitethorn prime those 2 cells and past resistance the dot to capable different 5 cells with the remaining respective three-character descriptions of days of the week successful English. In contrast, the tables you tin punctual Bard to make whitethorn comprise a overmuch wider scope of listable data.

Choose Export To Sheets

When a effect includes a table, prime the Export To Sheets enactment astatine the lower-right country of the table. This exports the array to a caller Google Sheet (Figure A). The strategy volition usage your punctual arsenic some the sanction of the recently created record and the archetypal expanse wrong the file. The contents of the array volition beryllium placed successful the cells of the sheet, with the titles of the columns successful Row A.

Prompt “in a table”

Bard volition often automatically format comparisons and lists successful a table. When the strategy doesn’t bash this, adhd the operation “in a table” to your request. This would marque the punctual listed supra to be:

In a table, database the 20 cities successful the United States with the astir yearly rainfall.

View different drafts oregon reset chat

Sometimes Bard provides either a partial effect oregon an oddly formatted response. For example, effort the prompt:

List each 50 U.S. states sorted by population.

Bard returned a array of 40 states, which is an incomplete response. In different example, a punctual for a:

List of elements by sanction and atomic weight.

In response, Bard produced a database formatted arsenic a codification snippet, not a table. When a effect isn’t what you expect, prime the View Other Drafts fastener to entree alternate drafts (Figure B). In immoderate cases, 1 of those drafts volition beryllium formatted arsenic a array alternatively than a codification snippet.

Another enactment erstwhile this benignant of mistake occurs is to commencement a caller chat (as shown successful Figure B successful the precocious left) and past effort again with a rephrased prompt. This whitethorn instrumentality a much implicit oregon better-formatted response.

Figure B

View different drafts to entree alternatively formatted responses, which sometimes show information successful a array alternatively than a database format. In immoderate cases, selecting Reset Chat and trying your punctual again whitethorn instrumentality a effect successful the format you want.

How to get assistance from Bard with a Google Sheets calculation

You whitethorn punctual Bard to explicate and supply examples of Google Sheets formulas and functions. Unlike Google Sheets assistance pages, which supply details and a static acceptable of examples, you whitethorn inquire Bard for a assortment of examples, on with a elaborate statement of however a diagnostic works.

For example, if you privation to larn a spot much astir 1 of the new functions Google added to Sheets successful March 2023, you mightiness prompt:

How bash I usage the WRAPCOLS relation successful a Google Sheet? Can you springiness an illustration of however I mightiness usage it to radical a database of worker names into groups of 4 radical each?

The effect from Bard (Figure C) included, successful sequence:

• A statement of however the relation is used.
• A codification snippet illustration of the syntax with each portion listed.
• A illustration look to radical a database into a acceptable of four.
• An illustration with demo names.
• Additional codification examples to radical a database into sets of three, 5 oregon seven.

Figure C

Not lone tin Bard explicate Google Sheets functions, but it tin besides connection examples of however the relation mightiness beryllium used.

To research further Google Sheets functions, you mightiness past prompt:

Are determination different Google Sheets functions that execute thing similar?

Bard tends to connection a fewer different functions that assistance with related aspects of your archetypal task.

In addition, Bard tin assistance you make the nonstop look you need, but it whitethorn beryllium a spot of a process of proceedings and error. For example, accidental you privation to analyse upwind information to place however galore days the upwind was predominantly from the west. First, effort an archetypal elaborate punctual (Figure D).

I person a Google Sheet with information successful cells F2 done F367. The information is each numbers, from 0 to 359, and represents upwind direction, with 0 being the northbound and 270 being the west. I would similar a look to bespeak the percent of days that the upwind is from the west, wherever the worth is anyplace betwixt 240 and 270 degrees. Can you supply that?

Figure D

With a sufficiently elaborate prompt, Bard tin respond with a elaborate codification snippet that contains a Google Sheets function. While not needfully ever accurate, this snippet tin often service arsenic the ground for the precise look you want.

The effect returned an =COUNTIF look that threw an error. After a speedy reappraisal of the function, punctual again, fundamentally asking Bard to effort again:

I deliberation the scope indicator information needs to beryllium different. Maybe a logical AND not a substance field?

This time, the effect included a =COUNTIFS formula. Select the Copy Code button, power to the Google Sheet, navigate to the intended destination compartment and past take Edit | Paste to adhd the formula. This time, with a spot of tweaking, the codification snippet worked arsenic desired (Figure E).

Figure E

With insignificant tweaks, the codification snippet effect provided by Bard delivered the desired calculation.

And that’s a bully snapshot of however you request to enactment with Bard. If the archetypal effect meets your needs, that’s great! But ever instrumentality the clip to cheque the results for accuracy and beryllium prepared to punctual again — and punctual otherwise — to evoke a much relevant, utile oregon close response.