Spreadsheet Generation in Glean
Glean can turn a chat prompt into a spreadsheet, or take a spreadsheet you already have and work with it in Canvas. Iterate on the rows and columns, then download a file or export it to Google Sheets, OneDrive, or SharePoint. You can also copy the table into another app.
Prerequisites
Spreadsheet generation is available wherever Glean and Canvas are enabled. Creating a spreadsheet doesn't require an admin template or separate setup. Exporting to OneDrive or SharePoint requires your admin to configure the corresponding Microsoft 365 upload tool. See Configure presentation and spreadsheet exports.
If you don't see the option to create a spreadsheet, the most common causes are:
- Canvas is not yet enabled for your organization.
- You need to hard-refresh the page after recent feature rollouts.
How spreadsheet generation works
Spreadsheet generation uses Canvas as the working surface. You describe the spreadsheet you want in chat, refine it with follow-up prompts to Glean, and then export it in your preferred format.
Start from chat
Ask Glean for a spreadsheet
In Glean, describe the spreadsheet you want. For example: "Build a spreadsheet comparing our top five competitors across pricing, target market, and key features."
Iterate with Glean in Canvas
Glean opens Canvas with a draft spreadsheet. Use follow-up prompts to add or remove columns, change which rows appear, restructure the data, or pull in additional sources until the spreadsheet matches what you need.
Export the spreadsheet
Use the export control in Canvas and choose a format or destination:
- Excel — downloads an
.xlsxfile you can open in Excel or any compatible application - Google Sheets — exports the spreadsheet directly to your Google Drive
- OneDrive — saves the selected
.xlsxversion to your OneDrive root folder - SharePoint — saves the selected
.xlsxversion to the SharePoint location you specify in chat - CSV — downloads a plain
.csvfile for use in any tool that accepts CSV input - Copy to clipboard — copies the table contents so you can paste them into another spreadsheet, doc, or message
Open and share
Open the exported file in Excel, Google Sheets, or your tool of choice to continue editing and share with your team.
Start from an existing Canvas
If you already have a Canvas open — for example, a brainstorm or research summary — you can ask Glean to turn the relevant content into a spreadsheet from the same Canvas without starting a new conversation.
Start from an existing spreadsheet
You can also bring an existing spreadsheet into Glean. Upload a file in chat and tell Glean what you want to do with it — for example, summarize it, restructure it, or pull additional data into new columns. Glean opens the spreadsheet in Canvas so you can iterate with follow-up prompts and then export the result.
Save to OneDrive or SharePoint
These Microsoft exports use the selected saved .xlsx version. They don't convert a CSV or another spreadsheet format to Excel.
To export a spreadsheet:
- Open the saved
.xlsxspreadsheet from chat or Library and select the version you want to export. Wait for generation to finish. - Open the export menu and choose Export to OneDrive or Export to SharePoint from the same dropdown.
- Sign in with your Microsoft account if prompted. After selecting Export to SharePoint, provide a site, document library, or folder name or link if Glean asks for a destination.
OneDrive saves the file to your root folder without prompting for a folder. SharePoint uses the destination already specified in chat or asks you to clarify it. This destination prompt happens after you choose the export option, including when you start from Library.
Selecting Export to SharePoint switches the chat to Thinking mode to find the destination and upload the file.
If an option is missing, confirm that the file is a saved .xlsx artifact and ask your Glean admin to check the upload tool and its connector association. See Microsoft 365 export limits for supported files and upload behavior.
What Glean generates
When you generate a spreadsheet, Glean produces:
- A structured table with column headers and rows based on the prompts you've given Glean.
- Content drawn from the company knowledge and sources referenced in your chat — for example, documents, tickets, and search results that Glean used to answer your prompt.
- A Canvas representation you can keep iterating on with Glean before exporting.
Use cases
Spreadsheet generation is designed to help with common tabular tasks, including:
- Competitive comparison tables — compare vendors, products, or features across consistent attributes
- Project trackers — compile status, owners, and dates from project tools and chat into a single sheet
- Metric roll-ups — aggregate numbers referenced across multiple documents or reports into one view
- Catalog and inventory extraction — pull structured lists out of long-form documents or search results
- Action-item tables — turn meeting notes or decisions into a tracked list of follow-ups
Tips for better results
- Describe the columns you want. Naming the columns up front (e.g., "columns for vendor, pricing tier, region, contract end date") gives Glean a clearer target.
- Iterate with follow-up prompts. Ask Glean to adjust columns, filter rows, or pull in additional sources until the spreadsheet looks right before you export.
- Reference internal sources. Ask Glean to pull from specific documents, projects, or teams so the rows are grounded in real data.
- Review after exporting. Treat the exported file as a starting point — verify cells against source-of-truth systems before sharing widely.
Frequently asked questions
See also
- Glean Canvas - Learn about using Canvas for content creation.
- Slide generation - Create branded presentations from Canvas content.
- Glean Assistant Best Practices - Tips for getting better results from Glean Assistant.