Forum Discussion

LauraMcFeely's avatar
LauraMcFeely
Qrew Cadet
6 years ago

Importing Excel file to multi-line text field -- Quick Base adds ""_x000D_

Each week, I import data from an Excel sheet into one of my Quick Base tables. One of the fields is a multi-line text field. In the process of importing, Quick Base adds "_x000D_" wherever there was a line break in the Excel cell. For example: 

This is how my data looks in Excel: 
"This is an example of the comment I'd like to upload.

Sometimes there are multiple lines in the comment." 

This is how it ends up in Quick Base: 
"This is an example of the comment I'd like to upload._x000D_
_x000D_
Sometimes there are multiple lines in the comment."

I like that the line breaks are preserved, but it's a pain to grid-edit after my import and manually delete "_x000D_" wherever it appears. Does anyone know how to prevent this from happening? 

Thank you!

9 Replies