Easy loading, processing, and transferring data

Data Loader for Excel in detail

The Data Loader makes loading, processing, and transferring data from one XLS workbook or worksheet to another extremely easy.

By loading data with the Data Loader, you eliminate manual input errors and get the work done far faster. Data is loaded based on unique identifiers such as cells containing an ID number, a social security number, unique labels, or a combination of identifying cells. Data that is not loaded can be marked for easy identification and follow-up.

The data can be in any order. Data Loader has many options and is menu driven for ease of use.

There are actually three different data loaders, each designed to meet your needs:

Data Loader for Excel main dialog

Each of the different loaders are explained and illustrated in the help file on the Data Loader. To access the help file, just click on the dialog's Help button.

The Power Loader is the workhorse of the data loaders. It has many options. For example, it can:

• Use up to three columns that will be combined together to be a data identifier key.
• Check for duplicate identification keys in the destination.
• Delete data that has been loaded, so that you only have to process non-matching data.
• Use a prefix in addition to the identification columns.
• Specify a column that controls which sheet is used as the destination sheet.

Assume that you may have imported data like the following:

And you want to load the data in columns C into another sheet based on the names created by combining columns A and B.

The following is what the destination sheet looks like. Note that the order of the names is different and that the names are combined together:

If the destination sheet contains a column that contains the names "Bill Smith", "John Doe": then you can specify column A and B as the columns containing the identifiers. And you specify cell C1 as the start of the data. Power Loader will concatenate the names together and load the data on the matching rows on the destination sheet. The following is the result file after the Power Loader matches up the data on the input sheet with the names on the destination sheet:

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.
• Text Manager - Change case in Excel, Join text to one cell, Remove spaces, etc..