# Escape codes to import multiple lines to Contact Notes field?

**URL:** <https://integration.keap.com/t/escape-codes-to-import-multiple-lines-to-contact-notes-field/13964>\
**Category:** Max Classic\
**Tags:** importing\
**Created:** [September 8, 2017, 9:23pm UTC](https://integration.keap.com/t/escape-codes-to-import-multiple-lines-to-contact-notes-field/13964 "2017-09-08T21:23:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darryl\_deGraaf](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/darryl_degraaf/32/2383_2.png) [@Darryl\_deGraaf](https://integration.keap.com/u/Darryl_deGraaf)\
**Post date:** [September 8, 2017, 9:23pm UTC](https://integration.keap.com/t/escape-codes-to-import-multiple-lines-to-contact-notes-field/13964/1 "2017-09-08T21:23:26Z")

</div>

I am importing Notes from an external database into the Person Notes field in Infusionsoft via .csv.

I need to know what escape codes I can insert into the string in the .csv so that when the text is imported into the Person Notes field in Infusionsoft, it comes in and is displayed like:  
line1  
line2  
line3

instead of:  
line1 line2 line3

I’ve tried \r, \n, and several variations of \< br \>, but everything imports literally, e.g.: line1\rline2\r\line3

Any ideas?  
Thanks!

---

<div class="post-metadata">

**Author:** ![martinc](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/martinc/32/14_2.png) [@martinc](https://integration.keap.com/u/martinc)\
**Post date:** [September 8, 2017, 11:29pm UTC](https://integration.keap.com/t/escape-codes-to-import-multiple-lines-to-contact-notes-field/13964/2 "2017-09-08T23:29:55Z")

</div>

If I ALT + Enter in Excel, it creates a line break and then imports the line break correctly. Can you get your data into that format from the source data?

---

<div class="post-metadata">

**Author:** ![Darryl\_deGraaf](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/darryl_degraaf/32/2383_2.png) [@Darryl\_deGraaf](https://integration.keap.com/u/Darryl_deGraaf)\
**Post date:** [September 9, 2017, 2:06am UTC](https://integration.keap.com/t/escape-codes-to-import-multiple-lines-to-contact-notes-field/13964/3 "2017-09-09T02:06:17Z")

</div>

I assumed that wouldn’t save to the .csv or import correctly, but it does.  
Good to know; thanks for the help.

---

<div class="post-metadata">

**Author:** ![John\_Borelli](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/john_borelli/32/11880_2.png) [@John\_Borelli](https://integration.keap.com/u/John_Borelli)\
**Post date:** [September 10, 2017, 12:57am UTC](https://integration.keap.com/t/escape-codes-to-import-multiple-lines-to-contact-notes-field/13964/4 "2017-09-10T00:57:16Z")

</div>

Yeah, I believe what happens there is that the ‘shortcut key’ Alt-Enter actually inserts an ASCII character (#10) which is recognized as carriage return / line feed
