Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a big CSV file (10,000s of rows).

How can I automatically convert it to an XLS file which will have Filters and some formatting (color, font) on the top row?

share|improve this question
up vote 0 down vote accepted

You could do this with an .xls template file and some scripting to move the data from the CSV. - create an xls file with the properlyu formatted top row - When you need to"convert the file, in your script, make a copy of the template then open it for editing - iterate through the csv file allthe while copying the data to a new row in the xls file

Excel has a COM programming interface that can facilitate this.

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.