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'; |