The Data Loader add-in for Microsoft Excel makes copying,loading, processing, and transferring data from one XLS workbook or worksheet to another extremely easy. It is compatible with Microsoft Excel 2007 to 2021 and Office 365.
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 four different data loaders, each designed to meet your needs:
The first three loaders above (Super Fast Loader, Fast Loader, and Power Loader) are designed for users who need to load price or other data based on data identifiers from one worksheet to another worksheet. The Super Fast Loader is extremely fast, about 5X faster than the Fast Loader. The Fast Loader is about 5X faster than the Power Loader. The Super Fast Loader is for loading data where both the source and destination sheets can be sorted. The Fast Loader does not sort, and has similar features. The Power Loader has the most features.
When you load your data, the source and destination worksheets can be in different files. The data in each worksheet can be in any order. Both use ID columns such as product numbers to identify and load data. And both will tell you which data has been loaded.
The Power Loader is the workhorse of the data loaders. It has many options. For example it can:
The following illustrates the Power Loader features. 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:
Customers who viewed the Data Loader also viewed: