Overview: Importing and exporting data

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

The software provides two basic mechanisms for importing and exporting data:

• By manually transferring data between a model and another application by using the Copy and Paste commands.
• By creating import and export links between the model and one or more Microsoft® Excel worksheets (.XLS and .XLSX files) or .CSV files so that you can automatically and manually import data from the spreadsheet into the model or export model data to the spreadsheet.

Linking your models to Excel or .CSV files provides an easy way to continually update your model with new values for use in your simulations, or to update the Excel or .CSV files with the values of the latest run of your model. It is generally the most practical method when you are bringing in data from a constantly changing source, or when you want to continually update another document with the output from your models.

What do you want to do?

Set up import links

Set up export links

Manage persistent import and export links

Create import and export files

Manually import and export data

Import data with Copy and Paste commands

See Also