GeminiBeginner

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.

6 minBeginner

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.

Gemini - attach menu
[ + ] Type a message... [ Send ]
+-----------------------------+
| Upload files |
| Add from Drive |
| Import code |
+-----------------------------+
The plus icon opens upload and Drive options.

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.

Gemini - compare two PDFs
You
Compare these two proposals. What changed in price, scope, and timeline?
Agent
Price rose from 8,000 to 9,500. Scope added a training session. Timeline extended by two weeks.
Attach both, then ask for the differences.

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.

prompt.txt
From the attached invoice, extract every line item into a table
with columns: Item, Quantity, Unit price, Total.
Export to Sheets in one click
When Gemini shows a table, look for the Export to Sheets button below it. That drops the table into a new Google Sheet so you skip the copy-paste cleanup.

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

Tags
#documents#pdf#files#chat