blocks|key|307825|text|如果字段包含前导空格，Excel将忽略双引号作为文本限定符。解决方案是消除逗号(字段分隔符)和双引号之间的前导空格。例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307826|已损坏：|307827|名称、头衔、描述|307828|“约翰”，“先生”，“我的详细描述”|307829|工作中：|307830|307831|307832|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|K|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|M|$]]

If the field contains a leading space, Excel ignores the double quote as a text qualifier. The solution is to eliminate leading spaces between the comma (field separator) and double-quote. For example:

Broken: 
 Name,Title,Description 
 "John", "Mr.", "My detailed description" 

Working: 
 Name,Title,Description 
 "John","Mr.","My detailed description"

blocks|key|310855|text|我终于找到问题所在了！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|310856|事实证明，我们使用的是Unicode编码，而不是ASCII或UTF-8。在FileStream上更改编码似乎可以解决这个问题。|310857|感谢大家的建议！|310858|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

I have finally found the problem!

It turns out that we were writing the file using Unicode encoding, rather than ASCII or UTF-8. Changing the encoding on the FileStream seems to solve the problem.

Thanks everyone for all your suggestions!

blocks|key|310860|text|建议的解决方案对我来说都不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|310861|实际工作情况(使用任何编码)：|310862|从csv-file+(在文本编辑器中打开)复制/粘贴数据，然后执行"text+to+columns“-->数据转换不正确。|310863|下一步是转到最近的空列或空工作表，并再次复制/粘贴(与剪贴板中已有的内容相同)+-->现在自动工作。|310864|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

None of the suggested solutions worked for me.
What actually works (with any encoding):
Copy/paste the data from the csv-file (open in a text editor), then perform &quot;text to columns&quot; --&gt; data gets transformed incorrectly.
The next stap is to go to the nearest empty column or empty worksheet and copy/paste again (same thing what you already have in your clipboard) --&gt; automagically works now.

blocks|key|309875|text|Excel+(至少在XP上的Office+2007中)的行为可能会有所不同，具体取决于CSV文件是通过从文件->打开菜单打开还是通过在资源管理器中双击该文件来导入的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|309876|我有一个UTF-8编码的CSV文件，在一些单元格中包含换行符。如果我从Excel的文件->打开菜单打开这个文件，弹出“导入CSV”向导，文件不能正确导入:换行符开始一个新的行，即使加了引号。如果我通过在资源管理器窗口中双击来打开此文件，则它将正确打开，而无需向导干预。|309877|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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.

blocks|key|309888|text|简短的回答|type|unstyled|depth|inlineStyleRanges|entityRanges|data|309889|删除换行符/换行符(带有Notepad%2B%2B的\n)。Excel仍将识别回车字符(\r)以分隔记录。|offset|length|style|CODE|309890|长长的答案|309891|如前所述，CSV字段中支持换行符，但Excel并不总是能很好地处理它们。我遇到了第三方CSV的类似问题，它可能有编码问题，但编码更改并没有改善。|309892|对我来说起作用的是删除所有换行符(\n)。假设您的记录由回车符和换行符(CR/LF)的组合分隔，这样做的效果就是将字段折叠为一条记录。然后，Excel将正确导入该文件，并通过回车符识别新记录。|309893|显然，一种更简洁的解决方案是首先用临时字符组合替换真正的换行符(\r\n)，用您选择的分隔字符(例如分号文件中的逗号)替换换行符(\n)，然后再用适当的换行符替换临时字符。|309894|entityMap^0|0|M|2|14|2|0|0|0|H|2|0|W|4|1T|2|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|12|8|@$D|13|E|14|F|G]|$D|15|E|16|F|G]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|Q|$]]

<h2>Short Answer</h2>

Remove the newline/linefeed characters (<code>\n</code> with Notepad++). Excel will still recognise the carriage return character (<code>\r</code>) to separate records.

<h2>Long Answer</h2>

As mentioned newline characters are supported inside CSV fields but Excel doesn't always handle them gracefully. I faced a similar issue with a third party CSV that possibly had encoding issues but didn't improve with encoding changes.

What worked for me was removing all newline characters (<code>\n</code>). This has the effect of collapsing fields to a single record assuming that your records are separated by the combination of a carriage return and a newline (CR/LF). Excel will then properly import the file and recognise new records by the carriage return.

Obviously a cleaner solution is to first replace the real newlines (<code>\r\n</code>) with a temporary character combination, replacing the newlines (<code>\n</code>) with your seperating character of choice (e.g. comma in a semicolon file) and then replacing the temporary characters with proper newlines again.

