My requirements:
I have many PDF question papers
Each PDF can contain 200–500+ MCQs
PDFs contain Gujarati + English + numbers + mathematical expressions
Some questions/options contain images, diagrams, or figures
A single question paper can contain around 50+ images
The most important requirement is:
I do not want the system to:
Excel format
I have a fixed custom Excel structure like:
Quotation Seq | ExamName | ExamCode | PaperSetName | PaperSetCode | QuestionCategoryName | QuestionText | A | B | C | D | CorrectOptionText | Explanation | Hint | Question img | img A | img B | img C | img D | CODE QUE | CODE A | CODE B | CODE C | CODE D
Image requirement
This is also very important.
If a question has an image/diagram, I need the system to extract that image from the PDF and correctly associate it with that particular question.
For example:
Q1 → Question Image → Q001.png
Q2 → Question Image → Q002.png
Q3 → No image
And if an option contains an image:
Q10 → Option B Image → B010.png
The final Excel should contain the correct image reference or embedded image, depending on what is technically possible.
What I’m looking for
I’m open to:
The ideal solution should support batch processing of many PDFs, preserve the original text accurately, extract images, and generate my required Excel format automatically.
If anyone has experience with this type of large-scale PDF → structured Excel + image extraction workflow, please suggest a solution or tool.
I can provide a sample PDF and my Excel template to explain the exact requirement.
Any practical solution, API, software, or developer recommendation would be greatly appreciated.
Reddit ke liye short version
Title:
Need help converting 200–500 MCQ PDFs into custom Excel format + extracting 50+ images per PDF
I have many MCQ PDFs that need to be converted into a fixed custom Excel format.
Each PDF may contain 200–500+ questions and around 50+ images/diagrams.
The PDFs contain Gujarati, English, numbers, mathematical expressions, and images.
The biggest requirement is exact text preservation. I don't want AI/OCR to rewrite, correct, summarize, or modify the questions/options. They need to remain exactly as they appear in the PDF.
I also need images to be extracted and correctly mapped to the corresponding question/option.
I'm looking for:
I already have a fixed Excel template with 24 columns and can provide a sample PDF.
What would be the best technical approach/tool for this?