Fix Microsoft Copilot Chat Not Finding TXT or CSV Files
Question details
The user is unable to locate TXT or CSV files using document searches in Microsoft Copilot Chat, and manually pasted links to these files are not recognized.
- Product
- Microsoft Copilot for Microsoft 365
- Device & OS
- not provided
- Scenario
- Attempting to search for or query data from plain text (TXT) and comma-separated values (CSV) files using Copilot Chat.
- Observed behavior
- Copilot Chat does not return TXT or CSV files in document search results and fails to process direct links to these file types when pasted manually.
Ensure your TXT and CSV files are properly saved and fully synced to your OneDrive or SharePoint account, as Copilot relies on the Microsoft 365 index to discover documents.
Convert TXT and CSV Files to Supported Office Formats
Because Microsoft Copilot natively favors standard Office formats like DOCX and XLSX, converting your files is the quickest workaround to force indexing.
While Microsoft continues to expand Copilot's capabilities, its search indexing and chat features are primarily optimized for Word, Excel, and PowerPoint files. Converting plain text and basic spreadsheet files ensures Copilot can reliably read and analyze the data.
Open your CSV file using Microsoft Excel, or open your TXT file using Microsoft Word.
Click on 'File', select 'Save As', and choose '.xlsx' for spreadsheets or '.docx' for text documents. Save the new file to your OneDrive or SharePoint.
Allow a few moments for the new file to sync to the cloud and be indexed by Microsoft Search, then try querying Copilot Chat again using the new file name.
Report to the Microsoft Copilot Community
If converting files is not an option, report the limitation directly to Microsoft Copilot specialists who can provide updates on service limitations.
Manage and Analyze Your Spreadsheets Easily with WPS Office
If you are frustrated by Copilot's file indexing limitations or compatibility issues with CSV and TXT files, try WPS Office. It is a powerful, free alternative that easily opens, edits, and manages a wide range of document formats without the hassle.
- 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install and launch: Run the installer, follow the on-screen prompts to complete the setup, and open WPS Office.
- 3. Open your files: Drag and drop your CSV or TXT files directly into the WPS workspace to instantly view and edit your data.
Frequently Asked Questions
Does Microsoft Copilot support TXT and CSV files natively?
Copilot for Microsoft 365 is currently optimized for primary Office formats like DOCX, XLSX, and PPTX. While it may occasionally retrieve basic text files, support and indexing for CSV and TXT files in Copilot Chat can be inconsistent or entirely absent depending on the environment.
Why does Copilot Chat ignore links I manually paste?
Copilot checks the format and permissions of the destination file when a link is pasted. If the link points to an unsupported file type like a raw CSV, or if the file hasn't been properly indexed by Microsoft Graph, Copilot will fail to recognize or read the link.
How long does it take for a file to appear in Copilot search?
Copilot relies on the Microsoft 365 Search index. When you upload a new document to OneDrive or SharePoint, it can take anywhere from a few minutes to a few hours for the file to be fully indexed and searchable within Copilot Chat.