blocks|key|3262475|text|如果您手动执行此操作，请下载LibreOffice并使用LibreOffice+Calc导入您的CSV。它比我尝试过的任何版本的Excel都要好得多，而且如果你以后需要转换成Excel，它可以根据需要保存到XLS或XLSX。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3262476|但是，如果你被Excel卡住了，需要一个更好的修复方法，似乎有一种方法。它似乎依赖于语言环境(在我看来，这似乎很愚蠢)。我没有Excel2007，但我有Excel2010，并给出了示例：|3262477|ID,Name,Description
"12345","Smith,+Joe","Hey.
My+name+is+Joe."|code-block|syntax|javascript|3262478|不起作用。我把它写在记事本里，然后选择另存为...，在保存按钮旁边，你可以选择编码。我按照建议选择了UTF-8，但没有成功。不过，将逗号改为分号对我来说很管用。我没有改变其他任何东西，它只是起作用了。因此，我将示例更改为如下所示，并在记事本中保存时选择UTF-8编码：|3262479|ID;Name;Description
"12345";"Smith,+Joe";"Hey.
My+name+is+Joe."|3262480|但是有一个问题！它的唯一工作方式是双击CSV文件以在Excel中打开它。如果我尝试从文本导入数据并选择此CSV，则在带引号的换行符上仍然失败。|3262481|但这是的另一个陷阱！工作字段分隔符(在原始示例中为逗号，在我的示例中为分号)似乎取决于系统的区域设置(在控制面板->区域和语言下设置)。在挪威，逗号是小数点分隔符。Excel似乎避免使用此字符，而更喜欢使用分号。我可以访问另一台设置为英国英语区域设置的计算机，在那台计算机上，第一个带有逗号分隔符的示例运行良好(仅在doubleclick上)，而带有分号的示例实际上失败了！互操作性就这么多了。如果您想在线发布此CSV，并且用户可能有Excel，我猜您必须同时发布两个版本，并建议人们检查哪个文件提供了正确的行数。|offset|length|style|BOLD|3262482|因此，我收集到的所有细节都可以让它生效：|3262483|UTF|3262484|文件必须保存为带有物料清单的UTF-8格式，这就是您选择UTF-8时记事本所执行的操作。|unordered-list-item|3262485|
|3262486|你必须使用逗号或分号分隔符，但不能使用区域设置中的小数点分隔符。也许其他字符也可以，但我不知道是哪种字符。|3262487|3262488|您必须在文本字段和记录分隔符中引用包含换行符的字段“character.|3262489|3262490|I've+used+Windows行尾(\r\n)，这是可行的。|3262491|3262492|您必须双击文件才能打开它，从文本导入数据无效。|3262493|3262494|希望这对某些人有帮助。|3262495|entityMap^0|0|0|0|0|0|0|3|4|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1K|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1L|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|1M|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|1N|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|1O|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1P|8|@$Q|1Q|R|1R|S|T]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1S|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1T|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|10|7|1U|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1V|8|@]|9|@]|A|$]]|$1|13|3|14|5|10|7|1W|8|@]|9|@]|A|$]]|$1|15|3|12|5|6|7|1X|8|@]|9|@]|A|$]]|$1|16|3|17|5|10|7|1Y|8|@]|9|@]|A|$]]|$1|18|3|12|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|19|3|1A|5|10|7|20|8|@]|9|@]|A|$]]|$1|1B|3|12|5|6|7|21|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|10|7|22|8|@]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|23|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|6|7|24|8|@]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|25|8|@]|9|@]|A|$]]]|1I|$]]

If you are doing this manually, download LibreOffice and use LibreOffice Calc to import your CSV. It does a much better job of stuff like this than any version of Excel I've tried, and it can save to XLS or XLSX as required if you need to transfer to Excel afterwards.

But if you're stuck with Excel and need a better fix, there seems to be a way. It seems to be locale dependent (which seems idiotic, in my humble opinion). I don't have Excel 2007, but I have Excel 2010, and the example given:

<pre><code>ID,Name,Description
"12345","Smith, Joe","Hey.
My name is Joe."
</code></pre>

doesn't work. I wrote it in Notepad and chose Save as..., and next to the Save button you can choose the encoding. I chose UTF-8 as suggested, but with no luck. Changing the commas to semicolons worked for me, though. I didn't change anything else, and it just worked. So I changed the example to look like this, and chose the UTF-8 encoding when saving in Notepad:

<pre><code>ID;Name;Description
"12345";"Smith, Joe";"Hey.
My name is Joe."
</code></pre>

