In this categoryGemini ยท 24
- How to Install the Gemini CLI and Run Your First PromptStart
- How to Get a Gemini API Key from Google AI Studio
- How to Call the Gemini API from Python
- How to Give Gemini CLI Project Context with a GEMINI.md File
- How to Choose the Right Gemini Model for Coding Tasks
- How to Fix a Bug in Your Codebase with the Gemini CLI
- How to Set Up Gemini Code Assist in VS Code
- How to Stream Gemini Responses in Node.js
- How to Feed a Long Document into Gemini's Long Context
- How to Run the Gemini CLI Non-Interactively in Scripts
- How to Analyze a Video File with the Gemini API
- How to Connect an MCP Server to the Gemini CLI
- How to Fix Common Gemini CLI Authentication Errors
- How to Cache Long Context in the Gemini API to Cut Costs
- How to Summarize a YouTube Video with Gemini
- How to Analyze PDFs and Docs in the Gemini Chat App
- How to Extract Data from Images and Screenshots with Gemini
- How to Generate a Short Video with Veo in Gemini
- How to Ground Gemini Answers in Your Own Documents
- How to Use Gemini Inside Google Docs to Draft Faster
How to Analyze PDFs and Docs in the Gemini Chat App
Upload PDFs, spreadsheets, and Google Docs into the Gemini web app and ask questions, compare them, and extract tables.
You do not need the API to put documents into Gemini. The chat app at gemini.google.com lets you attach files and Drive documents, then ask questions about them in plain language. This guide covers uploading, asking cross-file questions, and pulling out a table you can paste into a sheet.
What you need
- A Google account signed in at gemini.google.com
- One or more PDFs, or Google Docs in your Drive
- A clear question you want answered from them
Step 1: Attach your files
Click the + (or paperclip) icon next to the prompt box. Choose Upload files to add PDFs from your computer, or Add from Drive to bring in Google Docs and Sheets without downloading them.
Step 2: Ask a question across the files
Once the files show as attached, type your question. You can attach several documents and ask Gemini to compare them, which is handy for spotting differences between two contract drafts or two proposals.
Step 3: Extract a clean table
Ask Gemini to pull data into a table and it will format the output so you can copy it straight into Sheets or Excel. Specify the columns you want to keep it tidy.
From the attached invoice, extract every line item into a table
with columns: Item, Quantity, Unit price, Total.Result
You can interrogate documents conversationally, compare multiple files at once, and lift structured data out of them into a spreadsheet, all from the chat app with no setup beyond signing in.
Watch related tutorials
30:00
21:10
24:16
16:12
3:58:44
1:05:30New guides in your inbox
Fresh step-by-step how-to guides as we publish them. One email a week, no more.