Upload to Google Drive, then export the file to Google Spreadsheet format. Should make it easier to manage and open.

Or try OpenOffice if you weren't using that already to open them.

200 megabytes for csv(text data) is really large.

Frank, I've had to do this with some large data files and found this software to work great at splitting large files. Check out

GSplit - File Splitter - Split Any File - Split Text and Log Files

Best,
Jack

i can help you out -- pretty cheap too. If there is a specific field you want the files chopped up on too i can split them anyway you need them... pm me if you are interested. if you are after file size that is easy enough too... what program are you using to open them with your mac ? 40mb may be too big still so i can further split them on a field (zip code/city or something) that is logical so the data is a little more managable.

cool, just a tip -- you should never concern your self with formatting within a database, if anything you should lower or upper everything and strip out number formatting for better querying... if you are planning to re-output the data you would want to handle specific formatting like that in your export script... you'll wind up running into weird issues with case sensitive languages or problems querying numbers if you try to retain the formatting from text data...

How many lines can you read in your editor? In UNIX/Linux, you can use wc -l to find out how many lines there are in a file, then use the head and tail commands to split it into two parts. Further split the two halves if still too big.

The MacOS is BSD based, and thus I presume it should have those commands as part of the OS.

I wouldn't recommend splitting based on file size - this may result in splitting part way through a line.

This may be too advanced but you are running on a mac which is basically unix under the hood.

There is a console application that allows you to type unix commands - not sure where it is as I'm on my pc.


So you could change to the directory containing the file.

e.g
cd /path/to/your/file

then type

wc -l <yourfilename>

This will tell you the number of lines in your file. For example it may come back and say you have 10000 lines. So you know 10000 lines = 200mb so 40mb would be 10000/5 (as 40 goes into 200 5 times). so 2000 lines.

So to cut your file in to 2000 line chunks you would type

split --lines=2000 <yourfilename>

this will throw out a number of files I cant remember if it's named something like
xa xb xc xd

Horribly complicated if you don't know unix I guess. But thought I'd put it out there as an option.