But there's a catch! The only way it works is if you double-click the CSV file to open it in Excel. If I try to import data from text and chose this CSV, then it still fails on quoted newlines.

But there's another catch! The working field separator (comma in the original example, semicolon in my case) seems to depend on the system's Regional Settings (set under Control Panel -> Region and Language). In Norway, comma is the decimal separator. Excel seems to avoid this character and prefer a semicolon instead. I have access to another computer set to UK English locale, and on that computer, the first example with a comma separator works fine (only on doubleclick), and the one with semicolon actually fails! So much for interoperability. If you want to publish this CSV online and users may have Excel, I guess you have to publish both versions and suggest that people check which file gives the correct number of rows.

So all the details that I've been able to gather to get this to work are:

<ol>
<li>The file must be saved as UTF-8 with a BOM, which is what Notepad does when you chose UTF-8. I tried UTF-8 without BOM (can be switched easily in Notepad++), but then double-clicking the document fails.</li>
<li>You must use a comma or a semicolon separator, but not the one that is the decimal separator in your Regional Settings. Perhaps other characters work, but I don't know which.</li>
<li>You must quote fields that contain a newline with the " character.</li>
<li>I've used Windows line-endings (\r\n) both in the text field and as a record separator, that works.</li>
<li>You must double-click the file to open it, importing data from text doesn't work.</li>
</ol>

Hope this helps someone.

blocks|key|309928|text|粘贴到Notepad%2B%2B中，选择编码>在ANSI中编码，再次复制全部并粘贴到Excel中:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|309929|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Paste into Notepad++, select Encoding > Encode in ANSI, copy all again and paste into Excel :)

blocks|key|3262529|text|关于J+Ashley的评论%2B1。我也遇到了这个问题。事实证明，Excel需要：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3262530|3262531|带引号的字符串|unordered-list-item|3262532|中的换行符(“\n”)|3262533|3262534|每行之间的回车和换行符。|3262535|3262536|，例如|offset|length|style|BOLD|3262537|"Test",+"Multiline+item\n
multiline+item"\r\n
"Test2",+"Multiline+item\n
multiline+item"\r\n|code-block|syntax|javascript|3262538|我使用记事本%2B%2B正确地分隔每一行，并且只在字符串中使用换行符。通过在空白excel文档中创建多行条目并在记事本%2B%2B中打开csv发现了此漏洞。|3262539|entityMap^0|0|0|0|0|0|0|0|0|3|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|12|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|E|7|15|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|17|8|@$N|18|O|19|P|Q]]|9|@]|A|$]]|$1|R|3|S|5|T|7|1A|8|@]|9|@]|A|$U|V]]|$1|W|3|X|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Y|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|Z|$]]

+1 on J Ashley's comment. I ran into this problem also. It turns out that Excel requires:
<ul>
<li>A newline character(&quot;\n&quot;) in the quoted string
</li>
<li>A carriage return and newline between each row.
</li>
</ul>
E.g.
<pre><code>&quot;Test&quot;, &quot;Multiline item\n
multiline item&quot;\r\n
&quot;Test2&quot;, &quot;Multiline item\n
multiline item&quot;\r\n
</code></pre>
I used notepad ++ to delimit each row properly and to only use newlines in the string. Discovered this by creating multiline entries in a blank excel doc and opening the csv in notepad ++.

blocks|key|309950|text|我在法国区域设置的WinXP上使用Excel2010的经验|type|unstyled|depth|inlineStyleRanges|entityRanges|data|309951|309952|您导入的csv的分隔符必须对应于您的区域设置的列表分隔符(；在我的例子中)|unordered-list-item|309953|您必须双击浏览器中的文件。不要从Excel|309954|打开它|309955|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|M|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

My experience with Excel 2010 on WinXP with French regional settings

<ul>
<li>the separator of your imported csv must correspond to the list separator of your regional settings (; in my case)</li>
<li>you must double click on the file from the explorer. don't open it from Excel</li>
</ul>

blocks|key|309961|text|如果任何人偶然发现了这个帖子，并在这里寻找一个明确的答案，请访问(归功于提到LibreOffice的人：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|309962|1)安装LibreOffice+2)打开计算和导入文件3)我的txt文件有字段分隔，并以“4)另存为ODS文件5)在Excel中打开ODS文件5)打开ODS文件6)另存为.xls(x)+7)完成。8)这为我完美地工作，为我节省了大量时间！|309963|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

