How to Split an XLS File

Written by louise balle
  • Share
  • Tweet
  • Share
  • Email

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:
Easy

Other People Are Reading

Instructions

  1. 1

    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.

  2. 2

    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.

  3. 3

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.