Updated: 11/13/2018 by Computer Hope

Export may refer to any of the following:

Export vs. Import1. To export is the steps of taking data from one program or computer to another. Exporting can be used as a method of backing up important data or moving data between two different versions of programs. For example, using the Microsoft Windows Registry editor, you can export key values in case mistakes are made when editing that key. If errors are made, or you want to restore the previous key, you can import that data back into the registry.

Export vs. import

As illustrated above right, when you export data, you are taking information from a program and writing it into a file. For example, you may export a Microsoft Excel spreadsheet to a CSV file.

When you import, you are bringing in information from a file into a program. For example, you could import a CSV file you downloaded from the Internet into an Excel spreadsheet.

Examples of exporting data

There are many reasons why you may need to export data from a program. Below is a list of the most common data export scenarios.

  • Backup data in a program or database. For example, exporting your address book or your e-mail from your e-mail program so that it can be restored if it is lost.
  • Moving data from one program to another. For example, when upgrading to a new version of a program or changing to a different software developer (e.g., changing browser).
  • Saving data in a program in a format that is compatible with a different program. For example, saving an Excel spreadsheet as a CSV file that can be imported into a database.
  • Saving portions of a larger set of data. For example, if you're working with a database with millions of customers you may want to export the data on all users of a certain state so that mailers could be made.

Where is the export option?

If the export option is available, it is typically available on the File menu section of the program or the same are you would find Save or the Save As option.

Note: Not all programs have an export option, but you may be able to use the Save As option and save the file as a different program that may be compatible with where you want to import your data.

2. In the bash shell, export is a builtin command. It configures an environmental variable to be passed on to the environment of any child shells of the current shell. For more information, see our export bash builtin command reference.

Import, Save As, Software terms