这篇文章将帮助您拆分 CSV 文件(split CSV files)。当您有一些无法打开或完全加载的大型CSV文件时,它可以派上用场,因为 Microsoft Excel或某些CSV查看器程序中的最大列数和行数限制已达到。在这种情况下,您可以将巨大的CSV内容拆分为小文件,然后使用任何兼容的工具打开这些文件。
有一些免费的 CSV 拆分器软件(free CSV splitter software)和在线工具可用于拆分CSV文件。这篇文章涵盖了此类工具的列表。
在线 CSV(Online CSV)拆分器工具和软件拆分CSV文件
我们添加了2 个在线 CSV 拆分器工具(2 online CSV splitter tools)和 3 个免费软件来拆分大型 CSV(split a large CSV)。这些都是:
- 拆分 CSV
- 文本文件拆分器
- 大文件拆分器
- CSV 拆分器
- CSV 拆分器。
1]拆分CSV
Split CSV是一个免费的在线工具。此服务的免费计划允许您按文件数(file count)(输出文件的最大数量)、文件大小(file size)(每个输出文件的最大大小)和行数(line count)拆分 CSV 。您还可以在拆分之前预览输入的 CSV文件。(preview the input CSV)没有提到输入CSV的大小限制,但是当我测试此服务时,它很容易拆分超过 110 MB的CSV 。
此工具可让您通过四个简单的步骤拆分CSV 。使用此链接(this link)打开其主页,然后按照以下步骤操作:
- 从桌面上传CSV或从您的Google Drive帐户导入CSV 。
- 这是重要的一步。在这里您需要设置标题行数并选择按文件、行或大小拆分CSV 。使用选项并输入值。
- 添加(Add)或跳过列并确认您的操作。
- 提供电子邮件地址并使用拆分(Split)按钮。
之后,您可以等到该过程完成。或者您可以在电子邮件地址中获取输出链接。它的拆分过程很好,您将在几秒钟内获得输出CSV文件。(CSV)
2]文本文件拆分器
TEXT File Splitter是一款免费的在线工具,可以拆分大文本、日志、CSV 文件(split large text, log, CSV files)等。在免费版本中,您可以添加最大300 MB的(300 MB) CSV文件,将其拆分成更小的文件。也有使用字符拆分或行拆分的选项。
使用此链接(Use this link)打开其主页。单击(Click)加载文件(Load File)按钮以从您的 PC添加CSV 。在给定字段中添加一个数字以生成输出文件的数量。按Split! 按钮(Button)。它将处理输入,然后您可以下载包含CSV文件的 zip文件。
3]大文件拆分器
LargeFileSplitter是一个非常简单且有用的工具,用于拆分CSV和日志 ( TXT ) 文件。好处之一是它的拆分过程也非常快。在几秒钟内,一个非常大的CSV文件可以拆分为您选择的部分。
抓住这个工具(Grab this tool)并执行它。你会看到它的命令界面。之后按照以下两个步骤:
- 在其界面上拖放(Drag)一个CSV文件并按 Enter
- 提供输出文件的部分数(Provide the number of parts)(如 5、10、20 等),然后按 Enter。
它将开始处理。一个接一个,所有部分都创建为输出CSV文件,并且这些文件存储在存在输入(CSV)CSV的相同位置。
4] CSV拆分器
CSV Splitter工具带有一个非常简单的界面。它允许您根据行拆分大型CSV文件。(CSV)您可以定义每个输出文件的行数(number of rows per output file),并相应地拆分输入CSV。它还允许您将第一行设置为输出文件的列标题。查看输入CSV的行索引并将标题包含在所有输出文件中的选项也在那里。
(Grab a zip file)获取此开源CSV拆分器工具(CSV)的 zip 文件,将其解压缩并执行CSVSplitter.exe。打开其界面时,使用可用的浏览(Browse)按钮提供输入CSV和输出CSV文件的路径。(CSV)现在输入每个包或输出文件的行数,设置其他选项,然后使用执行(Execute)按钮。拆分过程完成后,您将在您设置的文件夹中获得CSV文件。
5] CSV拆分器
它与上述工具同名,但此CSV 拆分器(CSV Splitter)具有不同的界面。它允许您按部分或按行拆分大型 CSV 文件(split a large CSV file by parts or by rows)。例如,如果CSV的大小为 100 MB,您可以定义输出的部分数为5(say 5),然后它将CSV拆分为 5 个部分,每个部分大小为 20 MB。或者,您可以使用按行拆分CSV,输入每个输出的行数,它会根据您设置的行数生成CSV文件。(CSV)两种选择都不错,但拆分过程较慢。
此链接(This link)将帮助您下载其便携式EXE。启动该工具并使用“浏览文件”( Browse for files)按钮提供输入CSV 。之后,选择是否要按行或部分拆分CSV,然后根据所选选项输入数字。
最后,为输出命名,然后按转换(Convert)按钮。它将启动拆分过程并在存在输入CSV的同一位置创建一个文件夹。所有输出CSV文件都存储在该特定文件夹中。
希望(Hope)这些免费工具有助于将大型CSV文件拆分为可以轻松打开的小型CSV文件。(CSV)
Split CSV files with these free online tools and software
This post will help you split CSV files. It can come in handy when you have some large CSV file(s) that can’t be opened or loaded fully because the maximum number of columns and rows limit in Microsoft Excel or some CSV viewer program is reached. In such a case, you can split the content of a huge CSV into small files and then open those files with any compatible tool.
There are some free CSV splitter software and online tools available that you can use to split CSV files. This post covers the list of such tools.
Online CSV splitter tools & software split CSV files
We have added 2 online CSV splitter tools and 3 freeware to split a large CSV. These are:
- Split CSV
- TEXT File Splitter
- LargeFileSplitter
- CSV Splitter
- CSV Splitter.
1] Split CSV
Split CSV is a free online tool. The free plan of this service lets you split CSV by file count (maximum number of output files), by file size (maximum size for each output file), and line count. You can also preview the input CSV file before splitting it. The size limit for input CSV is not mentioned but it easily split a CSV more than 110 MB when I tested this service.
This tool lets you split a CSV with four simple steps. Use this link to open its homepage and then follow these steps:
- Upload a CSV from desktop or import CSV from your Google Drive account.
- This is an important step. Here you need to set the number of header rows and select split CSV by files, lines, or size. Use an option and enter the value.
- Add or skip columns and confirm your action.
- Provide an email address and use the Split button.
After that, you can wait until the process is completed. Or you can get the output link in the email address. Its split process is good and you will get the output CSV files within seconds.
2] TEXT File Splitter
TEXT File Splitter is a free online tool that can split large text, log, CSV files, etc. In the free version, you can add a maximum of 300 MB CSV file to split it into smaller files. The option to use character split or line split is also there.
Use this link to open its homepage. Click on the Load File button to add CSV from your PC. Add a number in the given field to generate the number of output files. Press Split! Button. It will process the input and then you can download a zip file that will contain CSV files.
3] LargeFileSplitter
LargeFileSplitter is a very simple and useful tool to split CSV as well as log (TXT) files. One of the good things is its split process is also very fast. Within a few seconds, a very large CSV file can be splitted into parts of your choice.
Grab this tool and execute it. You will see its command like interface. After that follow these two steps:
- Drag n drop a CSV file on its interface and press enter
- Provide the number of parts (like 5, 10, 20, etc.) for output files and press enter.
It will begin the processing. One by one, all parts are created as output CSV files, and those files are stored in the same location where input CSV is present.
4] CSV Splitter
CSV Splitter tool comes with a very simple interface. It lets you split a large CSV file based on rows. You can define the number of rows per output file and it split input CSV accordingly. It also lets you set the first row as a column header for the output file. The option to view the row index for input CSV and include the header in all output files is also there.
Grab a zip file of this open-source CSV splitter tool, extract it, and execute CSVSplitter.exe. When its interface is opened, provide the paths for input CSV and output CSV files using the available Browse buttons. Now enter the number of rows per package or output files, set other options, and use the Execute button. Once the splitting process is completed, you will get CSV files in the folder set by you.
5] CSV Splitter
It has the same name as the above-mentioned tool but this CSV Splitter has a different interface. It lets you split a large CSV file by parts or by rows. For example, if a CSV has 100 MB size, you can define the number of parts say 5 for output, and then it will split CSV into 5 parts with 20 MB size for each part. Or else, you can use split CSV by rows, enter the number of rows for each output, and it will generate CSV files according to the number of rows set by you. Both the options are good, but the split process is slower.
This link will help you download its portable EXE. Launch the tool and provide input CSV using Browse for files button. After that, select whether you want to split CSV by rows or parts, and then enter the number based on the selected option.
Finally, give a name for output, and press the Convert button. It will start the split process and create a folder in the same location where input CSV is present. All output CSV files are stored in that particular folder.
Hope these free tools will be helpful to split large CSV files into small CSV files that can be opened easily.