Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
working with a huge CSV file (over 10GB) on a mac?
Its 7 columns and 930,000 lines and 14.1 gigs. It won't open on Excel, OpenOffice, or Numbers.
I then tried using the UNIX split command in terminal and got the error message: "split too many files". Maybe I did it wrong? way I did it
split -l 100000 /users/myusername/Desktop/foldername\ file/filename.csv
I thought that would split it into 9 files of 100,000 lines each and one with 30,000
Bryan,
I changed the syntax for the file path and name to protect my privacy, and in the process messed up the syntax. It wasn't a problem with the syntax.
jimgmacmvp,
Excel 2011 for Mac is supposed to be able to handle up to over 1 million rows... supposed to. It didn't work for me. It opens up and it cannot lay down the data onto the sheet
2 Answers
- jimgmacmvpLv 79 years agoFavorite Answer
Numbers and OpenOffice can't handle that many rows, but Excel can do it easily because current versions of Excel can handle millions of rows.
You don't say whether you're using Excel 2010 for Windows or Excel 2011 for Mac, but the way to open a .csv file is similar. You can use either File > Open and change the file type to All Files, or use the Data tab of the Ribbon and click the Text button.
- Brian CLv 49 years ago
Your syntax is messed up between "foldername\ file". It expects one file when you run the command and the way you wrote it makes the CLI think there's two files.
+ Protip - Use the tab key to autocomplete your directory names, it's quicker and helps prevent mistakes.
