# Excel output of FIX 4.2 tags/field names

**URL:** <https://forum.fixtrading.org/t/excel-output-of-fix-4-2-tags-field-names/182>\
**Category:** General Q&A\
**Created:** [August 10, 2017, 11:03am UTC](https://forum.fixtrading.org/t/excel-output-of-fix-4-2-tags-field-names/182 "2017-08-10T11:03:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![roddyscotland](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.fixtrading.org/roddyscotland/32/47_2.png) [@roddyscotland](https://forum.fixtrading.org/u/roddyscotland)\
**Post date:** [August 10, 2017, 11:03am UTC](https://forum.fixtrading.org/t/excel-output-of-fix-4-2-tags-field-names/182/1 "2017-08-10T11:03:08Z")

</div>

Hi all,

I’ve been looking, but so far haven’t found anywhere to get hold on an excel workbook with FIX 4.2 tags and fieldnames in (don’t need field values at this stage)

Anyone know if this exists ?

cheers  
Roddy

---

<div class="post-metadata">

**Author:** ![hanno.klein](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.fixtrading.org/hanno.klein/32/38_2.png) [@hanno.klein](https://forum.fixtrading.org/u/hanno.klein)\
**Post date:** [August 10, 2017, 12:24pm UTC](https://forum.fixtrading.org/t/excel-output-of-fix-4-2-tags-field-names/182/2 "2017-08-10T12:24:58Z")

</div>

Go to [https://www.fixtrading.org/standards/](https://www.fixtrading.org/standards/).  
Choose “Search FIXimate” at the lower bit of the page. A new tab will open with the latest FIXimate.  
Click on “FIXimate for legacy versions”. FIXimate will allow you to select an older version.  
Select FIX Version 4.2 and click on “Fields”, then “Sorted by tag number”.  
Click into the main window and do CTRL-C, go to Excel and do CTRL-V.  
Reduce content further as needed (e.g. some fields have extra rows).  
Feel free to post the result for everyone else to benefit from 🙂

Alternatively, go to the FIX 4.2 Spec ([https://www.fixtrading.org/standards/fix-4-2/](https://www.fixtrading.org/standards/fix-4-2/)) and copy the first two rows under “Field Definitions”.

The golden source is obviously the FIX Repository and its XML files. But it is harder to obtain the information from there.

---

<div class="post-metadata">

**Author:** ![roddyscotland](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.fixtrading.org/roddyscotland/32/47_2.png) [@roddyscotland](https://forum.fixtrading.org/u/roddyscotland)\
**Post date:** [September 5, 2017, 9:47am UTC](https://forum.fixtrading.org/t/excel-output-of-fix-4-2-tags-field-names/182/3 "2017-09-05T09:47:04Z")

</div>

Thanks Hanno, that’s useful !

link to excel version of FIX 4.2 fields from FIXimate here  
[https://1drv.ms/x/s!AqD9OOcGhwesxAN\_RFnXJmtlezDz](https://1drv.ms/x/s!AqD9OOcGhwesxAN_RFnXJmtlezDz)