Can Perplexity read Excel files? Why does pasting raw CSV text sometimes work but not your actual sales_Q3.xlsx? Why does dragging the file into the chat window just show a paperclip icon—and nothing else?
Quick Answer
No—Perplexity cannot natively read, parse, or extract data from uploaded Excel (.xlsx, .xls) files. It treats them as opaque attachments, like PDFs or images. You must convert or extract the data first, then paste it as plain text, CSV, or Markdown tables.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Copy-paste range as plain text | Select A1:D10 → Ctrl+C → Paste in Perplexity | Small tables (<50 rows), clean formatting | No formulas, no merged cells, loses date formatting |
| Paste as Markdown table | Copy A1:D10 → Paste into Notepad++/VS Code → Convert with plugin or online tool → Paste Markdown | Readability, column alignment, multi-line cells | Extra conversion step; doesn’t handle formulas or formatting |
| Export to CSV + paste | File → Save As → CSV (Comma delimited) → Open in Notepad → Copy all → Paste | Large datasets, consistent delimiter needs | Drops formatting, formulas, multiple sheets, and non-UTF-8 characters (e.g., “£”) |
| Use Excel’s ‘Copy as HTML’ trick | Select range → Ctrl+C → Paste into Word → Right-click → Keep Text Only → Then paste into Perplexity | Preserving basic structure when plain text mangles spacing | Still loses formulas; extra app dependency (Word or LibreOffice) |
Method 1 Deep Dive
Let’s say you’re reviewing Q3 sales for Acme Corp’s regional team. Your Excel file has this data in Sheet1, range A1:D8:
| Rep Name | Region | Revenue | Date Closed |
|---|---|---|---|
| Sarah Chen | APAC | $45,200 | 2024-03-15 |
| James Okafor | EMEA | $38,900 | 2024-04-02 |
| Maya Rodriguez | Americas | $52,100 | 2024-04-18 |
| Kenji Tanaka | APAC | $29,400 | 2024-05-07 |
| Aisha Patel | EMEA | $41,750 | 2024-05-22 |
| Diego Morales | Americas | $33,600 | 2024-06-10 |
| Linh Nguyen | APAC | $47,800 | 2024-06-28 |
Select A1:D7 (yes, skip the header row if it’s auto-formatted weirdly—we’ll fix that in Perplexity). Press Ctrl+C. Now go to Perplexity and paste. You’ll get tab-separated values, which Perplexity reads cleanly—no commas to confuse it, no quotes needed. Bonus tip: If your numbers look misaligned after pasting, add a space before each value in Excel (e.g., " $45,200")—this forces left-alignment on paste. (Trust me, I learned this the hard way after three failed attempts with finance data.)
Method 2 Deep Dive
For reports where readability matters—say, you want Perplexity to help draft an email summarizing top performers—you’ll want clean column alignment. That’s where Markdown tables shine.
Start with the same A1:D7 range. Copy it. Open VS Code (free, lightweight), paste. Install the extension Markdown Preview Enhanced, then use its command palette (Ctrl+Shift+P → “Markdown: Convert Excel to Markdown Table”). Or use tablesgenerator.com.
You’ll get something like this:
| Rep Name | Region | Revenue | Date Closed | |----------------|----------|----------|-------------| | Sarah Chen | APAC | $45,200 | 2024-03-15 | | James Okafor | EMEA | $38,900 | 2024-04-02 | | Maya Rodriguez | Americas | $52,100 | 2024-04-18 | | Kenji Tanaka | APAC | $29,400 | 2024-05-07 |
Paste that directly into Perplexity. It understands pipe syntax perfectly—and keeps columns intact even when you ask, “Which reps closed deals after May 1st?” This method also survives copy-paste between browsers better than plain text. Surprising bonus: Perplexity will *infer data types* from Markdown headers—so if you label a column “Revenue ($K)”, it may treat values as numbers, not strings.
Cheat Sheet
| Task | Shortcut / Action | Notes |
|---|---|---|
| Copy Excel range as plain text | Select → Ctrl+C | Works best for ≤10 columns, no merged cells |
| Convert to Markdown table | VS Code + extension, or tablesgenerator.com | Paste full Markdown block—don’t break lines |
| Export to CSV safely | File → Save As → CSV (Comma delimited) (*.csv) | Avoid “CSV UTF-8” if using £, €, or accented names |
| Force Excel to paste as text only | In Excel: Alt+H, V, T (Home → Paste → Text) | Only works *after* copying—useful when pasting back into Excel, but confirms format purity |
| Verify Perplexity parsed your data | Ask: “How many rows are in this table?” | If it says “7”, you’re good. If “1”, your paste failed formatting. |
