MS Excel compatibility tests

From CSV on the Web Working Group Wiki
Jump to: navigation, search

Compatibility test results using files specified in CSV+ Syntax document.

Version: Excel 2007 (running on Windows 7 Enterprise SP1)

test-utf8.csv

  • Cyrillic text not recognised
  • Latin text with accents not recognised
  • Escaped CRLF recognised correctly


Capture-ms-excel-2007-win-7e-test-utf8.PNG

test-utf8-bom.csv

Opening this file in Excel triggered a CSV import wizard; file recognised as UTF-8, selection choices were "delimited", "comma" delimiter and choice of "YMD" format for date column.

  • Escaped CRLF treated as end of line (e.g. escaping not recognised); row is split into two
  • Final doublequote character 0x22 is incorrectly rendered


Capture-ms-excel-2007-win-7e-test-utf8-bom.PNG

test-utf16.csv

  • Cyrillic text not recognised
  • Escaped CRLF recognised correctly

Capture-ms-excel-2007-win-7e-test-utf16.PNG

test-utf16-bom.csv

Opening this file in Excel triggered a CSV import wizard; file recognised as Windows-ANSI, selection choices were "delimited", "comma" delimiter and choice of "YMD" format for date column.

  • Escaped CRLF treated as end of line (e.g. escaping not recognised); row is split into two
  • Final doublequote character 0x22 is incorrectly rendered


Capture-ms-excel-2007-win-7e-test-utf16-bom.PNG

test.xlsx

Rendering appears correct; note retention of formatting on date column.

Capture-ms-excel-2007-win-7e-test-xslx.PNG

test.xls

Rendering appears correct (compatibility mode); note retention of formatting on date column.

Capture-ms-excel-2007-win-7e-test-xsl.PNG