The Remove Quotes option is designed to strip the extra wrapping quotes that Excel adds around fields when it saves a text file, not to remove legitimate quote characters that are part of your data. This is a completely free app from Insight Works for Business Central. A description that uses an inch mark, such as a tape described as 12 inch using a double quote symbol, will import correctly with the option enabled, because the Import Export PowerTool only removes the surrounding quotes that Excel introduces.
Why Excel adds quotes
When Excel saves a worksheet as a text file and a cell contains characters such as commas or quotation marks, Excel surrounds that cell value with quotation marks so the field is parsed correctly. It also doubles any quotation mark that appears inside the value, which is the standard way of escaping a quote within a quoted field. So a description that you typed as a value ending in an inch mark can appear in the saved file wrapped in quotes and with the internal quote doubled. Left untreated, those extra characters would end up stored in your description.
What the Remove Quotes option does
With Remove Quotes enabled, the tool recognizes these patterns and cleans them up. If it sees a quote at the very beginning and end of a field value, it removes that surrounding pair. If it sees a doubled quotation mark inside the value, which Excel created as an escape, it collapses it back to a single quote. The result is that your description is stored the way you intended, including a single inch mark, rather than carrying Excel’s escaping artifacts. This is why the option is best left on when your files come from Excel.
The inch mark example
Consider a description of Tape, 12 inch where the inch is written with a double quote symbol. After saving from Excel, the field may appear in the text file with outer quotes and a doubled inner quote. When you import with Remove Quotes enabled, the tool removes the outer pair and collapses the doubled inner quote, so the value lands in Microsoft Dynamics 365 Business Central as the clean description you expect. You do not need to manually edit the file to remove these characters.
When to keep the option enabled
Because the option only acts on the wrapping and escaping patterns that Excel produces, there is little downside to leaving it on for files that originate from Excel. If you build files in a plain text editor and do not introduce wrapping quotes, the option simply has nothing to remove. The safest default for most workflows is to keep Remove Quotes enabled so that descriptions containing inch marks, commas, or other punctuation import cleanly.
Related Tools
Import Export PowerTool is the Insight Works app for fast import, export, update, and delete operations in Business Central. Its Remove Quotes option cleans up the wrapping and escaped quotes that Excel adds so that values such as inch measurements import correctly.
A description containing an inch mark is safe to import. The Remove Quotes option targets only the extra quotes Excel adds around and inside fields, leaving your intended value intact, so keep it enabled whenever your import files are saved from Excel.