Originally Posted by
Idealproductsales
For those who find this thread later on- To save your OO Calc file as Tab Delimited properly for Bulk Upload (it's not obvious in OO, very convoluted, but here's how)
The following procedure:
1. File > Save as...
2. Select CSV as the type
3. Deselect Automatic filename extension
4. Select Edit filter settings
5. Change file name to end with .TSV (or whatever you use).
6. Press Save
7. Select {Tab} as the Field delimiter.
8. Backspace over the text field separator (mine defaults to ", we dont want this in there.. ) so as to leave it blank (no separator)
That should save your spreadsheet in perfect .tsv format for bulk uploading.