VTT to Excel Converter

This Python application reads two VTT (WebVTT) files, combines their entries based on specific logic, and writes the combined entries to an Excel file. The application uses the openpyxl library to create and manipulate the Excel file.

Features

• Parses VTT files to extract timestamps and values.
• Combines entries from two VTT files based on their timestamps.
• Writes the combined entries to an Excel file with columns for source and translated timestamps and values.
• Adds additional "Reviewer 1 Suggestion" and "Reviewer 2 Suggestion" columns in the Excel file.

Requirements

• Python 3.x
• openpyxl library

Installation

1. Clone the repository or download the script:

   git clone https://github.com/yourusername/vtt-to-excel.git
   cd vtt-to-excel

2. Install the required library:

   pip install openpyxl

   Or, if using pip3 for Python 3:

   pip3 install openpyxl

Usage

1. Prepare your VTT files:

   • Ensure you have two VTT files: source.vtt and translated.vtt.

2. Run the Python script:

   python convertionvtt.py

   Or, if using Python 3:

   python3 convertionvtt.py

3. Check the output:

   • The script will generate an Excel file named TheOutput.xlsx in the same directory.

Explanation of the Code

parse_vtt_file(file_path)

This function reads a VTT file and parses the entries to extract timestamps and values.

combine_entries(source_entries, translated_entries)

This function combines the source and translated entries based on the following logic:

• When Source Timestamp equals Translated Timestamp, they are placed on the same row.
• When Source Timestamp is greater than Translated Timestamp, the translated timestamp values are kept, and the source timestamp and source value are left empty/blank for that row.
• When Source Timestamp is less than Translated Timestamp, the source timestamp values are kept, and the translated timestamp and translated value are left empty/blank for that row.

write_to_excel(combined_entries, file_path)

This function writes the combined entries to an Excel file using the openpyxl library. It creates a new Excel file with columns for source and translated timestamps and values, and additional "Reviewer 1 Suggestion" and "Reviewer 2 Suggestion" columns.

main()

This function orchestrates the process by calling the above functions and printing a success message.

Example

1. Sample source.vtt:

   00:00:01.000 --> 00:00:05.000
   Hello, world!
   
   00:00:06.000 --> 00:00:10.000
   This is a test.
   

2. Sample translated.vtt:

   00:00:01.000 --> 00:00:05.000
   Hola, mundo!
   
   00:00:07.000 --> 00:00:11.000
   Esto es una prueba.
   

3. Generated TheOutput.xlsx:

   Source Timestamp	Source Value	Translated Timestamp	Translated Value	Reviewer 1 Suggestion	Reviewer 2 Suggestion
   00:00:01.000	Hello, world!	00:00:01.000	Hola, mundo!
   00:00:06.000	This is a test.
   		00:00:07.000	Esto es una prueba.

AddDisclaimer

This Python application reads a VTT (WebVTT) file called translated.vtt, adds 00:00:03 to every timestamp, and writes the modified content to a new VTT file called translatedPlusDisclaimer.vtt. Any other value which is not a timestamp remains unchanged.

Features

• Parses VTT files to extract timestamps.
• Adds a specified number of seconds (00:00:03) to each timestamp.
• Writes the modified timestamps and other unchanged content to a new VTT file.

Requirements

• Python 3.x

Usage

1. Prepare your VTT file:

   • Ensure you have a VTT file named translated.vtt in the same directory as the script.

2. Run the Python script:

   • Open a terminal and navigate to the directory where the script is saved.
   • Run the script using Python:

     python AddDisclaimer.py

     Or, if using Python 3:

     python3 AddDisclaimer.py

3. Check the output:

   • The script will generate a new VTT file named translatedPlusDisclaimer.vtt in the same directory.

Explanation of the Code

add_seconds_to_timestamp(timestamp, seconds)

This function parses a VTT timestamp string into hours, minutes, and seconds, adds the specified number of seconds, and returns the new timestamp string in the same format.

add_disclaimer_to_vtt(input_file, output_file, seconds_to_add)

This function reads the input VTT file line by line. For lines containing timestamps (-->), it parses the start and end times, adds the specified number of seconds, and writes the modified timestamps to the output file. For other lines, it writes them unchanged to the output file.

main()

This function orchestrates the process by defining the input and output file names and the number of seconds to add. It calls the add_disclaimer_to_vtt function to process the VTT file and prints a success message.

Example

1. Sample translated.vtt:

   WEBVTT
   
   00:00:01.000 --> 00:00:05.000
   Hello, world!
   
   00:00:06.000 --> 00:00:10.000
   This is a test.
   

2. Generated translatedPlusDisclaimer.vtt:

   WEBVTT
   
   00:00:04.000 --> 00:00:08.000
   Hello, world!
   
   00:00:09.000 --> 00:00:13.000
   This is a test.
   

License

This project is licensed under the MIT License. See the LICENSE file for details.

Contributing

Contributions are welcome! Please open an issue or submit a pull request for any improvements or bug fixes.

Contact

For any questions or suggestions, please contact @fatenhealy [email protected].