How to create API Token

Atlassian has recently changed approach for logging-in of third party sites / applications into Jira. Basic authentication using username and password will not be possible eventually and one shall create appropriate API Token.

Please refer to official documentation about obtaining API Token here - https://confluence.atlassian.com/cloud/api-tokens-938839638.html

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:

Log in to your profile and then as marked with (1) access your profile settings, then click on "Manage your account" (2):

2. On a newly loaded screen proceed with accessing "Security (1) and then "Create and manage API tokens (2):

3. If you can see this message (1) it means there's no token created and therefore, to do so simply click on "Create API token" (2) button:

4.Before generating a token, one needs to create a label tied with it - name it as you wish and press "Create" button:

4. Directly after doing so, you'll be presented with another prompt - this time with a token (it has the same properties in Excel Connector login prompt as previously used password):

Always keep it in a safe place

5. When one tries to log in to Jira Cloud via Excel Connector, procedure is nearly the same as before, except for the password - as you can see, since v3.6.2 of the add-in you are now informed that token code can be typed in here: