# Reading Documentation Tool Files in Microsoft Office Excel - Honeywell TDC 3000

**URL:** <https://forumautomation.com/t/reading-documentation-tool-files-in-microsoft-office-excel-honeywell-tdc-3000/230>\
**Category:** Honeywell\
**Created:** [January 5, 2015, 6:39pm UTC](https://forumautomation.com/t/reading-documentation-tool-files-in-microsoft-office-excel-honeywell-tdc-3000/230 "2015-01-05T18:39:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![instrumen](https://forumautomation.com/letter_avatar_proxy/v4/letter/i/65b543/32.png) [@instrumen](https://forumautomation.com/u/instrumen)\
**Post date:** [January 5, 2015, 6:39pm UTC](https://forumautomation.com/t/reading-documentation-tool-files-in-microsoft-office-excel-honeywell-tdc-3000/230/1 "2015-01-05T18:39:24Z")

</div>

The below instructions will replace space followed by white space with a tab character -Use Documentation Tool and output the results of the query to a file on the HM -Transfer file from the HM to PC. File Transfer can be used for this -Open the file in Word -Click Edit, Replace -In the Find and Replace window, click the More button and then the Replace Tab -Click in the Find What input port, type a space and then click the Special button. Select WhiteSpace -Click in the Replace With input port, then click the Special button. Select Tab Character -Click the Replace All button -Click OK to the number of replacements made Microsoft Word window -Select File, Save As and save the file with a new filename as type Text Only (_.txt) -Start Excel and Open file created in the step above. Be sure Files of type is set for All Files (_.\*) -The Text Import Wizard should start, select delimited -If the file was outputed in Documentation Tool using the option With Field Descriptors, change the Start import at Row to bypass that imformation. Select Next -Insure the Delimiter has only the Tab checkbox checked. Click the Finish button
