Frequently Asked Questions

Can I print the directory to Excel?
Last Updated 2 years ago

You can print to Save to Disk a "Tab-Separated Value (*.tsv)" file and open it in Excel.

To do this, you'll have to change the "Save as type" field first, then save the file.

image
Then open it from inside Excel:

image

You'll have to change the open file filter from All Excel Files to All Files in order to see the file in the browser:
image

image

I selected DirPrnInfo.tsv becase that is the filename I Save to Disk printed from Directory Printer:

image

The Text Import Wizard will appear. The default settings should work:

image

You want to be sure the columns display. If not, you might need to check Tab as a delimiter to use:

image

On the third screen you can correct any file type errors. Excel will try to interpret what's in a General column, but you might have to force some. As it turns out, the ---A---- attributes column can't be displayed by Excel because it thinks it is a formula. And, setting this to Text didn't fix it. So, yeh, this is a flawed example.

image

Click Finish and whammo:


image




Please Wait!

Please wait... it will take a second!