Skip to main content
Question

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

  • Mar 27, 2019 6:13 PM UTC
  • 0 replies
  • 277 views

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!
This topic has been closed for replies.

Forum|alt.badge.img+11
Try removing carriage returns and replacing them with newlines.
https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/

  • Author
  • Qrew Cadet
  • Mar 27, 2019 6:39 PM UTC
Thanks, Justin! Removing the carriage returns makes sense, but can you please elaborate on how to replace them with newlines? 

Forum|alt.badge.img+11
Good point, lol.
Try using the Clean function. https://exceljet.net/excel-functions/excel-clean-function

  • Author
  • Qrew Cadet
  • Mar 27, 2019 6:51 PM UTC
Thank you! 

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?

Forum|alt.badge.img+11
Are you importing from file or clipboard.

  • Author
  • Qrew Cadet
  • Mar 27, 2019 6:58 PM UTC
I'm importing from a file. 

Forum|alt.badge.img+11
What is the file extension?
I imagine it is XLSX, you should try saving the sheet as a CSV.

  • Author
  • Qrew Cadet
  • Mar 27, 2019 7:15 PM UTC
You're right, I've been importing from an .xlsx file, but I just tested a CSV file and that fixes the problem. Thank you!!

Forum|alt.badge.img+11
No problem!