Build 4.0.0.101 of xlsgen adds support for automatically inferring values correctly when they are expressed in percent. With such column, numbers are divided by 100 and a percent-type number format is applied to it. Because this is done automatically, there is no reason to customize the CSV import for taking benefit of this feature, which means you don't have to know any prior knowledge of the CSV data structure.