Export Parameters and Variables to Excel

The tabular Parameters and Variables export is one of the Excel Tabular Exports, producing a workbook containing all Parameters and Variables of the current Module.

:clipboard: Overview

Parameters and Variables are the named values that drive process behavior — temperature setpoints, pressure limits, flow rates, timer durations, and runtime counters. In pharmaceutical manufacturing, these values are central to recipe management, batch control, and regulatory compliance.

Exporting them to Excel enables bulk review and editing by process engineers, simplifies validation documentation, and allows teams to compare parameter sets across modules or facilities.

:page_facing_up: Worksheets

The export produces two worksheets:

Worksheet	Content
Parameters	All Parameters of the module
Variables	All Variables of the module

:bar_chart: Columns

Each worksheet contains the following columns:

Column	Description
Name	The parameter or variable name (dominant column — used for row matching)
Parameter/Variable Fields	All built-in fields of the data type (e.g., Description, Default Value, Min, Max, Engineering Units)
Custom Attributes	Any custom attributes defined for Parameters or Variables

:jigsaw: Data Association

Element	Mapping
Worksheets	Two fixed worksheets: "Parameters" and "Variables"
Dominant column	Name — used to match rows during cumulative updates
Other columns	Parameter/Variable fields + Custom Attributes
Each row	One Parameter or Variable

:test_tube: Pharma Example

A CIP module's Parameters worksheet might look like this, capturing the critical process setpoints for cleaning cycle qualification:

Name	Description	Default Value	Min	Max	Eng. Units	Qualification Status
CIP_WashTemp_SP	Alkaline wash temperature setpoint	80.0	60	95	degC	Validated
CIP_RinseTime_SP	Final rinse duration	120	60	300	sec	Validated
CIP_Concentration	Caustic concentration target	2.0	0.5	5.0	% w/v	Pending
WFI_FlowRate	WFI final rinse flow rate	150	50	500	L/min	Validated

The Variables worksheet captures runtime values such as cycle counters, recorded temperatures, and operator-entered batch IDs.

Exporting these to Excel allows the quality team to review all process parameters in a single spreadsheet — ideal for preparing IQ/OQ documentation or comparing setpoints across different CIP skids.

:wrench: Tabular Export Options

This export type uses the following Excel Tabular Export options:

Option	Used
Worksheet Creation	Yes
Worksheet Reorder	Yes
Column Reorder	Yes
Column Creation	Yes
Column Deletion	Yes
Row Creation	Yes
Row Reorder	Yes
Row Deletion	Yes
Workbook Deletion	No
Worksheet Deletion	No

This means the export will create missing worksheets, reorder columns and rows to match the current data, and add or remove columns and rows as needed.

Parameters — the data type being exported
Variables — the data type being exported
Custom Attributes — additional columns
Excel Tabular Exports — the core engine and format rules
Export / Import Module Data — parent page for all module data exchange features