...
Once created it shall be possible to use API Token for logging into Jira from Excel Connector (same input field as for password based logging in):
...
The below content will present on an example, how to create such token and how to use it with Excel Connector add-in: