CSV files are chunks of text used to move data between spreadsheets, databases, and programming language. If we move beyond 10 rows of product data, data analysis would be much easier. However, users often find themselves with hundreds of thousands of data points or more. Typically, producing large CSV files requires specialized software, because spreadsheet programs can’t handle them. Like Excel, spreadsheet software can have a difficult time opening very large CSVs.
Most popular spreadsheet software simply doesn’t have the muscle to open or convert large CSV files. Excel is limited to opening CSVs that fit within your computer’s RAM. For most modern computers, that means a limit of about 60,000 to 200,000 rows. For example, here what we see when opening our traffic violation data with Microsoft Excel:
We run into a similar issue opening the flat file with OpenOffice. The program tells us it couldn’t pull in all the data…
Fortunately, a powerful and easy-to-use tool-XLS2csv is able to convert enormous Excel data sets to CSV format with large size.
Note: XLS2csv runs on Mac only, Mac OS X 10.7(64-bit) or above is required.
Hope this helps those who are looking for an easy solution to convert Excel files to CSV with large size.