I use Google Sheets (spreadsheet) to combine article data for different sources for my Gambio shop. To import the data I need the pipe symbol as delimiter / separator and " as text delimiter in a .csv file. In the Google Sheets menu for exporting to .csv there are no Options.
Is there a way to export to .csv with pipe separators in Google Sheets?
I actually didn't make it happen inside the Google world. My workaround is to use an editor like Sublime Text to mark all pipe delimiters and replace them with semicolon to import in sheets.