If anyone stumbling across this thread and is looking for a definitive answer here goes (credit to the person mentioning LibreOffice:

1) Install LibreOffice
2) Open Calc and import file
3) My txt file had the fields separated by , and character fields enclosed in " 
4) save as ODS file
5) Open ODS file in Excel
6) Save as .xls(x)
7) Done.
8) This worked perfectly for me and saved me BIGTIME!

blocks|key|309965|text|对于我来说，只要导入是以文本格式而不是csv格式完成的，就可以直接导入到Excel。M/|type|unstyled|depth|inlineStyleRanges|entityRanges|data|309966|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

What just worked for me, importing into Excel directly provided that the import is done as a text format instead as csv format. 
M/

blocks|key|313055|text|只需创建一个带有换行单元格的新工作表，将其保存到csv，然后使用可以显示行尾字符(如notepad%2B%2B)的编辑器打开它。通过这样做，您会注意到单元格中的换行符是用LF编码的，而“真正”的行尾是用CR+LF编码的。好了，现在你知道如何为excel生成一个“正确的”csv文件了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|313056|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

just create a new sheet with cells with linebreak, save it to csv then open it with an editor that can show the end of line characters (like notepad++). By doing that you will notice that a linebreak in a cell is coded with LF while a "real" end of line is code with CR LF. Voilà, now you know how to generate a "correct" csv file for excel.

blocks|key|3048907|text|我也遇到过类似的问题。我在MySQL里有一些twitter的数据。数据中包含换行符(+LF或\n)。我要求将MySQL数据导出到excel中。LF搞乱了我的csv文件导入。所以我做了以下事情-|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3048908|1.+From+MySQL+exported+to+CSV+with+Record+separator+as+CRLF
2.+Opened+the+data+in+notepad%2B%2B+
3.+Replaced+CRLF+(\r\n)+with+some+string+I+am+not+expecting+in+the+Data.+I+used+###~###!+as+replacement+of+CRLF
4.+Replaced+LF+(\n)+with+Space
5.+Replaced+###~###!+with+\r\n,+so+my+record+separator+are+back.
6.+Saved+and+then+imported+into+Excel|code-block|syntax|javascript|3048909|注意-在更换CRLF或LF时，不要忘记选中Excended+(\n，\r，\t...复选框[查看对话框的左下角)|3048910|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I had a similar problem. I had some twitter data in MySQL. The data had Line feed( LF or \n) with in the data. I had a requirement of exporting the MySQL data into excel. The LF was messing up my import of csv file. So I did the following -

<pre><code>1. From MySQL exported to CSV with Record separator as CRLF
2. Opened the data in notepad++ 
3. Replaced CRLF (\r\n) with some string I am not expecting in the Data. I used ###~###! as replacement of CRLF
4. Replaced LF (\n) with Space
5. Replaced ###~###! with \r\n, so my record separator are back.
6. Saved and then imported into Excel
</code></pre>

NOTE- While replacing CRLF or LF dont forget to Check Excended (\n,\r,\t... Checkbox [look at the left hand bottom of the Dialog Box)

blocks|key|3262661|text|我也有这个问题:即，csv文件(逗号分隔，双引号分隔的字符串)在带引号的字符串中包含LF。这些是下载的Square文件。我做了一个数据导入，但不是作为文本文件导入，而是作为“从HTML”导入。这一次它忽略了带引号的字符串中的LF。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3262662|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I also had this problem: ie., csv files (comma delimited, double quote delimited strings) with LF in quoted strings. These were downloaded Square files. I did a data import but instead of importing as text files, imported as "from HTML". This time it ignored the LF's in the quoted strings.

blocks|key|307938|text|这在Mac上有效，使用csv并在Excel中打开文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307939|使用python编写csv文件。|307940|data=‘“单元格A1的第一行\r单元格A1的第二行\r单元格a1的第三行”，“单元格b1"，”单元格C1的第一行\r单元格c1的第二行“\n”单元格a2的第一行“\n’|307941|File.write(数据)|307942|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

This worked on Mac, using csv and opening the file in Excel. 

Using python to write the csv file.

data= '"first line of cell a1\r 2nd line in cell a1\r 3rd line in cell a1","cell b1","1st line in cell c1\r 2nd line in cell c1"\n"first line in cell a2"\n'

file.write(data)

blocks|key|313067|text|在MacOS上尝试使用数字|type|unstyled|depth|inlineStyleRanges|entityRanges|data|313068|如果您可以使用Mac，我发现Apple+spreadsheet+Numbers可以很好地处理Excel无法处理的复杂多行CSV文件。只需打开带有数字的.csv，然后导出到Excel。|offset|length|style|BOLD|CODE|313069|entityMap^0|0|W|7|23|4|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@$D|M|E|N|F|G]|$D|O|E|P|F|H]]|9|@]|A|$]]|$1|I|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|J|$]]

