Excel & CSV Export

Export calculation results for verification, submittal, or documentation.

Opening the Export Dialog

A quick CSV export of the current results grid is available from the Output toolbar menu → Export to CSV (Ctrl+E). The full Storm Calcs Excel workbook export is launched from the same menu: Output → Export to Excel..., which opens the column-layout dialog described below before writing the workbook.

Export dialog showing column configuration with checkboxes and reorder buttons
Export dialog showing column configuration with checkboxes and reorder buttons

Column Configuration

The export dialog shows all available output columns with checkboxes. You can:

  • Toggle individual columns on/off using the checkboxes
  • Reorder columns using the Up/Down arrow buttons
  • Reset to Default to restore the standard column layout
  • Legacy HGL Calcs to switch to the classic Computation Sheet column order (see below)
  • Show All / Hide All for quick selection

Your column layout is saved with the project and also becomes the default for new projects.

Legacy HGL Calcs Preset

Click Legacy HGL Calcs in the export dialog to switch the column order and visibility to match the classic Computation Sheet workbook many firms have used for years — stations, hydrology, design and check storm intensity/Q, pipe geometry, HGL, headloss, inverts, Tc, and a comments column, in that order.

The preset also adds five columns to the export that the standard Storm Calcs layout doesn't otherwise carry:

  • Frequency Factor — the Cf multiplier applied to the rational method Q
  • Check Intensity — check-storm rainfall intensity at this pipe's Tc
  • Check Q — check-storm peak flow
  • Bypass Q — inlet bypass flow leaving this inlet (populated when the inlet module is enabled)
  • Comments — a blank, editable cell for reviewer notes

These five columns are appended to the workbook rather than inserted in the middle, so a saved column layout from an older HydraStorm version keeps deserializing correctly — existing projects pick them up automatically the next time you open the export dialog.

HGL To CAD Sheet

Every Excel export includes an HGL To CAD sheet: for each alignment run, a downstream-to-upstream list of station/HGL-elevation pairs plus a ready-to-paste "STA ELEV" text column. Copy that column into a CAD polyline command to draw the HGL directly on a profile. Every cell on the sheet is a live formula reference into the Storm Calcs sheet, so edits a reviewer makes there flow through automatically.

Export Formats

CSV Export

Simple comma-separated file with one header row and data grouped by alignment. Suitable for importing into other tools or quick review.

Inlet and Culvert CSV Export

When the inlet or culvert modules are enabled, each has its own Export CSV button on its results tab — independent of the pipe network's Storm Calcs export. Inlet CSV export includes spread, depth, gutter velocity, local/bypass/captured flow, frontal and side flow, weir and orifice capacity, and spread/depth limit flags. Culvert CSV export includes headwater depth and elevation for both inlet and outlet control, the controlling condition, tailwater, and outlet velocity.

Excel Export (Storm Calcs Workbook)

Full-featured workbook generated from a built-in template. Includes:

  • Storm control header — design return period, IDF coefficients, hydrology mode
  • Data organized by alignment with section headers
  • Configurable column layout matching your dialog selections
  • StormInputs sheet — Kj lookup reference
  • Hydrology Input sheet — IDF coefficients and basin data

Tip

The Excel export is designed to match the traditional storm drain calculation spreadsheet format that many engineers are familiar with. Use it to verify HydraStorm's calculations against your existing spreadsheet methods, or include it in your drainage report submittal.

Still want a spreadsheet? HydraStorm doesn't force you to abandon your review process. Click Export and you have a full Storm Calcs workbook ready for QA/QC or submittal — no manual data entry required.