Why should TIN and other identifier fields be formatted as text?

Spreadsheet software can alter long identifiers, leading zeros, dates, and coded values. Keeping sensitive identifiers as text helps preserve the characters entered in the source file.

What CSV format does IRS Publication 5717 recommend?

Publication 5717 recommends saving the upload as CSV UTF-8 (Comma Delimited) and warns that reopening a saved CSV in Excel can remove previous formatting.

Does completing this checklist guarantee IRIS acceptance?

No. It is a preparation checklist. The IRS applies the final form-specific formatting and validation rules.

Home / Free Tools / CSV Formatting Checklist

IRIS CSV preflight

Run a formatting checklist before you upload a CSV to IRIS.

This free checklist turns the practical CSV tips from the IRIS user guide into a quick preflight. Nothing is uploaded, and checking a box does not change your file.

✓ No file upload required

IRIS CSV formatting checklist

Mark each item only after you have verified it in your own file or workflow.

I have the current form-specific formatting guideUse the current IRIS guidance for the exact form and processing year you are filing.My final file is CSV UTF-8 (Comma Delimited)Publication 5717 recommends CSV UTF-8 (Comma Delimited) for the upload file.TINs, ZIP codes, account numbers and coded values were protected from spreadsheet reformattingKeep identifier-style fields as text when needed so leading zeros and long values are preserved.I rechecked the file after the final Excel savePublication 5717 warns that reopening a saved CSV in Excel can remove previous formatting.The header matches the exact form templateColumn names and order should match the current form-specific layout.Every data row has the same number of columns as the headerUnexpected commas or quoting problems can shift values into the wrong columns.The CSV is within the current portal file-size / record-count rulesPublication 5717 (Rev. 2-2026) states that CSV files can contain up to 250 forms; confirm the current portal guidance before filing.I ran the final CSV through a pre-upload validatorUse the free 1099ERICH validator as a structural pre-check, then rely on the IRS for final acceptance.

IRIS Error Troubleshooter Validate a CSV Download a Template

Why formatting gets lost

CSV files are simple, but spreadsheet programs can quietly change values.

The IRIS Taxpayer Portal User Guide recommends saving the file as CSV UTF-8 (Comma Delimited). It also warns that reopening a saved CSV in Excel can remove previous formatting, which means fields may need to be reformatted before saving again.

That is especially important for identifiers, codes, leading zeros, and values that spreadsheet software may convert to dates or scientific notation.

Use a controlled workflow

Start with the correct form template.
Enter or export the data.
Protect identifier fields from automatic conversion.
Save the final CSV.
Validate the final CSV, not just the spreadsheet.
Upload through IRIS and review the portal results.

CSV formatting FAQs

Common IRIS CSV preparation questions

Why use CSV UTF-8?

Publication 5717 recommends saving the upload as CSV UTF-8 (Comma Delimited). This is the format to use for the final file unless the current IRS instructions for your processing year say otherwise.

Why can reopening the CSV in Excel be a problem?

Spreadsheet software can reinterpret values and remove formatting. The IRIS user guide specifically warns that reopening a saved CSV in Excel can remove previous formatting.

Can the free validator guarantee that IRIS will accept the file?

No. It checks structure and common data hazards locally in your browser. The IRS applies the authoritative form-specific rules and final acceptance checks.

Source: IRS Publication 5717, IRIS Taxpayer Portal User Guide. Requirements can change, so confirm the current processing-year instructions before filing.

Free tool → complete workflow

Move from a free check to the complete 1099ERICH workflow.

The free tools help diagnose individual filing problems. 1099ERICH is the $299 Windows desktop workflow for importing CSV or Excel data, validating records, printing recipient copies, and creating IRIS-ready CSV files.

Windows desktopCSV + Excel importRecipient copiesIRIS-ready CSV$299

See 1099ERICH Software Purchase Details — $299 Compare pricing →