# Change formatting for export: Multiselection fields

**URL:** <https://community.hubspot.com/t/change-formatting-for-export-multiselection-fields/31569>\
**Category:** CRM\
**Tags:** free\
**Created:** [February 10, 2021, 12:59pm UTC](https://community.hubspot.com/t/change-formatting-for-export-multiselection-fields/31569 "2021-02-10T12:59:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ILadurner](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/iladurner/32/2490_2.png) [@ILadurner](https://community.hubspot.com/u/ILadurner)\
**Post date:** [February 10, 2021, 12:59pm UTC](https://community.hubspot.com/t/change-formatting-for-export-multiselection-fields/31569/1 "2021-02-10T12:59:06Z")

</div>

Hi, dear community,  
I have a problem since the last update of Hubspot.

Unfortunately, the code seems to have changed the option of how to separate single values in a multiselection field. Is there a way to select how they are separated in a CSV file?

At the moment they are separated by “;”, but I need “||”.

Hope there is a solution for this. Unfortunately, I can’t change the input from the newsletter system we use.

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [February 10, 2021, 1:13pm UTC](https://community.hubspot.com/t/change-formatting-for-export-multiselection-fields/31569/2 "2021-02-10T13:13:17Z")

</div>

Hi @ILadurner,

As far as I know this cannot be changed in HubSpot. For a free workaround, Zapier could be an option: [Use HubSpot's integration with Zapier](https://knowledge.hubspot.com/integrations/how-to-use-zapier-and-hubspot)

You could use Zapier to create rows in a spreadsheet (Google Sheets, Microsoft Excel) whenever a contact in HubSpot is added to a specific list. In that sheet, you’d be able to replace ; with ||. You could then either sync these values in your newsletter software solution or or back in HubSpot (although that would mean that HubSpot will not recognize multiple values anymore).

Would it be an option to submit a request to your newsletter software provider? The || seems an odd choice for a separator, commas and semicolons are much more widely used.

Best regards!