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

Question

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!

justintorrence · Answer

Try removing carriage returns and replacing them with newlines.https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/

lauramcfeely · Answer

Thanks, Justin! Removing the carriage returns makes sense, but can you please elaborate on how to replace them with newlines?&nbsp;

justintorrence · Answer

Good point, lol.Try using the Clean function.&nbsp;https://exceljet.net/excel-functions/excel-clean-function

lauramcfeely · Answer

Thank you!&nbsp;It looks like both of these options will just remove the line breaks, but I want to preserve them, because the text will be more readable in Quick Base. Do you know if there's a way to preserve the line breaks without getting "_x000D_" added?

justintorrence · Answer

Are you importing from file or clipboard.

Forum Discussion

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

9 Replies

Related Content

Merge Imports

Join multi-line text field to one line

Working with Text Multi Line Field

Pipeline to add Parent record from child import

Multi-line text field on an exact form