在Excel 2016中打开CSV文件 [英] Opening CSV files in Excel 2016

问题描述

我有一个新安装的Excel 2016，讨厌CSV文件。

显着点：

1. 我有两台机器，台式机和笔记本电脑，都运行相同版本的Excel。桌面工作正常，打开同样的问题文件格式正确。




2. 我可以在笔记本电脑上创建CSV文件，保存，再次打开笔记本电脑，




3. 即使在Notepad ++中打开它，仍然希望某种文件格式正常化，
   

4. 我已比较区域设置和Excel中的几乎所有设置。



5. 我尝试将文件重命名为TXT， up文本文件转换对话框，我选择了逗号分隔。第一次它忽略了，仍然有列A中的一切，第二次尝试，但实际工作，然而，这是一个裤子解决方案，我想要能够只打开CSV文件，而不保存为TXT，我使用许多不同的

任何人都有任何想法吗？

解决方案

我发现了一种将杂乱的CSV文件保存为漂亮的表格格式的方法，但我不确定

数据 - >新查询 - >从文件 - >从CSV

通过以这种方式打开CSV文件，将出现一个弹出的查询编辑器窗口，其中有一个组织良好的表格格式，您可以在其中编辑，保存并加载到您的Excel表格中。

我希望这有助于。

I have a new install of Excel 2016, that hates CSV files. It opens them with everything in one column flagpole style, down column A, with commas and speech marks visible.

Salient points:

1. I have two machines, desktop and laptop, both running same version of Excel. Desktop works fine, opens the same problem files formatted correctly.

2. I can create CSV files on laptop, save those, open them again on laptop, and it's fine.

3. Even opening it in Notepad++, saving in the hope of some sort of file format normalisation, and still no good.

4. I have compared regional settings and almost all settings in Excel.

5. I tried renaming the file to TXT, it brought up the text file conversion dialogue, I chose comma delimited. First time it ignored that, still got everything in column A, second attempt, that actually worked, however, that is a pants solution, I want to be able to just natively open CSV files without saving as TXT, I use many different ones every day.

Anyone got any ideas?

Thanks in advance.

解决方案

I've found a way of saving messy CSV files into a nice table format but I'm not sure if it will work for your case.

Data -> New Query -> From File -> From CSV

By opening the CSV file this way, a pop-up 'Query Editor' window will appear with a nicely organised table format where you can edit, save and load into your excel sheet.

I hope this helps.

这篇关于在Excel 2016中打开CSV文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！