After hours of trying to sort this out, without much help from QBO, I have found a solution. Open the document as a Google Sheet and make the necessary changes. Then download this as a CSV document.
View solution in original post
