Frequently Asked Question
Can I print the directory to Excel?
Last Updated 9 months 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.
Then open it from inside Excel:
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:
I selected DirPrnInfo.tsv becase that is the filename I Save to Disk printed from Directory Printer:
The Text Import Wizard will appear. The default settings should work:
You want to be sure the columns display. If not, you might need to check Tab as a delimiter to use:
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.
Click Finish and whammo:
To do this, you'll have to change the "Save as type" field first, then save the file.
Then open it from inside Excel:
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:
I selected DirPrnInfo.tsv becase that is the filename I Save to Disk printed from Directory Printer:
The Text Import Wizard will appear. The default settings should work:
You want to be sure the columns display. If not, you might need to check Tab as a delimiter to use:
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.
Click Finish and whammo: