Is this a feasible Macro? Extracting details from text file?

As an alternative, something could be written combining Keyboard Maestro and Python (Python Example Code? would be a useful resource) with the Openpyxl library to read an xlsx file even if it is not open on your mac at the time.