Forum Discussion

medhi's avatar
medhi
Copper Contributor
Aug 19, 2026

What is the best file format for an AI agent knowledge base?

This is a best practice sharing the best format for an agent and show you why you should convert your PPT, PDF, WORD into a TXT markdown.

I had an issue with my agent, time taken to answer was too long, and usually we spend a lot of time asking:

What is the best prompt? Why is my agent slow? Why does retrieval sometimes work and sometimes fail? How can I improve answer quality?

But I realised I was asking another question much less often:

What is actually the best file format for the knowledge base?


PDF? Raw text? Markdown? Pre-chunked text? Semantic sections? Context-enriched text?

And more importantly:

How much does the format alone affect agent performance?


I tried to find a quantified benchmark answering this specific question, with the same agent, same source knowledge and same questions, but different knowledge representations.

I couldn't find one that really answered what I wanted to measure. So I decided to run the experiment myself on a real case.

My first exploratory tests were already surprising: depending on the representation, the agent could be significantly faster and more accurate, despite working from the exact same source information.

So I decided to push the test further.

My objective

I want to identify, without assumptions and based on actual evaluation data, how a long document should be prepared for an LLM knowledge base so that the agent can retrieve, understand, ground and answer from it as reliably as possible.

I focused on five dimensions:

  • Answer quality
  • Retrieval reliability
  • Source grounding / citations
  • Execution time
  • Robustness across single-turn and multi-turn questions

The broader question I'm trying to answer is:

How should we structure knowledge so that an LLM can retrieve and use it as reliably as possible?

The test case

I deliberately chose a document that isn't particularly friendly for RAG: a 46-page European regulation, https://eur-lex.europa.eu/eli/reg/2011/1169/oj?locale=fr, on the provision of food information to consumers.

The information is distributed across articles, definitions, exceptions, annexes, tables, numerical thresholds and cross-references.

That makes it useful for testing retrieval: answering correctly often requires finding a very specific piece of information while preserving enough context to understand how it applies.

I used the native PDF as the baseline and created 6 additional knowledge-base representations of the same document:

  1. Raw TXT
  2. Markdown
  3. Chunk-ready TXT
  4. RAG-oriented units
  5. Semantic TXT
  6. Contextual TXT

One rule: same knowledge, same agent, same instructions, same questions. Only the knowledge representation changes.

The benchmark

I used two evaluation sets:

  • 42 single-turn questions testing broad coverage of the document: direct facts, thresholds, exceptions, annexes, lists and cross-references.
  • 5 multi-turn conversations containing 13 questions, to see what happens when a user asks a question and then follows up with things like:
    • "And in this case?"
    • "What are the exceptions?"
    • "And for dietary fibre?"

This gave me: 47 evaluated test cases / 55 actual questions per format

Across all 7 formats:

  • 329 evaluated conversations
  • 385 user questions executed

First results

MetricNative PDFBest structured representation
Overall pass rate66.0%85.1% - Contextual TXT
Best single-turn score69.0%88.1% - Chunk-ready TXT
Multi-turn benchmark40%80% - Contextual TXT
Multi-turn execution time14m245m54
Total benchmark time44m3124m49

 

The quality gap was already substantial: 66.0% → 85.1%

That's +19.1 percentage points while keeping the underlying knowledge unchanged.

I also saw a major difference in execution time.

On the multi-turn test: 14m24 → 5m54

That's approximately 2.4× faster.

Across the complete benchmark: 44m31 → 24m49

Around 44% less execution time.

These timings represent the complete agent evaluation pipeline, so they shouldn't be interpreted as pure LLM inference latency. But the difference under identical test conditions is large enough that I want to understand it better.

Findings

There wasn't one format dominating every benchmark.

Chunk-ready TXT scored highest on independent questions: 88.1%, while Contextual TXT performed better across multi-turn conversations and finished with the highest overall score.

That may suggest that the way we optimise a document for isolated retrieval isn't exactly the same as the way we should prepare it for conversational retrieval.

In the contextual version, I tried to make every section understandable when retrieved independently by keeping useful information around it:

  • Source references
  • Section context
  • Retrieval cues
  • Relevant cross-references

For regulatory documents, this seems particularly important.

A numerical value retrieved alone can be meaningless without knowing which rule it belongs to, under which conditions it applies, and whether another article contains an exception.

Where I am now

This remains an exploratory benchmark:

  • One document
  • One domain
  • One agent setup
  • One evaluation framework
  • One run per configuration

There are plenty of things I still want to test: repeated runs, retrieval-level evaluation, token consumption, larger knowledge bases, other document types, chunk sizes, overlap, contextual headers, and more.

But these first results already convinced me that the preparation of the knowledge base deserves much more attention when evaluating an agent.

We often spend hours refining instructions while the same information may behave very differently depending on how it reaches the retrieval layer.

Next step

I'll share the prompts, knowledge-base formats and evaluation methodology on GitHub so the experiment can be reproduced and challenged.

I'll keep enriching the repository as I test new formats, improve the evaluation set and add new results.

If people here have ideas, edge cases or formats worth testing, I'd genuinely like to include some of them in the next iteration.

What would you test next?

1 Reply

  • medhi's avatar
    medhi
    Copper Contributor

    New experiment: knowledge representation vs agent instructions

    After testing PDF and text-based knowledge sources, I moved to another common enterprise use case: Excel.

    For a relatively large workbook with around 10 worksheets, retrieval remained inconsistent. But on a more typical business dataset — a product catalogue — Excel performed surprisingly well when rows and columns already carried clear meaning.

    I then compared several representations of the same product knowledge:

    Knowledge representationPass rate
    Structured exports35–45%
    Alternative text representations35–45%
    Product-centric TXT — 1 product = 1 semantic block67%

    Then I changed only the agent instructions:

    • removed rigid response templates
    • removed artificial source sections
    • reduced unnecessary verbosity
    • reinforced grounding and native citations

    Result:

    67% → 91%

    Same knowledge base. Same data. Same evaluation set.

    What changed in my hypothesis

    I started by looking for the ideal knowledge-base format for an LLM.

    I'm now seeing more of a balance.

    The knowledge representation clearly matters: in this experiment, restructuring the data moved performance from roughly 45% to 67%.

    But once the data was structured well enough, instruction design became an even bigger lever:

    67% → 91%.

    So there seems to be a sweet spot between knowledge engineering and instruction engineering.

    A perfectly structured KB can still underperform if the agent is overloaded with constraints. And great instructions can only go so far when the underlying knowledge is difficult to retrieve.

    My question is therefore evolving from:

    “What is the best file format?” to “what is the right balance between knowledge representation, retrieval and agent instructions?”