Importing CSV with line breaks in Excel 2007

by

Excel (at least in Office 2007 on XP) can behave differently depending on whether a CSV file is imported by opening it from the File->Open menu or by double-clicking on the file in Explorer.

I have a CSV file that is in UTF-8 encoding and contains newlines in some cells. If I open this file from Excel’s File->Open menu, the “import CSV” wizard pops up and the file cannot be correctly imported: the newlines start a new row even when quoted. If I open this file by double-clicking on it in an Explorer window, then it opens correctly without the intervention of the wizard.

More Related Contents:

  1. Generating CSV file for Excel, how to have a newline inside a value
  2. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  3. Stop Excel from automatically converting certain text values to dates
  4. Microsoft Excel mangles Diacritics in .csv files?
  5. Excel to CSV with UTF8 encoding [closed]
  6. How to add a custom Ribbon tab using VBA?
  7. Excel CSV – Number cell format
  8. filter out multiple criteria using excel vba
  9. Export hashtable to CSV with the key as the column heading
  10. Save each sheet in a workbook to separate CSV files
  11. Closing Excel Application using VBA
  12. Export each sheet to a separate csv file
  13. How to correctly display .csv files within Excel 2013?
  14. How to add parameters to an external data query in Excel which can’t be displayed graphically?
  15. Convert xlsx file to csv using batch
  16. Excel: Searching for multiple terms in a cell
  17. Cannot VBA write data to cells in Excel 2007/2010 within a function
  18. VBA equivalent to Excel’s mod function
  19. Excel VBA to match and line up rows
  20. Excel: the Incredible Shrinking and Expanding Controls [closed]
  21. How do I use awk under cygwin to print fields from an excel spreadsheet?
  22. Extract the last substring from a cell
  23. converting an Excel (xls) file to a comma separated (csv) file without the GUI
  24. sep=”;” statement breaks utf8 BOM in CSV file which is generated by XSL
  25. How to save excel columns with long numbers into csv?
  26. How to programmatically code an ‘undo’ function in Excel-Vba? [duplicate]
  27. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  28. Delete all data rows from an Excel table (apart from the first)
  29. Can Excel interpret the URLs in my CSV as hyperlinks?
  30. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?

Leave a Comment