@apple_enthusiast it would be nice if iWork used ODF as it’s really not productivity software if its formats are not compatible with the rest of the world no matter what OS and software one is using particularly when ODF is now the ISO recognized format.
CSV only exports data, not formulas. I don’t really consider it a proper spreadsheet interchange format.