Rent 1099-MISC from a spreadsheet, for IRIS

If your business paid $600 or more in rent to a landlord who isn't a corporation, you usually file a 1099-MISC with the rent in Box 1. The IRS's IRIS portal takes them as a CSV in its own template. Here's how to make it from the list of landlords you already have.

Open the converter set to rent (1099-MISC Box 1) Free for up to 5 forms. Nothing is uploaded.

What you need

A spreadsheet with one row per landlord: name (or business name), tax ID from their W-9, street, city, state, ZIP and the total rent you paid them for the year. Save it as CSV (in Excel, File, Save As, "CSV UTF-8").

Make the file

  1. Open the spreadsheet to IRIS converter, already set to 1099-MISC Box 1: rents.
  2. Fill in your own business details as the payer, and drop the CSV.
  3. Check the column matches and the list of things to look at, like missing tax IDs or short ZIP codes, then download the IRIS 1099-MISC CSV.

It runs in your browser, so tax IDs never leave your computer. Up to 5 forms are free; more is $49 for the filing season, the same license as for 1099-NEC.

Who gets one

Open the converter set to rent (1099-MISC Box 1) Free for up to 5 forms. Nothing is uploaded.

Microsoft Publisher, Word and PowerPoint are trademarks of Microsoft; PageMaker and InDesign of Adobe; Canva and Affinity of Canva. I'm not affiliated with any of them.