Skip to main content

Exporting as CSV with linked records as numbers are messed up

  • October 17, 2020
  • 1 reply
  • 24 views

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

This topic has been closed for replies.

1 reply

Kamille_Parks11
Forum|alt.badge.img+27

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.