I get weird characters when exporting to Excel

I'm trying to export my site items to Excel in order to do a mail merge. I'm finding that Square inserts weird formatting characters into the descriptions. <p> and </p> are not hard to remove, but there are also random strings of weird characters that mean every field has to be edited. Anyone else struggling with this and find a solution?

2,939 Views
Message 1 of 3
Report
2 REPLIES 2
Square Community Moderator

Hello @JKO 

 

That's really frustrating. 

 

I exported my library and only get the <p> and </p> characters, which as you mentioned, are easy to remove. 

 

If you could send a screenshot of what some of those characters are, we can take a deeper look into this issue. 

 

Thanks!

Frances
Community Moderator, Square
Sign in and click Mark as Best Answer if my reply answers your question.
2,892 Views
Message 2 of 3
Report

I replied to this before but I don't see that reply showing up. Here are some examples:

* The center bead is 1&#34; tall and the necklace is just over 20&#34;.&lt;br /&gt;&lt;br /&gt;The purple of amethyst is associated with royalty. Amethyst is associated with healing the mind, body, and spirit. &lt;br /&gt;&lt;br /&gt;Don&#39;t miss your opportunity to own this healing necklace!

* It is shown hanging on a matching green fabric cord. &lt;br /&gt;&lt;br /&gt;Serpentine stones 

* This dramatic pendant features a green Cat&#39;s 

* is a hand-molded fine silver flower.&lt;br /&gt;&lt;br /&gt;Rubies are thought to symbolize good fortune and courage.&lt;br /&gt;

 

Clearly, apostrophe's trigger the "$#39;" but the others seem random.

Thanks, Jan

2,838 Views
Message 3 of 3
Report
This thread has been archived and locked. Please start a new thread if you would like to continue the conversation.