How To Split Large Excel or CSV Files into Smaller Files

Here is one method: The following is an example of splitting into 3 parts:

1) open the original file, select (highlight) the first 1/3 then Copy (Edit menu or Command C).

2) open a new blank document (Excel or a word processor document if CSV) and Paste

3) save the new document

4) repeat step 1 but copy the second 1/3 this time and create a new blank document each time

etc

etc

None of my business, but why do you need to split it into multiple smaller files -- not a common requirement?

split [-a suffix_length] [-b byte_count[k|m]] [-l line_count] [-p pattern] [file [name]]

is a native Terminal command. Read up more on https://developer.apple.com/library/mac/documentation/Darwin/Reference/ManPages/ man1/split.1.html

I prefer to use gSplit which is gnu coreutils.

You can install gnu coreutils using homebrew.

Addendum/correction

>You may also want to try a compression program with file-splitting abilities

However, that is only going to be useful if a certain file size (MB) is needed (for example, for transfers via email).

It will not help if the reason for splitting is a limited number of allowed entries in another program, as the case appears to be here. If so, the document somehow has to be divided/segmented within the original application.

Found this with an internet search; haven't used it but sounds like it will do what you need: http://nationbuilder.com/how_can_i_split_files_too_big_to_import

You may also want to try a compression program with file-splitting abilities (one example at http://kb.winzip.com/help/help_splitdlg.htm)

Jan

Hi, you can find my online tool to split csv file at http://splitfile.vavro.me/ . Enjoy !

We had this same issue a while ago and ended up building a free online csv splitter

This is by far the most simple, fast and free way of doing it.

http://monchito.com/blog/autosplit-csv

Thank you so much for sharing - this is exactly what I needed, simple and fast. You are a rockstar.