MS Excel: Data Being Replaced by XML Formulas

Jerry L
Jerry L used Ask the Experts™
on
I exported data from a Shopify store to a CSV file. The original data are product descriptions from the store inventory.

When you scroll down the worksheet to ROW 10313, some of the product description and other columns are no longer populated. COL A displays the following type of formatting (XML ?) rules. Those rules continue to be displayed to the last row of about 32000. Some of the rows contain the correct product data:


<m:brkBin m:val=""before""/>
...
<m:mathFont m:val=""Cambria Math""/>
...
UnhideWhenUsed=""false"" Name=""Colorful Grid Accent 6""/>
...
<w:LsdException Locked=""false"" Priority=""73"" SemiHidden=""false""

QUESTION:
Can you explain what is happening and how to fix it?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014
Commented:
I think Shopify has a problem with their export.

What do you see when you look at the CSV file with a text editor (Notepad or Notepad++)?
Jerry LOperations Manager

Author

Commented:
Your answer provided the correct assumption which was to suspect it was a Shopify problem and NOT how Microsoft Excel was handling the data.
Top Expert 2014

Commented:
Do you think Shopify will respond to your problem?
Jerry LOperations Manager

Author

Commented:
Yes, they are very helpful.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial