Importing and Exporting Data

Many models require imported numerical data from external applications, like spreadsheets. Or, you may need to export numerical data from a model to another application.

Use one of these options to get data into or out of your model:

For static data, test data, or data that doesn't change often, copy and paste the data to or from a spreadsheet or text file.
For data from a constantly changing source, or when you want to update an external data container with output from your model, create import and export links between the model and one or more Microsoft® Excel worksheets (.XLS and .XLSX files), .TAB files, or .CSV files.

Once links are created, you can import and export data automatically to and from the spreadsheet. The spreadsheet and the model are both kept in sync with each other.

What Do You Want to Do?

Import data with Copy and Paste commands

Set up import links

Set up export links

Create import and export files

Manually import and export data