title: How do I export a response on postman to a clearly laid-out csv/xls file?
body: <p>I am new to APIs and currently working on a project to analyse data from a job website, reed.co.uk. I am trying to export the data to a spreadsheet with the variable names as headers, rather than a json. A typical GET request, e.g.</p>
  <p>curl --location --request GET 'https://www.reed.co.uk/api/1.0/search?keywords=accountant&amp;location=london' \</p>
  <p>Returns this:</p>
  <pre><code>&quot;results&quot;: [
      {
          &quot;jobId&quot;: 44137966,
          &quot;employerId&quot;: 575264,
          &quot;employerName&quot;: &quot;REED&quot;,
          &quot;employerProfileId&quot;: null,
          &quot;employerProfileName&quot;: null,
          &quot;jobTitle&quot;: &quot;Management Accountant&quot;,
          &quot;locationName&quot;: &quot;Maidstone&quot;,
          &quot;minimumSalary&quot;: 28000.00,
          &quot;maximumSalary&quot;: 35000.00,
          &quot;currency&quot;: &quot;GBP&quot;,
          &quot;expirationDate&quot;: &quot;28/10/2021&quot;,
          &quot;date&quot;: &quot;21/09/2021&quot;,
          &quot;jobDescription&quot;: &quot; My client is looking to recruit an ambitious and commercially aware Management Accountant.&amp;nbsp; Working closely with the Finance Director, you will provide accurate and timely management accounting information and reports in accordance with strict deadlines.&amp;nbsp;  In addition, you will work closely with the finance team providing support on a daily basis. Please note:&amp;nbsp; The standard hours of work are 7.00am to 3.45pm, Mo... &quot;,
          &quot;applications&quot;: 3,
          &quot;jobUrl&quot;: &quot;https://www.reed.co.uk/jobs/management-accountant/44137966&quot;
  </code></pre>
  <p>etc etc</p>
  <p>If I then follow Postman's own method for writing to csv (<a href="https://documenter.getpostman.com/view/3407886/RWgp1fB5?version=latest" rel="nofollow noreferrer">https://documenter.getpostman.com/view/3407886/RWgp1fB5?version=latest</a>) the resulting file only contains one row with all the data - if I do it with xls instead it is all put into a single cell. Ideally each column would contain the job variable (if that is the right term), e.g. JobId, employerId, employerName etc, and each row be a new job entry.</p>
  <p>Reed's API documentation is here: <a href="https://www.reed.co.uk/developers/jobseeker" rel="nofollow noreferrer">https://www.reed.co.uk/developers/jobseeker</a>.</p>
  <p>Thanks in advance.</p>