csv文件用什么打開_什么是CSV文件，如何打開它？

csv文件用什么打開

A Comma Separated Values (CSV) file is a plain text file that contains a list of data. These files are often used for exchanging data between different applications. For example, databases and contact managers often support CSV files.

逗號分隔值(CSV)文件是包含數據列表的純文本文件。這些文件通常用于在不同應用程序之間交換數據。例如，數據庫和聯系人管理器通常支持CSV文件。

These files may sometimes be called Character Separated Values or Comma Delimited files. They mostly use the comma character to separate (or delimit) data, but sometimes use other characters, like semicolons. The idea is that you can export complex data from one application to a CSV file, and then import the data in that CSV file into another application.

這些文件有時可能稱為字符分隔值或逗號分隔文件。他們大多使用逗號分隔(或定界)數據，但有時也使用其他字符，例如分號。這個想法是，您可以將復雜的數據從一個應用程序導出到CSV文件，然后將該CSV文件中的數據導入到另一個應用程序。

CSV文件的結構 (The Structure of a CSV File)

A CSV file has a fairly simple structure. It’s a list of data separated by commas. For example, let’s say you have a few contacts in a contact manager, and you export them as a CSV file. You’d get a file containing text like this:

CSV文件的結構非常簡單。這是用逗號分隔的數據列表。例如，假設您在聯系人管理器中有幾個聯系人，然后將它們導出為CSV文件。您將獲得一個包含如下文本的文件：

Name,Email,Phone Number,Address

姓名，電子郵件，電話號碼，地址

Bob Smith,bob@example.com,123-456-7890,123 Fake Street

Bob Smith，bob @ example.com，123-456-7890，Fake Street 123

Mike Jones,mike@example.com,098-765-4321,321 Fake Avenue
邁克·瓊斯(mike Jones)，mike @ example.com，098-765-4321,321 Fake Avenue

That’s all a CSV file really is. They can be more complicated than that, and can contain thousands of lines, more entries on each line, or long strings of text. Some CSV files may not even have the headers at the top, and some may use quotation marks to surround each bit of data, but that’s the basic format.

這就是一個CSV文件。它們可能比這更復雜，并且可能包含數千行，每行上有更多條目或較長的文本字符串。一些CSV文件甚至可能沒有頂部標題，而某些CSV文件可能會使用引號將數據的每一位括起來，但這是基本格式。

That simplicity is a feature. CSV files are designed to be a way to easily export data and import it into other programs. The resulting data is human-readable and can be easily viewed with a text editor like Notepad or a spreadsheet program like Microsoft Excel.

這種簡單性是一個特征。 CSV文件旨在方便導出數據并將其導入其他程序。生成的數據是人類可讀的，并且可以使用文本編輯器(如記事本)或電子表格程序(如Microsoft Excel)輕松查看。

如何在文本編輯器中查看CSV文件 (How to View a CSV File in a Text Editor)

To view the contents of a CSV file in Notepad, right-click it in File Explorer or Windows Explorer, and then select the “Edit” command.

要在記事本中查看CSV文件的內容，請在文件資源管理器或Windows資源管理器中右鍵單擊該文件，然后選擇“編輯”命令。

Notepad may have trouble opening the CSV file if it’s very large. In this case, we recommend you use a more capable plain text file editor like Notepad++. To view a CSV file in Notepad++ after installing it, right-click the CSV file and select the “Edit With Notepad++” command.

如果記事本很大，則可能無法打開CSV文件。在這種情況下，我們建議您使用功能更強大的純文本文件編輯器，例如Notepad ++ 。要在安裝后在Notepad ++中查看CSV文件，請右鍵單擊CSV文件，然后選擇“使用Notepad ++編輯”命令。

You’ll see the plaintext list of data in the CSV file. For example, if the CSV file was exported from a contacts program, you’d see information about each contact here, with the contact’s details sorted onto a new line. If it was exported from a password manager like LastPass, you’d see different website login entries on their own line here.

