Vermont Department of Taxes, Taxpayer Services Division
Phone: (802) 828-2551 or Email: tax.business@vermont.gov
Revised September 2023 | Publicaon GB-1165
How to Save an Excel File as a Tab Delimited File
For Excel versions 2013 and newer
1
The Malt and Vinous Distribuon Report is saved as an Excel le on the Vermont Department of Taxes website.
This is done so that the template will automacally open in Microso Excel®. However, once you have nished
populang the spreadsheet with your distribuon informaon, you need to save the le in a
tab delimited text le format before aaching it to the myVTax webpage at the me of ling. If you need
further assistance with the steps shown below, please feel free to contact us at t[email protected]
Following are the steps to save the le in a tab delimited text le format. Remember that you should only
perform these steps aer you have nished populang the spreadsheet with your distribuon informaon.
1
Open the Malt and Vinous Spreadsheet
From the
completed Malt
and Vinous
Spreadsheet
saved on your
computer, clike
the File tab.
2
Excel Opons
Click Save As.
3
Click Browse and
choose a locaon to
save the “new” le.
For this example we
are saving it to the
desktop.
Browse for the File
4
Select File Type and Save
Click the arrow next
to the le type space
to open a dropdown
list.
Select Text (Tab
delimited) (*txt) from
the dropdown list, then
click Save.
This will format the le to wherever you saved it. This example was saved to
the desktop. Now your le is ready to be uploaded into the myVTax system.
