How should I escape commas and speech marks in CSV files so they work in Excel?

by

We eventually found the answer to this.

Excel will only respect the escaping of commas and speech marks if the column value is NOT preceded by a space. So generating the file without spaces like this…

Reference,Title,Description
1,"My little title","My description, which may contain ""speech marks"" and commas."
2,"My other little title","My other description, which may also contain ""speech marks"" and commas."

… fixed the problem. Hope this helps someone!

More Related Contents:

  1. Converting JSON to XLS/CSV in Java [closed]
  2. CSV file with “ID” as first item is corrupt in Excel
  3. How to escape comma and double quote at same time for CSV file?
  4. Exporting SQL query result to csv or Excel
  5. Fairly new to programming, trouble reading and writing to a binary file. [closed]
  6. How to read and write excel file
  7. How can I make Notepad to save text in UTF-8 without the BOM?
  8. How can I read numeric strings in Excel cells as string (not numbers)?
  9. String parsing in Java with delimiter tab “\t” using split
  10. JSP generating Excel spreadsheet (XLS) to download
  11. Embed files into Excel using Apache POI
  12. Apache POI – FileInputStream works, File object fails (NullPointerException)
  13. Fast CSV parsing
  14. Apache poi Excel line chart points
  15. How to set axis’ labels in a Line Chart using Apache Poi
  16. Merging cells in Excel using Apache POI
  17. how to read exact cell content of excel file in apache POI
  18. Splitting a csv file with quotes as text-delimiter using String.split()
  19. Create Bar Chart in Excel with Apache POI
  20. Excel Cell Style issue
  21. How to insert a row between two rows in an existing excel with HSSF (Apache POI)
  22. How to serialize object to CSV file?
  23. JSP page without HTML code for exporting data to Excel Sheet
  24. Exception when writing to the xlsx document several times using apache poi 3.7
  25. Any good library to read and write csv files? [duplicate]
  26. Java API to make an object from a CSV file [closed]
  27. Edit existing excel files using jxl api / Apache POI
  28. Create a password protected Excel file using Apache POI?
  29. Embed files into XSSF sheets in Excel, using Apache POI
  30. Make column read-only using apache poi

Leave a Comment