Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a large CSV file (about 6,000 rows) that I want to break up into smaller CSV files (about 100 rows each). Is there an easy way to do that?

share|improve this question

1 Answer 1

up vote 8 down vote accepted

CSV Splitter is a handy tool that allows you to define the number of lines and maximum pieces of output files. It will split the CSV file according to what you have defined.

alt text

1. Fill in necessary information:

  • CSV file: the path to the CSV that you wanted to split.
  • Number of lines: the maximum number of lines/rows in each splitted piece (100 in your case).
  • Max Pieces: limit the number of output files. '0' is unlimited.

2. Click Split Now! and that's it.

You will find the splitted pieces in a new folder of the same directory of the CSV file. By default, a folder {csv file name}_Pieces will be created and all of the output files will be stored under this folder. The output file format will be named as {csv file name}_1.csv, {csv file name}_2.csv, {csv file name}_3.csv and so on.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.