<h2>On MacOS try using Numbers</h2>

If you have access to Mac OS I have found that the Apple spreadsheet Numbers does a good job of unpicking a complex multi-line CSV file that Excel could not handle. Just open the <code>.csv</code> with Numbers and then export to Excel.

blocks|key|3048976|text|在我的示例中，在notepad%2B%2B中打开CSV并将SEP=","添加为第一行允许我在Excel中打开CSV和utf-8，而不会出现问题|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3048977|entityMap^0|P|7|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In my case opening CSV in notepad++ and adding <code>SEP=","</code> as the first line allows me open CSV with line breaks and utf-8 in Excel without issues

blocks|key|3262672|text|将分隔符替换为TAB(\t)而不是逗号(，)。然后在编辑器(记事本等)中打开文件，从那里复制内容，然后将其粘贴到Excel文件中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3262673|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Replace the separator with TAB(\t) instead of comma(,).
Then open the file in your editor (Notepad etc.), copy the content from there, then paste it in the Excel file.

blocks|key|3262675|text|根据CSV标准，双引号内的换行符是完全可以的。Excel中换行符的解析取决于列表分隔符的OS设置：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3262676|高级窗口:您需要将列表分隔符设置为逗号(区域和语言»格式»高级)来源：https://superuser.com/questions/238944/how-to-force-excel-to-open-csv-files-with-data-arranged-in-columns#answer-633302|offset|length|3262677|Mac:需要将区域更改为美国(然后根据您的喜好手动更改其他设置)来源：https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/line-separator-comma-semicolon-in-excel-2016-for/7db1b1a0-0300-44ba-ab9b-35d1c40159c6+(请参阅|unordered-list-item|3262678|的答案)|ordered-list-item|3262679|3262680|3262681|在重试之前，不要忘记完全关闭Excel。|3262682|我已经成功地复制了这个问题，并能够在Max和Windows中使用上面的方法修复它。|3262683|entityMap|0|LINK|mutability|MUTABLE|url|https://superuser.com/questions/238944/how-to-force-excel-to-open-csv-files-with-data-arranged-in-columns#answer-633302|1|https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/line-separator-comma-semicolon-in-excel-2016-for/7db1b1a0-0300-44ba-ab9b-35d1c40159c6^0|0|Z|3B|0|0|Z|4A|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@$D|13|E|14|1|15]]|A|$]]|$1|F|3|G|5|H|7|16|8|@]|9|@$D|17|E|18|1|19]]|A|$]]|$1|I|3|J|5|K|7|1A|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1D|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1E|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]|Z|$5|U|V|W|A|$X|10]]]]

Line breaks inside double quotes are perfectly fine according to CSV standard. 
The parsing of line breaks in Excel depends on the OS setting of list separator:

<ol>
<li>Windows: you need to set the list seperator to comma (Region and language » Formats » Advanced)
Source: <a href="https://superuser.com/questions/238944/how-to-force-excel-to-open-csv-files-with-data-arranged-in-columns#answer-633302">https://superuser.com/questions/238944/how-to-force-excel-to-open-csv-files-with-data-arranged-in-columns#answer-633302</a></li>
<li>Mac: Need to change the region to US (then to manually change back other settings to your preference)
Source: <a href="https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/line-separator-comma-semicolon-in-excel-2016-for/7db1b1a0-0300-44ba-ab9b-35d1c40159c6" rel="nofollow noreferrer">https://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/line-separator-comma-semicolon-in-excel-2016-for/7db1b1a0-0300-44ba-ab9b-35d1c40159c6</a> (see NewmanLee's answer)</li>
</ol>

Don't forget to close Excel completely before trying again.

I've succesfully replicated the issue and was able to fix it using the above in both Max and Windows.

blocks|key|3049059|text|Excel在处理CSV时出现了令人难以置信的问题。LibreOffice在这方面做得更好。所以，我发现：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3049060|3049061|该文件必须以UTF-8编码，并使用|unordered-list-item|3049062|，因此请考虑这一点对于|3049063|下面的所有点，到目前为止，最好的结果是通过从文件资源管理器|3049064|打开它。如果您从中打开它，有两种可能的结果：|3049065|如果它只有ASCII码字符，它最有可能工作|3049066|如果它有非ASCII码字符，它将弄乱您的行breaks|3049067|3049068|3049069|​|3049070|3049071|它似乎在很大程度上依赖于在操作系统的区域设置中配置的小数点分隔符，因此您必须选择正确的分隔符|3049072|我敢打赌，它的行为可能也会因操作系统和|3049073|版本的不同而有所不同|3049074|entityMap^0|0|0|0|0|0|2|2|2|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|14|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|15|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|18|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|19|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1C|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|U|3|V|5|E|7|1E|8|@]|9|@]|A|$]]|$1|W|3|X|5|E|7|1F|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1G|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|11|$]]

