Your First Excel to DAT Conversion

Excel to DAT conversion turns a spreadsheet of withholding or alphalist data into a BIR-compliant DAT file ready for eFPS or eSubmission upload. This guide walks through preparing your Excel file, uploading it to BIR Online Tools, mapping columns, fixing validation errors, and downloading the DAT output.

What do you need before converting Excel to DAT? #

You need a BIR Online Tools account, a prepared Excel or CSV file, and the correct BIR form type (for example BIR Form 1601C or 1601E) for the return you are filing.

Prerequisites:

• Active BIR Online Tools account
• Source file in .xlsx, .xls, or .csv
• Basic familiarity with the target BIR form layout

How should you prepare your Excel file? #

Clean, consistently formatted Excel data converts more reliably to DAT. Remove merged cells, keep one row per record, and use clear column headers that match BIR field names where possible.

File format requirements #

Example layouts by BIR form #

BIR Form 1601C (withholding tax on compensation):

BIR Form 1601E (government money payments):

BIR Form 1604E (annual information return):

How do you upload and configure the conversion? #

Log in to BIR Online Tools, open the Excel to DAT Converter, select the target form, upload your file, and set date, number, and encoding options before validation runs.

Access the converter #

1. Log in to your BIR Online Tools account
2. Open Tools → Excel to DAT Converter
3. Select the BIR form that matches your return

Upload your file #

1. Click Choose File or Browse
2. Select your prepared spreadsheet
3. Confirm file name and size
4. Click Upload and wait for automatic validation

Configure conversion settings #

Form selection (examples):

• 1601C — Withholding tax on compensation
• 1601E — Withholding on government money payments
• 1604E — Annual information return (creditable income taxes)
• 1604F — Annual information return (income taxes)
• 1604CF — Annual information return (corporations)
• 1604WP — Annual information return (withholding agents)

Conversion options:

• Date format — align with your Excel source
• Number format — decimal separator (period recommended)
• Encoding — usually UTF-8
• Validation level — strict recommended before first production upload

How do you review and fix validation errors? #

After upload, review the data preview, column mapping, and validation results before generating the DAT file. Fix TIN, date, and required-field issues in Excel and re-upload if needed.

Data preview and mapping #

• Preview table of parsed rows
• Suggested column-to-field mapping
• Highlighted required fields
• Error indicators per row or column

Common issues and fixes #

How do you download and verify the DAT file? #

Click Convert to DAT, review the conversion summary, then download the file and spot-check a few records in a text editor before uploading to BIR eFPS or eSubmission.

Conversion summary #

After processing you should see:

• Total records processed
• Successful row count
• Error count (if any)
• Generated DAT file size

Download and verification #

1. Download the DAT file to your computer (or save to cloud storage if enabled)
2. Open the file in a plain-text editor
3. Confirm delimiters, TINs, amounts, and dates match your source
4. Upload to BIR eFPS or eSubmission and retain the confirmation receipt

What are best practices for Excel to DAT workflows? #

Repeatable conversions depend on templates, pre-upload validation, and secure handling of tax data.

Data preparation #

• Clean and deduplicate rows before upload
• Use the same column layout each filing period
• Keep a copy of the original Excel and generated DAT
• Test with a small sample file first

Security #

• Log out after each session on shared computers
• Use trusted networks for uploads
• Delete temporary copies from local downloads folders when no longer needed
• Rotate account passwords on a regular schedule

Frequently asked questions #

What Excel formats can be converted to BIR DAT? #

BIR Online Tools accepts common spreadsheet formats including .xlsx, .xls, and .csv, provided the file meets size and row limits and uses clean column headers without merged cells.

What is the maximum file size for Excel to DAT conversion? #

Excel files should generally be under 10 MB with no more than about 1,000 rows per conversion, though always confirm current limits in the BIR Online Tools upload screen.

Which BIR forms support Excel to DAT conversion? #

Excel to DAT conversion supports withholding and annual information layouts such as BIR Form 1601C, 1601E, 1604E, 1604F, 1604CF, and 1604WP, depending on the form selected in the converter.

What causes invalid TIN errors during DAT conversion? #

Invalid TIN errors usually mean the TIN is missing digits, includes spaces or dashes, or does not match the nine- to twelve-digit format expected by the BIR DAT layout for that form.

What date format should I use before converting Excel to DAT? #

Use YYYY-MM-DD in your Excel source file or select a matching date format in the converter settings so dates survive validation and appear correctly in the generated DAT file.

Summary #

Converting Excel to BIR DAT format involves preparing a clean spreadsheet, selecting the correct form in BIR Online Tools, mapping columns, resolving validation errors, and verifying the DAT file before eFPS or eSubmission upload. Use consistent TIN and date formats, start with a small test file, and keep copies of both source and output for your compliance records.