Splitcsv.com is the fastest and easiest way to convert a CSV file to Excel format
SplitCSV.com is not only the easiest way to split a large csv file, it is also the fastest and easiest way to convert your csv files into excel files (with the .xlsx extension). If you have a large CSV file that is choking Microsoft Excel and too large to open in a specific program (like Excel, Google Sheets, Word, TextEdit, or Sublime text) you can use SplitCSV.com to break it apart into smaller files and then convert all those files into Excel files. This enables you to use the file(s) in Microsoft Excel or Google Sheets so you're less likely to hit the file size limit for Microsoft Excel or Google Sheets. Here is the easiest way to do it:
Click the Choose File button and select your csv (ending in .csv) file. The file will begin uploading immediately.
Indicate whether or not there is a header section, and if so how many lines should be copied into each split file.
You can choose how to split the file: you can limit the number of rows in each file (by selecting the Rows tab and entering the maximum number of rows in each file), the size of each file (by selecting the Size tab and then entering the appropriate size in bytes) or specify the exact number of files to produce (by selecting the Files tab and then entering the number of files to output). The image below shows an example of limiting the file size.
Select the Output Excel option as below: once you do this the split method will switch to records to match Excel's limit of 1,048,576 rows. If you would like fewer rows than that (so you have smaller files that are easier to open in Excel) you can lower the limit.
Press the Advanced Options button to move to the next step, then press the Confirm button to verify the choices. Press the Split button to pay and queue the split up and view the receipt.
The split will be queued for completion, and should be executed shortly. The receipt page will refresh to include a link to the split results: all results will be zipped up for download, and available as Excel files..
We automatically remove all rows that can't be successfully opened in Excel (typically this is because the CSV file has a cell with more than 32767 characters, which is Excel's limit for the size of content in a single cell): a separate excelerrors.csv file will be added to the results zip file. This errors file will include a copy of all rows that were removed.
All uploaded files will be kept for at most 7 days before being deleted: depending on volume it could be earlier. At no time is the original source file downloadable, and the link to download the results will only be available on the receipt page, no where else.
Happy splitting!
The Fastest Way to split a Text file into multiple files
