What problem does it solve?
Transform raw FAQ documents (Excel, Word, PDF, TXT) into a RAG-optimized, searchable knowledge base. This skill combines Claude-driven content expansion with automated formatting and keyword extraction to scale FAQ inventories from small sets to comprehensive, consistent knowledge bases, reducing manual editing time and improving retrieval accuracy.
Core Features & Use Cases
- Smart expansion: Claude reads long answers and splits them into focused Q&As that cover distinct topics.
- Automatic keywords: Uses jieba TF-IDF to generate searchable keywords for each entry.
- Multi-format support: Works with Excel, Word, PDF, and TXT sources to produce a standardized RAG-ready output.
- Quality checks: Deduplication and consistency validation to ensure reliable knowledge bases.
Quick Start
- Run: python process-faq/scripts/convert_to_markdown.py <input_file> # converts to Markdown for Claude
- Have Claude analyze and expand the content
- Run: python process-faq/scripts/generate_rag_faq.py <expanded_file.xlsx> <final_rag.xlsx> # produce final RAG KB