# Import CSV with newline character

**URL:** <https://community.hubspot.com/t/import-csv-with-newline-character/28819>\
**Category:** APIs & Integrations\
**Tags:** object\
**Created:** [December 7, 2020, 5:31am UTC](https://community.hubspot.com/t/import-csv-with-newline-character/28819 "2020-12-07T05:31:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![crtag](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/crtag/32/13631_2.png) [@crtag](https://community.hubspot.com/u/crtag)\
**Post date:** [December 7, 2020, 5:31am UTC](https://community.hubspot.com/t/import-csv-with-newline-character/28819/1 "2020-12-07T05:31:54Z")

</div>

I’m migrating a significant amount of data to Hubspot and stumbled upon seemingly trivial issue - deals description contain newlines characters and this is quite normal in CSV format, and acceptable across other systems. But, importing it into Hubspot yields an error about malformed CSV. Of course, I can replace it with some special character and then do API update for all the records replacing it back, but this seems to be not right for many reasons. Did anyone solve this kind of the problem in an acceptable way, ie minimal operations with CSV or resulting records?

I’ve tried to replace newline characters with literal \n hoping it would result in newlines after import, but to no avail. The import went fine and produced deal description with no newlines but all \n being in place.

UPDATE: Newline characters are fine, the issue is about tab characters, see explanation below.

---

<div class="post-metadata">

**Author:** ![quentin\_lamamy](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/quentin_lamamy/32/20212_2.png) [@quentin\_lamamy](https://community.hubspot.com/u/quentin_lamamy)\
**Post date:** [December 7, 2020, 8:24am UTC](https://community.hubspot.com/t/import-csv-with-newline-character/28819/2 "2020-12-07T08:24:19Z")

</div>

Hi @crtag ,

Can you send me your code and an anonymised example of your csv ?

---

<div class="post-metadata">

**Author:** ![crtag](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/crtag/32/13631_2.png) [@crtag](https://community.hubspot.com/u/crtag)\
**Post date:** [December 7, 2020, 10:06pm UTC](https://community.hubspot.com/t/import-csv-with-newline-character/28819/3 "2020-12-07T22:06:20Z")

</div>

False alarm. After having a good sleep found the issue being tab characters breaking the import. Regardless, a tab character is still a valid one if fields are properly wrapped, so I suggest Hubspot CSV parser is a bit crippled.

---

<div class="post-metadata">

**Author:** ![quentin\_lamamy](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/quentin_lamamy/32/20212_2.png) [@quentin\_lamamy](https://community.hubspot.com/u/quentin_lamamy)\
**Post date:** [December 8, 2020, 7:45am UTC](https://community.hubspot.com/t/import-csv-with-newline-character/28819/4 "2020-12-08T07:45:09Z")

</div>

@crtagGlad to hear that your issue is solved. If you think this behavior with tab shouldn’t not exist feel free to post in the [idea section of the board](https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot_Ideas/tab/most-kudoed) , detail the current behaviour and the expecting behaviour with a code example.

Don’ tforget to mark this topic as solved, have a nice day