您將在CSV文件中看到明文數據列表。例如，如果CSV文件是從聯系人程序中導出的，則您會在此處看到有關每個聯系人的信息，并將聯系人的詳細信息分類到新行中。如果它是從密碼管理器(如LastPass )中導出的，則您會在此處看到不同的網站登錄條目。

In Notepad, the “Word Wrap” feature can make the data harder to read. Click Format > Word Wrap to disable it and make each line of data stay on its own line for improved readability. You’ll need to scroll horizontally to read the full lines.

在記事本中，“自動換行”功能會使數據難以閱讀。單擊格式>換行將其禁用，并使每一行數據保持在自己的行上以提高可讀性。您需要水平滾動以閱讀完整的行。

如何在電子表格程序中打開CSV文件 (How to Open a CSV File in a Spreadsheet Program)

You can also open CSV files in spreadsheet programs, which make them easier to read. For example, if you have Microsoft Excel installed on your computer, you can just double-click a .csv file to open it in Excel by default. If it doesn’t open in Excel, you can right-click the CSV file and select Open With > Excel.

您還可以在電子表格程序中打開CSV文件，從而使它們更易于閱讀。例如，如果您的計算機上安裝了Microsoft Excel，則默認情況下，只需雙擊.csv文件即可在Excel中打開它。如果未在Excel中打開，則可以右鍵單擊CSV文件，然后選擇“打開方式”>“ Excel”。

If you don’t have Excel, you could upload the file to a service like Google Sheets or install a free office suite like LibreOffice Calc to view it.

如果沒有Excel，則可以將文件上傳到Google表格等服務，也可以安裝免費的Office套件(如LibreOffice Calc)來查看。

Excel and other spreadsheet programs present the contents of a .CSV file as if it were a spreadsheet, sorting it into columns.

Excel和其他電子表格程序會像顯示電子表格一樣顯示.CSV文件的內容，并將其分類為列。

如何將CSV文件導入應用程序 (How to Import a CSV File Into an Application)

If you just want to view the contents of a CSV file or work with it as a spreadsheet, that’s all you need to do. However, many CSV files are made for importing into other programs. You might export your contacts from Google Contacts, your saved passwords from LastPass, or a large amount of data from a database program. The resulting CSV files can then be imported into applications that support that type of data.

如果您只想查看CSV文件的內容或將其作為電子表格使用，這就是您需要做的一切。但是，許多CSV文件都可以導入其他程序中。您可能會從Google通訊錄中導出聯系人，從LastPass中導出已保存的密碼，或者從數據庫程序中導出大量數據。然后可以將生成的CSV文件導入支持該類型數據的應用程序。

Depending on the application from which you’re exporting data, you may need to select an appropriate CSV format for the target application. For example, Google Contacts can export contacts in either Google CSV (for Google Contacts) or Outlook CSV (for Microsoft Outlook) formats. Either way, you get a CSV file containing the data, but it’s organized in a slightly different way.

根據要從中導出數據的應用程序，您可能需要為目標應用程序選擇適當的CSV格式。例如，Google聯系人可以導出為Google CSV(對于Google Contacts)或Outlook CSV(對于Microsoft Outlook)格式的聯系人。無論哪種方式，您都會獲得一個包含數據的CSV文件，但是它的組織方式略有不同。

In an appropriate application, look for the “Import” or “Import CSV” option, which lets you select the CSV file to import. For example, in Microsoft Outlook, you can click File > Open & Export > Import/Export > Import From Another Program or File > Comma Separated Values to import contacts from a CSV file.

在適當的應用程序中，查找“導入”或“導入CSV”選項，該選項使您可以選擇要導入的CSV文件。例如，在Microsoft Outlook中，您可以單擊文件>打開和導出>導入/導出>從其他程序導入，或單擊文件>逗號分隔值以從CSV文件導入聯系人。

CSV files are something most people never need to bother with. But, if you’ve ever needed to get information out of one application and into another, that’s what they’re there for.

CSV文件是大多數人無需理會的東西。但是，如果您曾經需要將信息從一個應用程序轉移到另一個應用程序中，那么這就是它們的用處。