Key Benefits of Table Search in Knowledge Base

  • Natural-language queries: Ask plain-English questions on table data without formulas or filters.

  • Semantic search intelligence: Returns accurate, context-aware answers from relevant rows and columns.

  • Large CSV support: Handles up to 50,000 rows and 500 columns; select the 20 most relevant for indexing.

  • Beyond web/docs: Surfaces structured data that web pages and documents don’t capture well.

  • Bot enablement: Lets AI employees handle customer records, product catalogs, KPIs, and similar tabular use cases.

How to Setup Table Search in Knowledge Base

  1. Open AI Agents → Knowledge Base.

  2. Edit an existing Knowledge Base, or click Create Knowledge Base and give it a name & description.

  3. Click Add Source, then choose Table s.

  4. Upload your CSV file using drag-and-drop or file picker. (Max 50 MB).

  5. Review detected columns; adjust data types if needed.

  6. Click Done to index the table. Progress shows chunking status.

  7. Attach the Knowledge Base to your AI Agent (Chat, Voice, or Workflow AI) as usual.

  8. Test a sample question like “Which customers have overdue invoices?” to confirm results.

CSV File Requirements

Understanding the file specifications ensures a flawless upload.

  • Format: .csv only (UTF-8 recommended)

  • Size limits: 50,000 rows and 500 columns per location (select the 20 most relevant columns), upload files up to 50 MB.

  • Header row: First row must contain column names

  • Data types: Automatic schema detection with 80 % confidence threshold

  • Clean data: Remove null values, hidden formulas, merged cells, etc

The CSV can be rejected at several points. For example, if the format of the CSV is accepted, the data itself might still contain an error.

In this case you can inspect the CSV manually in a spreadsheet program or even a text editor.

Semantic Search Intelligence

FrequencyOS converts each table row into vector embeddings so the bot can “understand” meanings rather than exact words. This enables queries like “Show me customers who complained about billing” or “Which orders shipped overnight last week?” The engine compares the user’s question to every row chunk and returns the most semantically similar matches—no SQL needed.

Smart Table Processing

Behind the scenes, FrequencyOS:

  • Detects column types (text, number, date, etc.) with 80 % accuracy

  • Chunks rows into groups of five (max 2,000 characters) for efficient indexing

  • Stores chunk metadata so answers can reference the correct records

Q: Can I upload Excel (.xlsx) files?

Not yet—export or save your sheet as CSV before uploading.

Q: How soon are new CSV uploads available to bots?

Typically within a few minutes—the indexing progress bar will show when processing is complete.

Q: Does Table Search support filters or sorting in the query?

Filtering, comparison, and sorting features are coming soon; for now, ask descriptive questions or refine with follow-ups.

Q: Will table data appear in the Response Info sidebar?

Yes—rows that informed the answer are cited, so you can verify or edit them on the spot.

Q: Can I restrict table access to specific bots?

Yes—only bots linked to the Knowledge Base containing your Table Source can query it.

Q: How is privacy handled for sensitive CSV data?

Table Sources inherit existing Knowledge Base security; only users with access to that Knowledge Base can see or query the data.

Yes

That’s Great!

Sorry! We couldn't be helpful

*

!*

Please give your comments

requires verification.

Privacy - Terms

!