Importing multiline cells from csv file into excel
Fresh3 days ago
Mar 15, 202625069 viewsConfidence Score0%
0%
Problem
I have a csv file (comma delimited and quoted). When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8). Therefore I have to use import function (Data/Get External Data/From Text). However, when I use im…
Error Output
65001: Unicode (UTF-8)
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Importing multiline cells from csv file into excel
Low Risk
Use LibreOffice to open the file, then save in desired format: I had exactly the same problem you described when trying to use Excel 2010 to read UTF-8 MySQL data with multi-line Japanese text in some fields exported as quoted CSV with \r\n used for…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix