MIP Toolbox

eClinicalWorks Summary Consolidator

Upload multiple eClinicalWorks Excel workbooks. This tool extracts rows from each "Summary" sheet where Column Q is non-zero and consolidates them into a single export-ready file for MIP import.

Upload Workbooks

Select one or more .xlsx, .xls, or .csv eClinicalWorks files

Process & Filter

Rows from each "Summary" sheet where Column Q ≠ 0 are extracted

Export

Download as Consolidated_Summary.xlsx or .csv for MIP import

Session ID (Column R)

This value will be written into column R on every output row.

Session Description (Column T)

A description for this session (for reference).

Drop Excel workbooks here

or click to browse — .xlsx, .xls, or .csv, multiple files supported