When you upload an Excel file to Perplexity Pro, the AI may fail to read the content or return an error message. This usually happens because Perplexity expects data in a plain-text or structured format that Excel files do not provide by default. The root cause is that Perplexity does not natively parse .xlsx or .xls binary formats — it requires the data to be converted into a readable text format. This article explains why the error occurs and provides a reliable fix using Microsoft 365 tools and manual conversion steps.
Key Takeaways: Fix Perplexity Pro Excel Read Errors
- Convert .xlsx to CSV via Excel: Save your Excel file as a comma-separated values file (CSV) before uploading to Perplexity.
- Use Notepad for final check: Open the CSV in Notepad to verify all data is plain text with no hidden formatting.
- Upload CSV instead of .xlsx: Perplexity Pro can read CSV files reliably because they contain only plain text.
Why Perplexity Pro Cannot Read Excel Files
Perplexity Pro is designed to process text-based content such as PDFs, web pages, and plain-text documents. It does not include a built-in parser for Microsoft Excel binary formats like .xlsx or .xls. When you upload an Excel file, Perplexity attempts to extract text but often fails because the file contains structured cells, formulas, charts, and formatting that the AI cannot interpret.
The error appears as a generic message such as “Unable to read file” or “File format not supported.” This is not a bug in Perplexity — it is a limitation of the current file ingestion pipeline. The only workaround is to convert the Excel data into a format that Perplexity can parse, such as CSV (comma-separated values) or plain text.
What CSV Does That Excel Cannot
CSV files store data as rows of plain text with commas separating each column. There are no formulas, merged cells, or conditional formatting. This stripped-down structure allows Perplexity to read every cell value as a string. The AI can then process the data for analysis, summarization, or querying.
Steps to Convert Excel Files for Perplexity Pro
Follow these steps to convert your Excel file to a CSV and upload it to Perplexity Pro. You need Microsoft Excel (desktop or web) and a plain-text editor like Notepad.
- Open the Excel file in Microsoft Excel
Launch Excel and open the .xlsx or .xls file that Perplexity could not read. Ensure all data you want to analyze is visible in the worksheet. - Check for merged cells and formulas
Merged cells and formulas may cause data loss during conversion. Unmerge any merged cells by selecting them and going to Home > Merge & Center > Unmerge Cells. For formulas, copy the cell values: select the range, press Ctrl+C, then right-click and choose Paste Values. - Save as CSV UTF-8 format
Click File > Save As. Choose a location on your computer. In the “Save as type” dropdown, select CSV UTF-8 (Comma delimited) (.csv). If that option is not available, select CSV (Comma delimited) (.csv). Name the file and click Save. - Close the file and confirm the save
Excel may show a warning that only the active sheet is saved. Click OK. Then close the file. When prompted, do not save changes to the original .xlsx file — click Don’t Save. - Open the CSV in Notepad to verify
Right-click the new .csv file and select Open with > Notepad. You should see rows of text separated by commas. If you see garbled characters or missing data, repeat step 2 and ensure all cells contain plain text values. - Upload the CSV to Perplexity Pro
In Perplexity Pro, click the attachment icon (paperclip) and select the CSV file. The AI will now read the file contents. You can ask questions about the data or request a summary.
Alternative: Copy and Paste as Plain Text
If you do not want to create a CSV file, you can copy the Excel data and paste it directly into the Perplexity chat box as plain text. Select the cells in Excel, press Ctrl+C, then in Perplexity press Ctrl+V. The AI will treat the pasted content as a table. This method works for small datasets (under 50 rows).
If Perplexity Still Cannot Read the CSV File
Even after conversion, some CSV files may cause errors. Here are the most common issues and their fixes.
CSV Contains Special Characters or Line Breaks Inside Cells
Excel cells that contain line breaks (Alt+Enter) or special characters like commas within quotes may break the CSV structure. To fix this, open the CSV in Notepad. Look for rows with mismatched quote marks. Remove any extra line breaks by replacing them with spaces. Save the file and upload again.
File Size Exceeds Perplexity Upload Limit
Perplexity Pro has an upload limit of approximately 25 MB per file. If your CSV is larger, split the data into multiple files. In Excel, filter the data by rows and save each subset as a separate CSV. Upload each file one at a time.
Data Is Encrypted or Protected
If the original Excel file has worksheet protection or password encryption, the CSV conversion may produce an empty file. Remove protection in Excel: go to Review > Unprotect Sheet. Then repeat the save-as-CSV steps.
Perplexity Pro File Upload Limits: Supported vs Unsupported Formats
| File Type | Supported by Perplexity Pro | Notes |
|---|---|---|
| .xlsx (Excel workbook) | No | Perplexity cannot parse binary Excel formats |
| .xls (Excel 97-2003) | No | Same limitation as .xlsx |
| .csv (Comma-separated values) | Yes | Plain text format; works reliably |
| .txt (Plain text) | Yes | Best for raw data without columns |
| .pdf (Portable Document Format) | Yes | Perplexity can extract text from PDFs |
Use CSV or TXT files when you need to upload spreadsheet data. PDF is also supported but may lose table structure during extraction.
You can now convert any Excel file to CSV and upload it to Perplexity Pro without errors. Use the Notepad verification step to catch formatting problems before uploading. For large datasets, split the CSV into multiple files and upload them sequentially. As an advanced tip, use Excel’s Text to Columns feature (Data > Text to Columns) to clean messy data before saving as CSV — this ensures each cell value stays in its own column during conversion.