AI Spreadsheets
AI Spreadsheets turn your study material into a real, editable spreadsheet — a .xlsx workbook with proper headers, clean rows, frozen panes, and working summary formulas. You can open it in Excel, Numbers, or Google Sheets, edit it, and keep using it.
Unlike pasting a table out of chat, an AI Spreadsheet is a structured workbook the AI builds on purpose, grounded in your sources.
Creating a Spreadsheet
Open AI Spreadsheets from the home page bento grid or the New menu. The create modal supports the same source types as Scholarly's other AI tools:
- Upload Files — PDFs, Word docs, PowerPoint, text files, images, audio, and existing spreadsheets you want to restructure.
- Prompt AI — describe what you want (no file required).
- Library — pick files you've already uploaded.
- Google Drive — connect your Drive and pick a Google Doc, Sheet, Slides deck, PDF, or Word doc directly. See Connected Apps.
For PDFs, you can also pick specific page ranges so the workbook is built only from the chapter or pages you care about.
Workbook Styles
Pick the layout the AI uses to organize your workbook:
- Data — A clean reference table. Best when your source is already tabular, like an exported question bank, a list of cases, or a glossary.
- Study Tracker — A spreadsheet to track your progress through a topic — readings, due dates, status, notes.
- Comparison Matrix — Rows are items, columns are attributes. Great for comparing concepts, cases, frameworks, or candidates.
- Review Planner — A study schedule with dates, sessions, materials, and check-in columns.
You can also leave the style on the default and let the AI choose based on your material.
Customization Options
- Custom instructions — Free text to steer the workbook ("a row per Supreme Court case from chapter 5, with columns for year, holding, and significance").
- Language — Generate the workbook in any of the languages Scholarly supports.
- AI model — Paid users can swap models. See Choosing an AI Model.
- Page selection — For PDFs, pick exactly which pages the workbook is built from.
You can pull from up to 3 sources at once for a single workbook.
Source-Grounded by Default
The AI never invents data. If your source doesn't say something, the workbook leaves that cell empty rather than making up a plausible-sounding number. When the AI does extract a fact from your material, it stays faithful to what the source says — not what it "should" say.
What You Get
Each finished workbook includes:
- A proper
.xlsxfile you can download and open in Excel, Numbers, or Google Sheets. - Frozen headers so the first row stays visible as you scroll.
- Working summary formulas with correct cell references for totals, averages, and counts where they make sense.
- Clean column widths and number formatting so the workbook looks intentional, not auto-generated.
The workbook opens in Scholarly's in-app spreadsheet viewer first. Use the menu to:
- Download the
.xlsxfile. - Open in a new tab for full-screen review.
- Share the workbook with anyone via a link.
- Edit inline — Scholarly's viewer supports basic edits, and any change is saved back to your library file. See Library Files.
Starting from Blank
If you'd rather start with an empty workbook and fill it in yourself, open the New menu and switch to the Blank tab. Blank Spreadsheet / Table creates an empty editable workbook in your library — no AI generation, no daily limit.
Tips
- For comparison work, name your columns in the custom-instructions box up front. "Columns: year, court, holding, dissent, why it matters" gives the AI an exact frame to fill in.
- Use Study Tracker when you want to do something with the workbook — fill in your progress, mark dates done. Use Data when you want a clean reference table.
- A Spreadsheet pairs well with a Study Guide — the guide explains the concepts, the spreadsheet keeps the facts organized.
Limits
AI Spreadsheets count toward your shared AI creation allowance, the same pool as flashcards, podcasts, video lectures, slides, and other AI tools. See Plans and Limits.
Related
- Library Files — every AI Spreadsheet is a real, editable file in your library.
- Study Guides — pair a spreadsheet with a written guide.
- Connected Apps — pull a Google Sheet or Google Doc directly into the create modal.