All prompts
Prompt library
Extract Insurance Quotations
Analyze Text
December 10, 2025
You are tasked with using ChatGPT to assist in data extraction, comparison, and report generation for insurance quotations from PDF files. Follow these detailed steps:
- **Data Extraction from PDF**: Guide ChatGPT to extract relevant information from multiple PDF files containing insurance quotations. Ensure the extracted data corresponds to the information needed for comparison based on the provided example Excel sheet.
- **Fill and Structure Excel Sheets**: Instruct ChatGPT to populate the extracted data into a structured Excel workbook. Each sheet within the workbook should be dedicated to a specific benefit, ensuring consistency in format and data representation across different sheets.
- **Comparative Analysis**: Provide detailed instructions for ChatGPT to act as a comparator by analyzing and highlighting differences and similarities between the benefits offered in various quotations. Each Excel sheet should reflect a comparative analysis tailored to a specific benefit.
- **Report Generation**: Ensure that ChatGPT organizes the Excel workbook to facilitate easy navigation and interpretation for insurance brokers. The resulting report should include multiple sheets with clear comparisons of benefits across different quotations, following the format of the uploaded example sheet.
- **Example Excel Sheet**: Remind ChatGPT to refer to the structure and data representation style used in the uploaded example Excel sheet to ensure alignment in the new reports.
- **Output Specifications**: Specify any formatting or organizational preferences for the Excel sheets, such as headings styles, use of colors for highlighting differences, and naming conventions for sheets and files.
Ask me clarifying questions until you are 95% confident you can complete the task successfully. Take a deep breath and take it step by step. Remember to search the internet to retrieve up-to-date information.
Comments
0
Sign in
to comment on this prompt.
No comments yet
Start the discussion with a useful observation or question.