What Is a Data Source?

Any file that contains data is considered a data source

A data source (sometimes called a data file) is just as simple as it sounds: a place from which data is obtained. The source can be any data of any file format, so long as the program understands how to read it. 

Various applications can use a data source, including database applications like Microsoft Access, MS Excel and other spreadsheet programs, word processors like Microsoft Word, your web browser, offline programs, etc.

A typical scenario when it comes to Microsoft Word using a data source is for Word to make a mail merge from data taken from an Excel document.

Important Data Source Facts

A data source file used in one program for one purpose might not have any relevance in a different program even if they both use data source files. In other words, a particular "data source" is subjective to the application using the data.

For example, a data source for a mail merge in Microsoft Word might be a CSV file containing contacts that can be automatically written to a Word document for printing envelopes with the correct names and addresses. Such a data source, however, might not be very useful in any other context.

Data Source Examples

As mentioned above, a data source, also called a data file, is simply a collection of records that store data. It's this data used to populate merge fields in mail merges. You can use any text file as a data source, be it a plain text file or an actual database file.

They can come from programs like MS Access, FileMaker Pro, etc. In theory, you can use any Open Database Connectivity (ODBC) database as a data source. You can also create them in spreadsheets from Excel, Quattro Pro, or any other similar program. The data source can even be a simple table in a word processor document.

A data source can be any document organized to provide structure for the receiving program to pull data. For example, an address book contact can be used in some scenarios because there's a column for a name, address, email account, etc.

Another data source might be a file that records the times that people check in to a doctor's office. A program can use the data source to aggregate all the check-in times and display them on a website or use them within an application, either for viewing the content or interacting with some other data source.

Data sources might also come from a live feed. The iTunes program, for instance, can use a live feed to play internet radio stations. The feed is the data source, and the iTunes application is what displays it.