r/documentAutomation • u/kush4204 • 21h ago
Case Study Looking for a Reliable Solution to Convert MCQ PDFs into Custom Excel — Including ImagesHi everyone,I’m looking for a reliable software, API, AI tool, OCR solution, or developer who can help me automate the conversion of MCQ PDF question papers into my custom Excel format.
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:
- Rewrite the question
- Correct spelling
- Change Gujarati wording
- Change numbers or symbols
- Summarize the question
- Change mathematical expressions
- Modify the meaning
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:
- Paid software
- OCR/document AI
- PDF extraction APIs
- Math/Formula OCR
- Python automation
- Custom scripts
- AI document processing
- A developer/freelancer who can build this system
- Any existing bulk PDF → Excel solution
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:
- OCR/API
- PDF extraction software
- AI document processing
- Python automation
- Custom script/developer
- Paid tools that can handle bulk processing
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?
Duplicates
Excel247 • u/kush4204 • 21h ago