Project Manager

Jerry L

<div>
Your answer provided the correct assumption which was to suspect it was a Shopify problem and NOT how Microsoft Excel was handling the data.
</div>


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

<div>
Do you think Shopify will respond to your problem?
</div>


Do you think Shopify will respond to your problem?

<div>
Yes, they are very helpful.
</div>


<div>
<div class="content wysiwyg-content">
I exported data from a Shopify store to a CSV file. The original data are product descriptions from the store inventory. <br />
<br />
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:<br />
<br />
<br />

<div class="indent">
&lt;m:brkBin m:val=&quot;&quot;before&quot;&quot;/&gt;<br />
...<br />
&lt;m:mathFont m:val=&quot;&quot;Cambria Math&quot;&quot;/&gt;<br />
...<br />
UnhideWhenUsed=&quot;&quot;false&quot;&quot; Name=&quot;&quot;Colorful Grid Accent 6&quot;&quot;/&gt;<br />
...<br />
&lt;w:LsdException Locked=&quot;&quot;false&quot;&quot; Priority=&quot;&quot;73&quot;&quot; SemiHidden=&quot;&quot;false&quot;&quot;
</div>
<br />
QUESTION:<br />
Can you explain what is happening and how to fix it?
</div>
</div>


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?

MS Excel: Data Being Replaced by XML Formulas

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.