CSV Export of Text Has ###### Symbols instead of Text

Mindwatering Incorporated

Author: Tripp W Black

Created: 04/19/2016 at 11:27 PM

 

Category:
Notes Developer Tips
General

Issue:
Office 2003, 2007, 2010.

In working w/MS Excel, you discover that your text displaying #### are also actually exporting with #### values.


Solution 1:
Instead of leaving the cell style as "Text" or "No specific format", change to the cell format to "General". You should see the text switch. Export again and confirm column row values are text.

Solution 2:
Use LibreOffice or OpenOffice to open the XLSX file and save as CSV.



previous page