Artificial Intelligence1 min read

Get answers from tables with tabular search in Amazon Bedrock Managed Knowledge Base

By · Published by Everything Blog

In short

The capability natively supports CSV, XLSX, and XLS formats without requiring any additional settings on existing retrieval requests. It operates by running code over every relevant row across multiple sheets to perform calculations and lookups. The system then merges these tabular metrics with related prose documents, such as pairing financial figures against written policy thresholds. Responses supply source citations for text files, while the system trace logs the exact workbook examined.

Key points

  • Users gain the ability to answer complex, multi-step questions that merge computational d…: Users gain the ability to answer complex, multi-step questions that merge computational data with unstructured narrative text.
  • Spreadsheets are evaluated in full, overcoming standard document splitting limitations th…: Spreadsheets are evaluated in full, overcoming standard document splitting limitations that frequently omit crucial data rows.
  • The capability is natively incorporated into existing retrieval requests without requirin…: The capability is natively incorporated into existing retrieval requests without requiring users to configure separate operational settings.

Sources checked by our analysis pipeline: 1

Artificial Intelligence

Get answers from tables with tabular search in Amazon Bedrock Managed Knowledge Base

Amazon Bedrock Managed Knowledge Base now supports tabular search, so you can get answers from tables through agentic retrieval. When a question needs data from CSV, XLSX, or XLS files, tabular search looks up values and runs calculations across every relevant row in one or more tables or sheets. It then combines the results with facts from related documents to answer analytical questions that take several steps.

A finance team closing the quarter needs to know “Which departments must write variance commentary?” No single file has the answer. It depends on the variance policy’s threshold, the quarter-close memo’s budget revisions, and math over every department in the profit and loss (P&L) workbook.

Like this finance team, most teams keep their narratives and data in the same place. For example, a Microsoft SharePoint site holds workbooks next to policies, and an Amazon Simple Storage Service (Amazon S3) bucket holds CSV exports next to PDFs. Tabular search answers questions across these files through the same AgenticRetrieveStream

request…

Artificial Intelligence