Can anyone tell me how to export SWMM's simulation output data to Excel? It appears SWMM won't allow copying and pasting from the output data tables in to another program.
An example of the information I am trying to export is in a screenshot below.
You need to be a member of SWMM 5 or SWMM or EPASWMM and SWMM5 in ICM_SWMM to add comments!
Replies
That's exactly what I needed - Thank you very much!
Robert Dickinson said:
Is there any way to do this in a more systematic way, like from the .INP?
You can load the input file directly to Excel using the SWMM 5 Excel tool
http://swmm2000.com/forum/topics/how-to-make-an-excel-fixed-width-f...
http://swmm2000.com/notes/SWMM_5_Tools
A good question - you can do it indirectly:
Step 1. Highlight the rows you want to copy to Excel
Step 2: Use the Copy to Clipboard or Copy to File command
Step 3: Paste in Excel or open the exported text file