You're seeing ###### in the cells because the cells are not large
enough to display the data, change the cell column width's and row
heights as necessary to view the data, then try exporting it to CSV.
Easiest way would be to select all cells, then format - row- autofit,
format - column- autofit