Omniture CSV file formats
One of the long lasting bugs/annoyances in SiteCatalyst is the somewhat crippled CSV format.
Therefore hopes were high when reading about the enhancements to the CSV file format in the SiteCatalyst 14.5 release notes.
Unfortunately the format hasn’t changed that much, basically it’s just broken in a different way.
Lets have a look at a report exported as a CSV file to illustrate the changes to the format.
First the old and deprecated format used in SiteCatalyst 14.0 to 14.4.
As You can see, it resembles CSV, but a more precise name would probably be Comma Separated Values And Commas 
,Operating Systems,,,,Visitors,,, 1.,,Windows XP,,"1,021,539",,,62.0% 2.,,Windows Vista,,"478,337",,,29.0% 3.,,Macintosh,,"47,474",,,2.9% 4.,,Media Center 2005,,"38,381",,,2.3% 5.,,Windows Server 2003 and XP x64 Edition,,"27,046",,,1.6% 6.,,Windows 2000/NT 5,,"13,770",,,0.8% 7.,,Linux,,"8,189",,,0.5% 8.,,Windows 7,,"6,044",,,0.4% 9.,,Windows 98,,"3,504",,,0.2% 10.,,Windows ME,,"1,756",,,0.1%
The new enhanced format has been cleaned up a bit, but it’s still not a correctly formatted CSV file, in addition it’s a mystery to me why they didn’t remove the line numbers and percentages, there isn’t really any use for that information in a CSV file.
,Operating Systems,Visitors 1.,Windows XP,1021539,62.0% 2.,Windows Vista,478337,29.0% 3.,Macintosh,47474,2.9% 4.,Media Center 2005,38381,2.3% 5.,Windows Server 2003 and XP x64 Edition,27046,1.6% 6.,Windows 2000/NT 5,13770,0.8% 7.,Linux,8189,0.5% 8.,Windows 7,6044,0.4% 9.,Windows 98,3504,0.2% 10.,Windows ME,1756,0.1%
Before giving up all hope on Omniture and CSV files in general, lets remember that if You create your report using Omniture Data Warehouse, You’ll get a perfect CSV file in return, perhaps someday SiteCatalyst could adopt the CSV export routines from Data Warehouse ?
"Operating Systems","Unique Visitors" "windows xp",466091 "windows vista",215950 "macintosh",23757 "media center 2005",16633 "windows server 2003 and xp x64 edition",12963 "windows 2000/nt 5",6364 "linux",4388 "windows 7",3229 "windows 98",1531 "windows me",769
