'Why does CSV include   after being imported into Excel?
The line in question looks like this:
LongWord (Word Word 7) - Word - +55555555
And when it's imported it looks like this:
LongWord (Word Word 7) - Word - +55555555
The .csv file is generated in the browser using .js:
/**
* Generate CSV file in browser and download
*/
function download(csv) {
// CSV File
var csvFile = new Blob([csv], { type: 'text/csv' })
// Download link
var downloadLink = document.createElement('a')
// File name
downloadLink.download = self.filename
// We have to create a link to the file
downloadLink.href = window.URL.createObjectURL(csvFile)
// Make sure that the link is not displayed
downloadLink.style.display = 'none'
// Add the link to your DOM and click
document.body.appendChild(downloadLink)
downloadLink.click()
}
I can't find other examples online of this happening nor can I debug it.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
