An XLS (Microsoft Excel) file is a spreadsheet containing lists of data for analysis. A direct mail marketer may use Excel to maintain a list of customer contacts or a researcher may use a spreadsheet to maintain statistical data. In some cases, these data lists in Excel may become extremely long, making it difficult to manage. You can split the XLS file into smaller pieces using software.
- Skill level:
Split the file using Excel Split Files Into Multiple Smaller Files Software from Sobolsoft. This basic utility takes the information from your large file and then sections it off at specified rows according to your selections. Add the Excel File to the work list, then click "Split" to complete the task. Keep in mind that this option is compatible only with Excel 2000 or later.
Import the Excel sheet into Microsoft Access as another option for splitting the file (located on the "Import" or "External Data" menu on the Access toolbar). Once you have the Excel information in Access, you can use the Table Analyzer wizard to split the information into smaller tables. When finished navigating the wizard, use the "Export" menu to export each table back to the Excel format.
Use the FXFisherman's CSV Splitter v1.1 by Sopheap LY to split your Excel files. To perform the split, you must first save the Excel file with a CSV extension (click "File," then "Save as," on the main menu). Upload the Excel CSV file, then enter the number of lines that you want in each new, smaller file. After hitting "Split Now!" the utility processes the action and saves your new files to your folder.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for