Extra Spacing from Exporting to Excel

SLam

Hello,

I have this issue where when I export to Excel, there is about 6 extra spaces at the end of each result.. When I export a card into Excel and click on a cell in the FirstName column, it'll show for example, "Max__", where _ = spaces.

Is there any way to get rid of this?

MarkSnodgrass

The export should just mimicking what is in your actual data, so I suspect you have trailing spaces in your source data. You can easily fix this in Magic ETL or with a Beast Mode by using the TRIM function to eliminate any leading or trailing spaces.