Use NamedTemporaryFile(mode="w", suffix=".py", delete=False).

importlib.util.spec_from_file_location works for known file name extensions (.py, .so, ...), but not for others (.txt...)