Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is it possible to create a some kind of 'custom CSV filter' for OpenOffice.org or LibreOffice spreadsheet program. What I need is to have the program to use predefined CSV settings for loading and saving when I open, let's say file named 'somefile.myext'. Also I would need the loaded data to be placed in a prestyled spreadsheet.

In this particular case, I would need the CSV settings to have tab as a field delimiter and no text delimiter at all. Prestyled spreadsheet would contain Blue gray coloring for every odd row (achieved with conditional formatting formula), some font styling and probably some column width definitions.

share|improve this question
almost sounds like you want to be able to create a program to take csv datasheets and format them into the style you want. This questions should probably goto SO and not SU. –  g19fanatic Feb 16 '11 at 19:50

1 Answer 1

You need a database then. CSV files are plain text, and therefore don't carry formatting. You can try to create a template, then import the data through Copy-Paste on another window, and tell it to use Destination Formatting

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.