AI preprocessing: Extract text from Excel files and convert them into QA format CSV files

Dividing the input data used in RAG into questions and answers will lead to improved accuracy of the generative AI's answers.
This application loads an Excel file into Claude, an LLM, extracts text from the Excel file, and splits the content into questions and answers. The conversion results are output as a CSV file.
By using this application, you can efficiently prepare data, which is essential for generative AI, contributing to cost reduction and improved response quality.

Script Details

Convert Excel files to CSV files in QA format

Excel_To_QA_Claude_convert

Extract data from an Excel file by sheet

Excel_To_QA_Claude_dump_sheet_text

Checking the limit value for the number of tokens required for Excel file conversion

Excel_To_QA_Claude_validate_limits

Export text extracted from Excel file to CSV file in QA format

Excel_To_QA_Claude_convert_to_csv

• Download specifications
• Try HULFT Square

How to install and use it