Info |
---|
Page is divided into Cloud / Server & Data Center sections, due to the differences in their configuration. |
Cloud
Server & Data Center
Thank you for choosing Excel 365 Connector!
On this page you will learn how to configure the app and how to use it to unlock its full potential.
We will cover:
Configuration
Features
Documentation, Support & Feedback
Configuration
Jira: App has to be installed by a Jira Administrator/user with permission to install apps
Info |
---|
Please contact your Jira Administrator with links to our app if you would like to try it on your Jira. |
Cloud
Server & Data Center
Make sure and double check that Jira is configured to run on HTTPS
You must add https://ec365.ttae.com.pl to your Allowlist (Whitelist)
Tip |
---|
That’s all! |
Excel: Install “Connector for Jira”
Each user interested in using must install the app needs to have app installed individually, e.g. from the MS Store: https://appsource.microsoft.com/en-us/product/office/WA200001970
In some cases, where case of MS Store is being disabled by company policy, app can be installed through from Admin Center / SharePoint App Catalog. Read about: Disabled access to Excel MS Store or offline installation
Tip |
---|
That’s all! |
Log in:
Cloud
Each user must create API token, and use it to log in: How to generate API token
Server & Data Center
Each user needs to login with their Jira username and password also providing Jira base URL
Tip |
---|
That’s all! |
Notify users
As a Jira Administrator you might want If you wish to notify you fellow users about new features and new possibilities which come with new app installedthe new app, we have prepared 2 templates which can be used / modified to notify your users about those changesthat you may use to do so. Make sure it fits your company's they fit your workplace communication style.
Cloud
Code Block |
---|
Hey Team, We've installed a new app "Excel 365 Connector" in our Jira, it allows to manage Jira issues in Excel. If you would like to use the app, you need to install "Connctor for Jira" in your Excel, directly from the MS Store. Here is the link: https://appsource.microsoft.com/en-us/product/office/WA200001970 Once installed just follow the login instructions. You will need an API Token (generate it) and our Jira URL. Here you can check the Get Started page from the app documentation: https://psc-software.atlassian.net/wiki/spaces/ECSD365/pages/2418049025/Get+Started Cheers, Admin |
Server & Data Center
Code Block |
---|
Hey Team, We've installed and configured a new app "Excel 365 Connector" in our Jira, it allows to manage Jira issues in Excel. If you would like to use the app, you need to install "Connctor for Jira" in your Excel, directly from the MS Store. Here is the link: https://appsource.microsoft.com/en-us/product/office/WA200001970 Once installed just follow the login instructions. You should use your username, password and our Jira URL. Here you can check the Get Started page from the app documentation: https://psc-software.atlassian.net/wiki/spaces/ECSD365/pages/2418049025/Get+Started Cheers, Admin |
Features:
Excel 365 Connector honors Jira permission schemes.
Import issues
With the app installed, you can easily import issues into Excel with the use of your favorite filters or by building JQL queries, you can use multiple sheets. You can use Desktop and Web based Excel versions and get issue data, that you need. Now you can use Excel to run, analyse or update data.
Here you can read more: General - Import
Export issues
When you get issues into Excel, you can start editing them (with respect to Jira permissions). You can also create new Jira issues, right from the Excel. It can be done with ‘Create’ button or ‘#' sign in Key column. When you want to send changes just use the 'Export’ button.
Here you can read more: General - Export
Templating
This feature allowing to insert variables into spreadsheet and fill it with specified issue data. It can be used for creating templates and fill it in real time (powered by Excel).
Here you can read more: Templating [v1.5.0] Templating
Sending issue structures
This feature allows user to send whole structures of newly created issues connected together at once, without creating parent issue first. With this ability, you can create issue types with tasks and subtasks. This runs on temporary/virtual issue IDs, which are converted to Issue keys when sending changes to Jira.
Here you can read more: Export issue structures
Custom field management
We have support a lot of Jira fields to be in the columns of our plugin inside Excel worksheet. You can also select Visible/Invisible fields to customize your Excel sheet.
Here you can read more: Supported fields
Documentation, Support & Feedback
Documentation
Here you can find our app Documentation: https://psc-software.atlassian.net/wiki/spaces/ECSD365
Support
If case of any issues with the app, or if you have ideas for new features or improvements, please let us know by creating a ticket on our Customer Portal
If you think you found a bug, please describe the behaviour and steps explaining how to reproduce your problem - we will do our best to fix it. To speed up the process, in the initial contact please include:
Environment (Excel, Excel 365 Connector and Jira versions)
Application logs: https://psc-software.atlassian.net/wiki/spaces/ECSD365/pages/2412281857/Settings+v2#Logger
Feedback
We are constantly working on improving our app by adding new features. If you like it, or if it saves you time, help us by letting other Jira Admins know about it. You can do it by leaving a review or sending feedback on the marketplace. We really appreciate it, it gives us a boost
Leave a review: Cloud, Server, Data Center
If you would like to share your success story or your usage examples from your organization, please let us know through Customer Portal, we would love to hear how our apps helps you on a daily basis.