Excel is incredibly broken when dealing with CSVs. LibreOffice does a much better job. So, I found out that:

<ul>
<li>The file must be encoded in UTF-8 with BOM, so consider this for all the points below</li>
<li>The best result, by far, is achieved by opening it from File Explorer</li>
<li>If you open it from within Excel there are two possible outcomes:

<ul>
<li>If it has only ASCII characters, it will most likely work</li>
<li>If it has non-ASCII characters, it will mess your line breaks</li>
</ul></li>
<li>It seems to be heavily dependent on the decimal separator configured in the
OS's regional settings, so you have to select the right one</li>
<li>I would bet that it may also behave differently depending on OS and
Office version</li>
</ul>

blocks|key|310038|text|使用Google+Sheets并导入CSV文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|310039|然后您可以将其导出以在Excel中使用|310040|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Use Google Sheets and import the CSV file.

Then you can export that to use in Excel

blocks|key|313145|text|概述|type|unstyled|depth|inlineStyleRanges|entityRanges|data|313146|在最初的帖子发布近10年后，Excel在导入CSV文件方面没有任何改进。但是，我发现它在导入HTML表时要好得多。因此，可以使用Python将CSV转换为HTML，然后将生成的HTML导入Excel。|313147|这种方法的优点是：(a)它工作可靠，(b)你不需要将数据发送到第三方服务(例如Google+sheets)，(c)不需要额外的“胖”安装(LibreOffice，Numbers等)。对于大多数用户，(d)比摆弄CR/LF字符和BOM标记更高的级别，(e)不需要摆弄区域设置。|313148|步骤|313149|只要安装了Python3，就可以在任何类似bash的shell上运行以下步骤。虽然Python可用于直接读取CSV，但csvkit用于执行到JSON的中间转换。这使我们不必在Python代码中处理复杂的CSV。|offset|length|313150|首先，将以下脚本另存为json2html.py。该脚本从stdin读取一个JSON文件，并将其转储为HTML表：|style|CODE|313151|#!/usr/bin/env+python3
import+sys,+json,+html

if+__name__+==+'__main__':
++++header_emitted+=+False
++++make_th+=+lambda+s:+"<th>%25s</th>"+%25+(html.escape(s+if+s+else+""))
++++make_td+=+lambda+s:+"<td>%25s</td>"+%25+(html.escape(s+if+s+else+""))
++++make_tr+=+lambda+l,+make_cell:+"<tr>%25s</tr>"+%25+(+"".join([make_cell(v)+for+v+in+l])+)
++++print("<html><body>\n<table>")
++++for+line+in+json.load(sys.stdin):
++++++++lk,+lv+=+zip(*line.items())
++++++++if+not+header_emitted:
++++++++++++print(make_tr(lk,+make_th))
++++++++++++header_emitted+=+True
++++++++print(make_tr(lv,+make_td))
++++print("</table\n</body></html>")|code-block|syntax|javascript|313152|然后，在虚拟环境中安装csvkit，并使用csvjson将输入文件提供给我们的脚本。使用-I参数禁用单元格类型猜测是一个好主意：|313153|$+virtualenv+-p+python3+pyenv
$+.+./pyenv/bin/activate
$+pip+install+csvkit
$+csvjson+-I+input.csv+%7C+python3+json2html.py+>+output.html|313154|现在可以在Excel中导入output.html。单元格中的换行符将被保留。|313155|或者，您可能希望清理Python虚拟环境：|313156|$+deactivate
$+rm+-rf+pyenv|313157|entityMap|0|LINK|mutability|MUTABLE|url|https://csvkit.readthedocs.io/en/latest/^0|0|0|0|0|1N|6|0|0|B|C|0|0|L|7|18|2|0|0|D|B|0|0|0^^$0|@$1|2|3|4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1D|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1E|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1F|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1G|8|@]|9|@$J|1H|K|1I|1|1J]]|A|$]]|$1|L|3|M|5|6|7|1K|8|@$J|1L|K|1M|N|O]]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1N|8|@]|9|@]|A|$S|T]]|$1|U|3|V|5|6|7|1O|8|@$J|1P|K|1Q|N|O]|$J|1R|K|1S|N|O]]|9|@]|A|$]]|$1|W|3|X|5|R|7|1T|8|@]|9|@]|A|$S|T]]|$1|Y|3|Z|5|6|7|1U|8|@$J|1V|K|1W|N|O]]|9|@]|A|$]]|$1|10|3|11|5|6|7|1X|8|@]|9|@]|A|$]]|$1|12|3|13|5|R|7|1Y|8|@]|9|@]|A|$S|T]]|$1|14|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]]|15|$16|$5|17|18|19|A|$1A|1B]]]]

