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
1:05:30
30:00
18:40
21:10
135:00
17:30