TextExpander Snippet to Paste Excel Values without Excess Quotation Marks (Leading, Trailing, or Doubled)

textexpander-snippet-clean-excel-quotation-marks.js

// Start with the clipboard content 
var result = TextExpander.pasteboardText;

// If the result is wrapped in quotation marks...
if (result.match(/^"[\s\S]+"$/)) {
  result = result.replace(/^"|"$/g, '') // Strip the leading and trailing quotation marks
    .replace(/""/g, '"'); // And replace any doubled quotation marks ('""') with just one ('"')
}

// Return the result
TextExpander.appendOutput(result);