Google Bard can create spreadsheets for you — here's how

Google Bard depicted as a small cartoon bard making Google Sheets documents at a computer
(Image credit: Laptop Mag / Rael Hornby)

Google recently updated its AI chatbot, Bard, making it capable of understanding more complex prompts and providing more accurate answers with a deeper level of logic and reasoning. Alongside this update, Bard is also now capable of exporting spreadsheets and tables to Google Sheets, sparing you the boredom of that tedious task yourself.

It's also super-easy, and incredibly fast to do so. If you're looking to claw back a few minutes from your day and let Bard do the heavy lifting for you, then check out our guide on how to create spreadsheets with Google Bard.

How to create spreadsheets with Google Bard

Step 1: Head to Google Bard

(Image: © Laptop Mag / Rael Hornby)

Open up your browser of choice and head to bard.google.com. Once you're signed in to your Google Account, you should see a window like the one above (or in white if you don't have dark mode enabled!)

Step 2: Type your prompt

(Image: © Laptop Mag / Rael Hornby)

Near the bottom of this window is a text box, here's where you'll type (or speak by clicking the microphone icon to the right) your prompt.


As a Large Language Model (LLM), you can make requests of Bard using natural language and it should understand you fairly well. Go ahead and ask Bard to produce a spreadsheet or table for you.


You could try the following: 


"Hey Bard, can you make a spreadsheet/table...

  • ... of names and birthdays?"
  • ... comparing time zones around the world?"
  • ... showing the distance of objects in our solar system from Earth?"

Once you're done, hit Return (or Enter) on your keyboard or click the arrow to the right of the text box and Bard will begin to process and reply to your prompt.

Step 3: Check the results

(Image: © Laptop Mag / Rael Hornby)

Now, read through the results to make sure Bard hasn't missed the mark on your request. It should look similar to the window above (if not, we'll try to remedy that in our next step). If you want to adjust or amend your prompt, you can do so in the same box we used in the previous step.

Step 4: Switch drafts if needed

(Image: © Laptop Mag / Rael Hornby)

If your results don't seem to match the table in our images, or you want to see other ways Bard has interpreted your prompt, click "View other drafts" near the top-right of the chat box and switch between the available drafts until you find the most appropriate result.


If none of the drafts include a table, click the "Regenerate drafts" button after the third prompt. Or, if Bard still hasn't understood your request, try to rephrase your prompt to make it more clear.

Step 5: Export to Sheets

(Image: © Laptop Mag / Rael Hornby)

Once you've settled on the answer you want, and Bard has rendered a table of results for you, at the bottom of the table click "Export to Sheets" to begin converting Bard's answer into a Google Sheets file.

Step 6: Open in Sheets

(Image: © Laptop Mag / Rael Hornby)

When your file is ready, you'll be a pop-up box asking you if you'd like to go to the newly created Sheets file. Click "Open Sheets" to check out your new document.

Step 7: You're done!

(Image: © Laptop Mag / Rael Hornby)

That's it! You're done! You can now make changes to your Sheets document, rename it, populate it with more results and share it with others. Now that you've got the basics down, why not return to Bard with something a little more complex and see what else Google's AI-backed chatbot can rustle up for you.

Category
Arrow
Arrow
Back to Ultrabook Laptops
Brand
Arrow
Processor
Arrow
RAM
Arrow
Storage Size
Arrow
Screen Size
Arrow
Colour
Arrow
Screen Type
Arrow
Condition
Arrow
Price
Arrow
Any Price
Showing 10 of 305 deals
Filters
Arrow
Load more deals
Rael Hornby
Content Editor

Rael Hornby, potentially influenced by far too many LucasArts titles at an early age, once thought he’d grow up to be a mighty pirate. However, after several interventions with close friends and family members, you’re now much more likely to see his name attached to the bylines of tech articles. While not maintaining a double life as an aspiring writer by day and indie game dev by night, you’ll find him sat in a corner somewhere muttering to himself about microtransactions or hunting down promising indie games on Twitter.