Snippet Files Truncating Data - Excel

Hi,

The agent does not read Excel files linearly. It retrieves chunks of content via a search mechanism, and the chunk size cannot be configured. This is consistent with what the community reports, though Microsoft has not formally documented the exact chunking limits for this experience.

That agents respond best to Excel data when it is on a single sheet within a workbook, which seems to be your case already. However, for tabular lookup data specifically, a SharePoint List tends to be a better fit as a knowledge source, with documented support for up to 20,000 rows and 50 MB of raw text.

That said, I want to be transparent : I do not have official Microsoft documentation confirming the 1,500-row threshold you mentioned, and the behavior may also vary depending on whether you are using Agent Builder or Copilot Studio directly. It would be worth clarifying which exact experience you are working in, as the knowledge source handling differs between the two.

The SharePoint List approach is the option I would suggest exploring first, before splitting your file.

Hope this helps