csv文件用什么打開(kāi)

(資料圖)

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.

逗號(hào)分隔值(CSV)文件是包含數(shù)據(jù)列表的純文本文件。 這些文件通常用于在不同應(yīng)用程序之間交換數(shù)據(jù)。 例如，數(shù)據(jù)庫(kù)和聯(lián)系人管理器通常支持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.

這些文件有時(shí)可能稱(chēng)為字符分隔值或逗號(hào)分隔文件。 他們大多使用逗號(hào)分隔(或定界)數(shù)據(jù)，但有時(shí)也使用其他字符，例如分號(hào)。 這個(gè)想法是，您可以將復(fù)雜的數(shù)據(jù)從一個(gè)應(yīng)用程序?qū)С龅紺SV文件，然后將該CSV文件中的數(shù)據(jù)導(dǎo)入到另一個(gè)應(yīng)用程序。

CSV文件的結(jié)構(gòu) (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文件的結(jié)構(gòu)非常簡(jiǎn)單。 這是用逗號(hào)分隔的數(shù)據(jù)列表。 例如，假設(shè)您在聯(lián)系人管理器中有幾個(gè)聯(lián)系人，然后將它們導(dǎo)出為CSV文件。 您將獲得一個(gè)包含如下文本的文件：

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.

這就是一個(gè)CSV文件。 它們可能比這更復(fù)雜，并且可能包含數(shù)千行，每行上有更多條目或較長(zhǎng)的文本字符串。 一些CSV文件甚至可能沒(méi)有頂部標(biāo)題，而某些CSV文件可能會(huì)使用引號(hào)將數(shù)據(jù)的每一位括起來(lái)，但這是基本格式。

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.

這種簡(jiǎn)單性是一個(gè)特征。 CSV文件旨在方便導(dǎo)出數(shù)據(jù)并將其導(dǎo)入其他程序。 生成的數(shù)據(jù)是人類(lèi)可讀的，并且可以使用文本編輯器(如記事本)或電子表格程序(如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文件的內(nèi)容，請(qǐng)?jiān)谖募Y源管理器或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.

如果記事本很大，則可能無(wú)法打開(kāi)CSV文件。 在這種情況下，我們建議您使用功能更強(qiáng)大的純文本文件編輯器，例如Notepad ++ 。 要在安裝后在Notepad ++中查看CSV文件，請(qǐng)右鍵單擊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文件中看到明文數(shù)據(jù)列表。 例如，如果CSV文件是從聯(lián)系人程序中導(dǎo)出的，則您會(huì)在此處看到有關(guān)每個(gè)聯(lián)系人的信息，并將聯(lián)系人的詳細(xì)信息分類(lèi)到新行中。 如果它是從密碼管理器(如LastPass )中導(dǎo)出的，則您會(huì)在此處看到不同的網(wǎng)站登錄條目。

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.

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

如何在電子表格程序中打開(kāi)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.

您還可以在電子表格程序中打開(kāi)CSV文件，從而使它們更易于閱讀。 例如，如果您的計(jì)算機(jī)上安裝了Microsoft Excel，則默認(rèn)情況下，只需雙擊.csv文件即可在Excel中打開(kāi)它。 如果未在Excel中打開(kāi)，則可以右鍵單擊CSV文件，然后選擇“打開(kāi)方式”>“ 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.

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

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

Excel和其他電子表格程序會(huì)像顯示電子表格一樣顯示.CSV文件的內(nèi)容，并將其分類(lèi)為列。

如何將CSV文件導(dǎo)入應(yīng)用程序 (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文件的內(nèi)容或?qū)⑵渥鳛殡娮颖砀袷褂?，這就是您需要做的一切。 但是，許多CSV文件都可以導(dǎo)入其他程序中。 您可能會(huì)從Google通訊錄中導(dǎo)出聯(lián)系人，從LastPass中導(dǎo)出已保存的密碼，或者從數(shù)據(jù)庫(kù)程序中導(dǎo)出大量數(shù)據(jù)。 然后可以將生成的CSV文件導(dǎo)入支持該類(lèi)型數(shù)據(jù)的應(yīng)用程序。

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.

根據(jù)要從中導(dǎo)出數(shù)據(jù)的應(yīng)用程序，您可能需要為目標(biāo)應(yīng)用程序選擇適當(dāng)?shù)腃SV格式。 例如，Google聯(lián)系人可以導(dǎo)出為Google CSV(對(duì)于Google Contacts)或Outlook CSV(對(duì)于Microsoft Outlook)格式的聯(lián)系人。 無(wú)論哪種方式，您都會(huì)獲得一個(gè)包含數(shù)據(jù)的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.

在適當(dāng)?shù)膽?yīng)用程序中，查找“導(dǎo)入”或“導(dǎo)入CSV”選項(xiàng)，該選項(xiàng)使您可以選擇要導(dǎo)入的CSV文件。 例如，在Microsoft Outlook中，您可以單擊文件>打開(kāi)和導(dǎo)出>導(dǎo)入/導(dǎo)出>從其他程序?qū)?，或單擊文?gt;逗號(hào)分隔值以從CSV文件導(dǎo)入聯(lián)系人。

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文件是大多數(shù)人無(wú)需理會(huì)的東西。 但是，如果您曾經(jīng)需要將信息從一個(gè)應(yīng)用程序轉(zhuǎn)移到另一個(gè)應(yīng)用程序中，那么這就是它們的用處。

csv文件用什么打開(kāi)