Video Metadata Extractor

A Python script that uses ffprobe to extract metadata from video files and generates an Excel report with details like resolution, audio/video codecs, frame rate, HDR status, and more.

Features

• Extracts detailed metadata for video files, including audio track information (track numbers, codecs, languages).
• Outputs an Excel file with structured metadata.
• Supports multiple directories for scanning.

Requirements

• Python 3.x
• ffmpeg installed and accessible via ffprobe.
• openpyxl library for Excel file creation.

Installation

1. Clone the repository:

   git clone https://github.com/CTinMich/Video-Metadata-Extractor.git

2. Navigate to the repository directory:

   cd video-metadata-extractor

3. Install dependencies:

   pip install -r requirements.txt

Usage

1. Open the script video_metadata_extractor.py in a text editor or IDE.
2. Locate the following lines:

   dirs = []  # Add your video directory paths here.
   output_path = ""  # Specify where the Excel report should be saved.

   • Add the paths to your video directories. For example:

     dirs = ["/path/to/videos", "/another/path/to/videos"]

   • Specify the output path for the report. For example:

     output_path = "/path/to/save/report"

3. Run the script:

   ./video_metadata_extractor.py

   If the script is not executable, you can explicitly run it using Python:

   python3 video_metadata_extractor.py

4. The Excel report will be saved to the specified path.

Example Output

The generated Excel file contains columns like:

• Full file path
• File size in GB
• Resolution (e.g., 1920x1080)
• Audio tracks (with track numbers, codecs, and languages)
• Video codec
• Video profile
• Bitrate (in kbps)
• Container type
• Frame rate (e.g., 23.976 fps)
• HDR/SDR status

Contributing

Feel free to fork the repository and submit pull requests. Issues and feature requests are welcome!

License

This project is licensed under the MIT License.

Notes

• The script uses the shebang #!/usr/bin/env python3 to ensure compatibility across different systems.
• Ensure Python 3 is installed and accessible in your system's PATH.