<h1>Overview</h1>

Almost 10 years after the original post, Excel hasn't improved in importing CSV files. However, I found that it is much better in importing HTML tables. So, one can use Python to convert CSV to HTML and then import the resulting HTML to Excel.

The advantages of this approach are: (a) it works reliably, (b) you don't need to send your data to a third party service (e.g. Google sheets), (c) no extra "fat" installations required (LibreOffice, Numbers etc.) for most users, (d) higher level than meddling with CR/LF characters and BOM markers, (e) no need to fiddle with locale settings.

<h1>Steps</h1>

The following steps can be run on any bash-like shell as long as Python 3 is installed. Although Python can be used to directly read CSV, <a href="https://csvkit.readthedocs.io/en/latest/" rel="nofollow noreferrer">csvkit</a> is used to do an intermediate conversion to JSON. This allows us to avoid having to deal with CSV intricacies in our Python code.

First, save the following script as <code>json2html.py</code>. The script reads a JSON file from stdin and dumps it as an HTML table:

<pre class="lang-py prettyprint-override"><code>#!/usr/bin/env python3
import sys, json, html

if __name__ == '__main__':
 header_emitted = False
 make_th = lambda s: "&lt;th&gt;%s&lt;/th&gt;" % (html.escape(s if s else ""))
 make_td = lambda s: "&lt;td&gt;%s&lt;/td&gt;" % (html.escape(s if s else ""))
 make_tr = lambda l, make_cell: "&lt;tr&gt;%s&lt;/tr&gt;" % ( "".join([make_cell(v) for v in l]) )
 print("&lt;html&gt;&lt;body&gt;\n&lt;table&gt;")
 for line in json.load(sys.stdin):
 lk, lv = zip(*line.items())
 if not header_emitted:
 print(make_tr(lk, make_th))
 header_emitted = True
 print(make_tr(lv, make_td))
 print("&lt;/table\n&lt;/body&gt;&lt;/html&gt;")
</code></pre>

Then, install csvkit in a virtual environment and use <code>csvjson</code> to feed the input file to our script. It is a good idea to disable cell type guessing with the <code>-I</code> argument:

<pre class="lang-sh prettyprint-override"><code>$ virtualenv -p python3 pyenv
$ . ./pyenv/bin/activate
$ pip install csvkit
$ csvjson -I input.csv | python3 json2html.py &gt; output.html
</code></pre>

Now <code>output.html</code> can be imported in Excel. Line breaks in cells will have been preserved. 

Optionally, you may want to cleanup your Python virtual environment:

<pre class="lang-sh prettyprint-override"><code>$ deactivate
$ rm -rf pyenv
</code></pre>

blocks|key|310967|text|这是针对Excel+2016的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|310968|使用Excel向导处理csv文件中的换行符时也遇到了同样的问题。|310969|之后，我尝试了使用"New+Query“功能：”Data+->+New+Query+->+From+File+->+From+CSV+->“选择”File+->“”Import+->+Load“|310970|对于所有有同样问题的人来说，它工作得很好，而且是一个非常快速的解决方法。|310971|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

This is for Excel 2016:

Just had the same problem with line breaks inside a csv file with the Excel Wizard.

Afterwards I was trying it with the "New Query" Feature:
Data -> New Query -> From File -> From CSV -> Choose the File -> Import -> Load

It was working perfectly and a very quick workaround for all of you that have the same problem.

