I'm trying to have a direct import of Jira filter to Excel through Data import, below are the steps I followed:
In Jira:
1- Created a new filter
2- Copied the CSV (Current fields) URL | https://jira.xxxxxxxxxxxxx/jira.issueviews:searchrequest-csv-current-fields/xxxxxx/SearchRequest-xxxxx.csv
In Excel:
- Data - Get Data - Import data from Web - added the URL - load data --> but the data is loading in the below format not the actual extract
Any idea what may be the issue?
Column1
| |
| <!DOCTYPE html> |
| <html lang="en"> |
| <head> |
| <meta charset="utf-8"> |
| <meta content="width=300 |
| <meta name="google-site-verification" content="LrdTUW9psUAMbh4Ia074-BPEVmcpBxF6Gwf0MSgQXZs"> |
| <title>Sign in - Google Accounts</title> |
| <style> |
| @font-face { |
| font-family: 'Open Sans'; |
| font-style: normal; |
| font-weight: 300; |
| src: url(//fonts.gstatic.com/s/opensans/v15/mem5YaGs126MiZpBA-UN_r8OUuhs.ttf) format('truetype'); |
| } |
| @font-face { |
| font-family: 'Open Sans'; |
