MCQ Format Converter

A simple desktop application that converts Multiple Choice Questions (MCQ) from text files to Excel format.

Screenshot

What it does

This tool takes a text file containing MCQs and converts them into a well-formatted Excel spreadsheet. Each question and its options are separated into individual rows for better readability.

Features

• Easy to use GUI - Simple interface with browse buttons
• Progress tracking - Shows conversion progress with a progress bar
• Error handling - Clear error messages if something goes wrong
• Automatic formatting - Questions and options are properly formatted in Excel
• Supports large files - Can handle 50+ questions efficiently

How to use

1. Run the program: Double-click mcq_converter.py or run python mcq_converter.py
2. Select input file: Click "Browse..." to choose your MCQ text file (.txt)
3. Choose output location: Click "Save as..." to select where to save the Excel file
4. Convert: Click "Convert to Excel" button
5. Done! Your Excel file will be created with properly formatted MCQs

Input format

Your text file should have questions formatted like this:

Q1. What is the primary purpose of data visualization? A. To store data in a structured format B. To manipulate data for analysis C. To present data visually for easier understanding D. To clean and preprocess data

Q2. Which chart is best for trends over time? A. Pie chart B. Bar chart C. Line chart D. Scatter plot

Output format

The Excel file will have each question split into separate rows:

Q1. What is the primary purpose of data visualization?
A. To store data in a structured format
B. To manipulate data for analysis
C. To present data visually for easier understanding
D. To clean and preprocess data

Q2. Which chart is best for trends over time?
A. Pie chart
B. Bar chart
C. Line chart
D. Scatter plot

Requirements

• Python 3.6 or higher
• Required libraries: tkinter, openpyxl

Installation

1. Make sure Python is installed on your computer
2. Install required library: pip install openpyxl
3. Download the mcq_converter.py file
4. Run the program: python mcq_converter.py

Developer

This software is designed and developed by Krutarth Raychura.

---

Simple, fast, and reliable MCQ conversion tool for educators and students.