Resource Center

Advanced Search
Technical Papers
Working Papers
Research Memoranda
GTAP-L Mailing List
GTAP FAQs
CGE Books/Articles
Important References
Submit New Resource

GTAP Resources: Frequently Asked Question Details

Subject: Working with HAR files

Question: How to open, read, convert or copy the contents from a HAR file

Answer:
  1. Download and install a program named viewhar.exe from: http://www.copsmodels.com/gpwingem.htm

  2. Open the HAR file, with this program viewhar.exe.

  3. You can now see the data on different headers, by doubleclicking each of them.

  4. You can copy the numbers from the HAR file to Excel by Export..Save Screen as CSV or Copy Screen to Clipboard and then pasting into Excel.

  5. If you want to convert this data into Excel readable form in entirety, you will have to use a program named HAR2CSV, which is also freely available at: http://www.copsmodels.com/gpmark9.htm

    Particularly look at bonus.txt for more details on them: http://www.copsmodels.com/ftp/gpextra/bonus.txt

    You need to be a bit familiar with DOS prompt to use this utility, so if you find step 4 convenient, please do it that way. To learn DOS environment just enough to handle this stuff, you might want to consider going through parts of the following document and exercises. Though these are meant for a different purpose and audience, I’ve often found them useful for anyone who wants to learn to work in DOS environment for some fairly simple tasks: http://www.gtap.agecon.purdue.edu/resources/res_display.asp?RecordID=2850


Source: E-mail Message

Date Added: 7/20/2011