blocks|key|313172|text|在使用Excel2019时，我通过Data+->从文本文件/+CSV导入CSV文件时遇到了类似的问题。一旦建立了连接并同步了数据，它就会报告xx错误，这是因为换行符导致的列移位。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|313173|我设法解决了这个问题|313174|313175|编辑查询(Query+->编辑)|ordered-list-item|313176|313177|313178|这将打开增强查询编辑器|313179|313180|313181|转到开始->高级编辑器|313182|313183|313184|这将以文本格式打开查询，其中第2行包含如下指令|313185|313186|Source+=+Csv.Document(File.Contents("my.csv")，Delimiter="，"，....，QuoteStyle=QuoteStyle.None)，|313187|将QuoteStyle.Csv的|313188|更改为QuoteStyle.None|313189|313190|313191|单击Finish|313192|313193|313194|应用并关闭|313195|313196|此处提供的文档：https://docs.microsoft.com/en-us/powerquery-m/csv-document|offset|length|313197|注意：从那以后，我找到了这个在UI中“隐藏”的地方。在Power+Query编辑器中，单击Data+source+settings，更改源(左下角)，换行符组合应该显示忽略引号之间的换行符。|313198|NB2。从荷兰Excel在这里工作，所以我上面提到的按钮标题等的翻译可能有点不对劲。|313199|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/powerquery-m/csv-document^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|8|1M|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|1S|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1T|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|1V|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]|$1|N|3|O|5|G|7|1Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|20|8|@]|9|@]|A|$]]|$1|R|3|S|5|G|7|21|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|22|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|23|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|24|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|G|7|25|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|26|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|27|8|@]|9|@]|A|$]]|$1|12|3|13|5|G|7|28|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|29|8|@]|9|@]|A|$]]|$1|15|3|-4|5|6|7|2A|8|@]|9|@]|A|$]]|$1|16|3|17|5|G|7|2B|8|@]|9|@]|A|$]]|$1|18|3|-4|5|6|7|2C|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|2D|8|@]|9|@$1B|2E|1C|2F|1|2G]]|A|$]]|$1|1D|3|1E|5|6|7|2H|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|6|7|2I|8|@]|9|@]|A|$]]|$1|1H|3|-4|5|6|7|2J|8|@]|9|@]|A|$]]]|1I|$1J|$5|1K|1L|1M|A|$1N|1O]]]]

With Excel 2019 I had a similar problem when working with CSV files via Data -&gt; Import from text file / CSV. Once the connection is made and the data is synced, it reported xx error(s) because of shifted columns caused by the line breaks.
I managed to solve this by
<ol>
<li>Edit the query (Query -&gt; Edit)
</li>
<li>This opens the Power Query Editor
</li>
<li>Go to Start -&gt; Advanced Editor
</li>
<li>This opens the query in text format, where line #2 had an instruction like
Source = Csv.Document(File.Contents(&quot;my.csv&quot;),[Delimiter=&quot;,&quot;, .... , QuoteStyle=QuoteStyle.None]),
</li>
<li>Change QuoteStyle.None to QuoteStyle.Csv
</li>
<li>Click Finish
</li>
<li>Apply &amp; close
</li>
</ol>
Documentation found here: <a href="https://docs.microsoft.com/en-us/powerquery-m/csv-document" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/powerquery-m/csv-document</a>
NB. I since found where this is &quot;hidden&quot; in the UI. In the Power Query-editor, click Data source settings, Change source (bottom left), and the Line breaks combo should say Ignore line breaks between quotes.
NB2. Working from Dutch Excel here so my above-mentioned translations of button captions etc. may be a little off.

I'm working on a feature to export search results to a CSV file to be opened in Excel. One of the fields is a free-text field, which may contain line breaks, commas, quotations, etc. In order to counteract this, I have wrapped the field in double quotes (").

However, when I import the data into Excel 2007, set the appropriate delimiter, and set the text qualifier to double quote, the line breaks are still creating new records at the line breaks, where I would expect to see the entire text field in a single cell.

I've also tried replacing CR/LF (\r\n) with just CR (\r), and again with just LF (\n), but no luck.

Has anyone else encountered this behavior, and if so, how did you fix it?

TIA, 
-J

EDIT: 
Here's a quick file I wrote by hand to duplicate the problem.

<blockquote>
 ID,Name,Description 
 "12345","Smith, Joe","Hey. 
 My name is Joe."
</blockquote>

When I import this into Excel 2007, I end up with a header row, and two records. Note that the comma in "Smith, Joe" is being handled properly. It's just the line breaks that are causing problems.

Importing CSV with line breaks in Excel 2007

数据转换

Windows

Python

MySQL

MacOS

JSON

我正在开发一个功能，可以将搜索结果导出到CSV文件中，以便在Excel中打开。其中一个字段是自由文本字段，它可能包含换行符、逗号、引号等。为了抵消这一点，我用双引号(")将该字段括起来。但是，当我将数据导入Excel 2007，设置适当的分隔符，并将文本限定符设置为双引号时，换行符仍然在换行处创建新记录，而我希望在单个...

问在Excel 2007中导入带换行符的CSV
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Excel 2007中导入带换行符的CSVEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在Excel 2007中导入带换行符的CSV
EN