Skip to main content
Question

export to excel; one field to multiple rows

Hello,

When I attempt to export a report the result is it has the correct column names and initial data but one of the fields for a few records is getting put at the bottom in the first column under the other data in the report (this is happening when users put in a lot of text). The field type is a text-multi-line and I've tried putting a large number on the Max Character but that is not helping.

Has anyone experienced this? Is this an issue with Quickbase or Excel?

------------------------------
MATTHEW STOGNER
------------------------------
This topic has been closed for replies.

Most likely, it's a problem with the text being inserted and how Excel is interpreting the CSV data - namely the column delimiters. I'm guessing your weird column break issue occurs when the user has entered a comma into the text field. Unfortunately, I don't know of a reliable way to fix that except to strip any commas from the text using a formula and then downloading from a report that uses the formula instead of the original text.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement