Forum Discussion

MATTHEWSTOGNER's avatar
MATTHEWSTOGNER
Qrew Member
5 years ago

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
------------------------------
Data import and export
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    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/
    ------------------------------