'Format issue console to csv

I have this really stupid question about the format of the text in console. I have made a request and I have the data I wish to use. I'm now trying to copy the contents of the console and paste it into a Google sheet to make it available in a Data Studio Report.

The trouble is that when I try to paste the content it formats in to a big pile of text rather than in separate rows.

Heres what I've tried so far

  1. Using both /n' and /r/n' in the end to make the rows break
  2. Saving it as CSV-file and importing it to Google sheets
  3. Pasting it into Google sheets, excel and notepad with all kinds of methods.

But nothing works. Does anyone know how to fixa this?

Please see attached picture.

Screenshot of Postman and Notepad

format


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions