Exporting as CSV with linked records as numbers are messed up

Hi! You can see from the screenshots that my export as CSV does some crazy stuff to my records. Ideas on how to fix?

+15

Looks like Excel is converting that column to a number which is normal behavior for Excel.

Try using a Rollup field in your export that does something like this for the aggregation formula:
'#' & ARRAYJOIN(values, ', #')

That way you get “#10547, #10544, #10542…” instead, and Excel won’t do anything weird to that field.

1 reply