I have a csv file and I want to import to my MS Excel. In the csv files, some row have very long text with new line characters, therefore, I have to use double quotes for these text. When previewing, it can correctly parse my csv file. However, when I open the file with Excel, it cannot parse the file (please see images for more details). I've tried to import the data with different separators, but it doesn't succeed. Can you help explain? Thanks. enter image description here

enter image description here

  • Is a macro-based solution acceptable to you ?? – Gary's Student Jul 7 '17 at 16:03
  • @Gary'sStudent I would prefer a straightforward solution using software Excel, but a macro-based one is also OK. Could you please post your solution? – lenhhoxung Jul 7 '17 at 16:12
  • What encoding are you using? How are you opening the file (through the file menu or double click)? stackoverflow.com/questions/2668678/… – Mat Forsberg Jul 7 '17 at 17:36
  • 1
    I obviously cannot test on YOUR csv file, since you do not provide it. But on a "mockup" file with line feeds within a quoted phrase, the CSV file opens properly if I either Open the file; or double click on the file in the Explorer window. It does not if I use the Data/Import/from text/csv wizard – Ron Rosenfeld Jul 13 '17 at 1:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.