Lets say I have a Google Sheet that looks like this.

[![enter image description here](https://i.stack.imgur.com/Hm1YI.png)](https://i.stack.imgur.com/Hm1YI.png)

You can export it so it can be reached with a URL similar to this

```
# CSV
https://docs.google.com/spreadsheets/d/e/Eis4Ya-Le9Py/pub?gid=0&single=true&output=csv
# TSV
https://docs.google.com/spreadsheets/d/e/Eis4Ya-Le9Py/pub?gid=0&single=true&output=tsv

```

If you download the file and open it on Open Office, you can clearly see that it recognize the multilines.

[![enter image description here](https://i.stack.imgur.com/ZHV1N.png)](https://i.stack.imgur.com/ZHV1N.png)

And that is because the field with multiple lines get enclosed in "".

In a plain text editor it looks like

[![enter image description here](https://i.stack.imgur.com/GUSA6.png)](https://i.stack.imgur.com/GUSA6.png)

However, and here is the problem, if I get the file using python requests library, the double quotes are removed.

```
import requests

r=requests.get(url)

print(r.text)
print(r.content)
print(r.headers)

id  description
1   one line
2   line1 line2
3   l1 l2 empty line below  end
4   normal

b'id\tdescription\r\n1\tone line\r\n2\tline1 line2\r\n3\tl1 l2 empty line below  end\r\n4\tnormal'

{'Content-Type': 'text/tab-separated-values', 'X-Frame-Options': 'ALLOW-FROM https://docs.google.com', ... , 'Transfer-Encoding': 'chunked'}

```

Why?

How can I change that behavior?

I know there is a library for dealing with **csv** files, but I cannot use it in the environment I am in.