强制Excel在不格式化的情况下打开.csv [英] Force Excel to open .csv without formatting

问题描述

有没有一种方法可以强制Excel在不格式化的情况下打开.csv文件?我不希望它删除逗号并创建几列.我知道我可以在记事本中打开它，但我更喜欢使用excel.

Is there a way to force Excel to open a .csv without formatting? I don't want it to remove the commas and create several columns. I understand I could just open it in notepad but I'd prefer to use excel.

推荐答案

您不应从我的文档"中打开它；您可以打开Excel，可能会打开一个空白工作表，然后使用数据"，获取外部数据"，来自文本".

You should not open it from My Documents; you open Excel, possibly to a blank worksheet then use Data, Get External Data, From Text.

在导入向导"中关闭所有定界因素，它应该进入工作表，而不必在每行单个单元格之外分隔定界值.

Turn off all delimiting factors in the Import Wizard and it should come into the worksheet without separating the delimited values outside of a single cell per row.

这篇关于强制Excel在不格式化的情况下打开.csv的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！