How to make a table from plain text in excel using python?

Question

Python

And so, there is text with camera numbers and their location. You need to make a table with two columns (see photo) For this, I chose a python. I do not know if this is the right choice, but in any case I will be glad to hear possible solutions. Here is the text itself:
north
camera1
camera2
camera3
camera4
west
camera5
camera6
camera7
camera9

Answer 1

def groups_to_columns(lines):
    directions = ['north', 'south', 'west', 'east']
    current_direction = None
    for line in lines:
        data = line.strip()
        if data in directions:
            current_direction = data
        else:
            yield current_direction, data


with open('data.txt') as fh:
    for direction, camera in groups_to_columns(fh):
        # Запись в xls

Answer 2

g: openpyxl
I use, the flight is normal.