1099 Ready

Home › Guides

IRIS CSV upload errors for 1099-NEC and how to fix them

Short answer

IRIS CSV uploads fail when a cell breaks the IRS template rules: names and addresses may not have leading, trailing or adjacent spaces; business TINs must be XX-XXXXXXX and individual TINs XXX-XX-XXXX; business names are limited to 40 characters and individual first and last names to 20; addresses to 35 characters with letters, digits, spaces, hyphens and slashes only; states must be the 2-letter code; and amounts must be plain numbers. Keep the template's column order and header row, and upload at most 100 returns per file.

IRIS lets small businesses e-file Forms 1099 for free by uploading a CSV built from the IRS template. The template has strict cell rules, and a spreadsheet that looks fine can break several of them invisibly. These are the rules from the IRS template guidelines and how to find the cells that break them.

Quick steps

  1. Start from the IRS template. Download the IRIS CSV template for the tax year and keep its columns and header row exactly.
  2. Strip spaces. Use TRIM() in Google Sheets on names and addresses — it removes leading, trailing and repeated spaces.
  3. Format TINs. Write EINs as XX-XXXXXXX and SSNs/ITINs as XXX-XX-XXXX; restore leading zeros Sheets dropped.
  4. Check lengths and characters. Shorten names over the limits and remove characters the template does not allow.
  5. Split large files. Upload at most 100 returns per file.

The cell rules (IRIS 1099-NEC template)

  • Payer and recipient TIN type: SSN, EIN (recipient also ITIN, ATIN, QI-EIN or UND).
  • TIN: business XX-XXXXXXX; individual XXX-XX-XXXX.
  • Name type: B for business, I for individual.
  • Business name: up to 40 characters; letters, numbers, spaces and - # ( ) & ' only.
  • Individual first, middle and last name: up to 20 characters each.
  • Address: up to 35 characters; letters, numbers, spaces, - and / only. City: up to 40.
  • State: the 2-letter abbreviation. ZIP: 5 or 9 digits for US addresses.
  • No leading, trailing or adjacent spaces in any name or address cell.
  • Box 1 nonemployee compensation or box 2 direct sales must be filled.

Why Google Sheets data breaks them

  • Pasted names often carry a trailing space you cannot see.
  • A TIN or ZIP typed as a number loses its leading zero (02134 becomes 2134).
  • Large amounts can turn into scientific notation when exported.
  • Full state names (California) instead of codes (CA).
  • Business names with a period or comma (Smith, Inc.) — not in the allowed character list.

Finding the cells

Formulas such as =LEN(A2)<>LEN(TRIM(A2)) or =LEN(A2)>40 in a helper column find most problems. The 1099 Ready add-on runs all of the rules above on the rows that will actually be filed, highlights each cell, and (Pro) writes the CSV in the IRIS column layout, leaving out payees that still have errors.

Install from Google Workspace Marketplace — free check

Sources: IRS — IRIS CSV templates and formatting guidelines (ZIP) · IRS — E-file information returns with IRIS. Not tax advice — disclaimer.

FAQ

Can I upload an Excel file to IRIS?

The IRIS bulk upload takes CSV files in the IRS template layout. Save the sheet as CSV after checking the cells.

How many 1099s can one IRIS CSV hold?

Up to 100 returns per upload. Split larger lists into several files.

Do I need anything before uploading?

An IRIS Transmitter Control Code (TCC) from the IRS. Apply before the filing season.

Is a format check the same as TIN Matching?

No. A format check catches typos and impossible numbers; only the IRS TIN Matching program checks a name and TIN against IRS records.

Updated 2026-10-26.

More guides