Line breaks inside a cell
An address typed on two lines in one cell splits the row in the CSV. The portal rejects it.
Pressing Alt+Enter in Excel puts a line break inside a cell. In the saved CSV that cell spans two lines, so the row no longer lines up with the header.
Publication 5717: "Expand each cell's height to ensure the cell is a single line", and put the second line of the address in the Recipient Address Line 2 column, not on a second line inside Address Line 1.
How to find them
- Open the .csv in a text editor (Notepad, TextEdit). A broken row starts mid-address with no "1099-NEC" at the front.
- In Excel, use Find with Ctrl+J in the search box to jump to cells that contain a line break.
Perfrow replaces every line break with a space, and moves a suite or unit to Address Line 2 when line 1 would pass 35 characters.
Fix the whole file at once
Drop in your blank IRIS template and your spreadsheet. Perfrow cleans every row, tells you which ones need you, and writes CSVs of at most 250 records. It runs in your browser, so names and TINs stay on your computer.
Open the 1099-NEC CSV fixerQuestions
- Can a cell in the IRIS CSV contain a line break?
- No. Publication 5717 lists a line break in a cell as a common reason for rejection. Each cell must be a single line.
Other answers: All 54 columns · Required fields · Character limits · State codes · 250-record limit · Why files get rejected · Scientific notation · ZIP code format · Date format · Extra spaces · Periods and # · $0.00 cells · Y/N check boxes · Tax year · Error types · Headers do not match · From QuickBooks · TIN format · Key dates