Excel转换为带有特殊字符的CSV吗? [英] Excel to CSV with special characters?

问题描述

我有1000行，其中许多行包含中文或特殊字符.我尝试将excel文件上传到Google表格并以CSV文件格式下载.但是，而不是显示? (就像我尝试通过excel另存为CSV一样)字符，它只会显示其他随机字符.

I have 1000 rows, many of which contain chinese or special characters. I tried uploading my excel file to Google sheets and downloading as a CSV file. However instead of displaying a ? (as it does when I try save as CSV through excel) character it just displays other random characters.

我需要做什么?

推荐答案

您应该使用UTF-8保存文件，以确保正确保存了所有字符.

You should save file with UTF-8 to make sure all characters are properly saved.

这篇关于Excel转换为带有特殊字符的CSV吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！