Columns
The Columns area picks the fields that become columns on the sheet, sets their order, and configures each one.
Add Columns
- Open the Add columns panel at the top of the area.
- Search with the Search fields... box or browse the groups. Header fields are listed under Body Fields and each sublist is listed under its own name, such as Items or Expenses. Each group has a select-all checkbox and a count of selected fields.
- Check each field you want as a column. Fields marked
requiredwere detected as required by NetSuite. Fields markednot on formare not on the selected custom form.

Remarks
- A new template starts with a recommended set of columns for its record type, unless Start with recommended columns was unchecked on Basics. Reset to recommended restores that set and its defaults. Refresh reloads the field list from NetSuite. Remove all clears the column list so you can pick every column yourself.
- Fields that belong to a subrecord, such as a billing address, are grouped under an expandable node. Use those individual fields (for example Billing Address: Zip Code) rather than the combined address field. A change to an individual field updates every related address field in NetSuite, while a change to the combined field does not.
- Custom fields and custom segments appear in the list like any other field. Custom segments automatically use the matching Finsyte segment list for their dropdown.
- Fields of a nested list, such as a line's inventory detail, are grouped under their own node, for example Inventory Assignment in the Items group. Selecting any of them adds an ID column for that list (such as Inventory Assignment: ID) automatically. See Inventory Detail for which fields to choose.
- Every sheet gets a Line ID column per sublist on the template (such as Items: Line ID) automatically, so you do not add them. See Work With Lines.
- An opportunity has two body fields named Status. To change an opportunity's status (In Discussion, Proposal, Closed Won, and so on), add the one whose field ID, shown under its name, is
entityStatus. The other,status, is the opportunity's document status (In Progress, Issued Estimate, Closed – Won, Closed – Lost). NetSuite sets it from Probability, so a value uploaded to it is not saved: the upload succeeds, and the status doesn't change. - Some custom forms show a Location field on each item line, not only in the body. This is common when your account uses multiple locations. On those forms NetSuite requires a Location on every new item line, so if the sheet will add or replace item lines, include the Location column from the Items group as well as any body Location column.
Order Columns
The Your columns list shows the selected fields in the order they will appear on the sheet, left to right. Drag a column by its handle, or check one or more columns and use To top, Move up, Move down, and To bottom. Reset order returns to the default order.
To find a column in a long list, type part of its name in the Filter columns... box. Only the matching columns stay visible, so you can open a column's settings or remove it without scrolling. Clear the box to see the whole list again before you drag columns into order.
Each row in the list shows badges for the column's group (Body or the sublist name) and its settings, such as required, read only, or = <default value>.

Configure a Column
Select the gear icon on a column to open its settings.

| Setting | Effect on the sheet |
|---|---|
| Column name | The header text shown in Excel. The NetSuite field ID is shown beneath it for reference. |
| Default value | Used for any row where the cell is left blank. The cell stays blank on the sheet, and the default is filled in when you validate or upload. Type the value in the box as you would type it in the cell, for example a subsidiary's name for Subsidiary. Validate Sheet checks it like a typed value, so a misspelled default is flagged on the blank cell. |
| Required | The header is shown in bold with an asterisk, and Validate Sheet flags blank cells. |
| Read only | The column is shown on the sheet but its values are never sent to NetSuite. Useful for reference information such as a document number or a total. |
Important: Required is a Finsyte setting on the template, separate from what NetSuite requires. Finsyte turns it on for a column when NetSuite's record definition, the selected custom form, or a built-in list of common fields says the field is required, and that can include fields your NetSuite setup does not need. Uncheck Required on any column your team does not have to fill in.
The setting only controls two things on the sheet: the bold header with an asterisk, and the Validate Sheet warning for a blank cell. NetSuite checks its own required fields separately, when you upload.
Tip: Read only is also the right choice for fields NetSuite fills in itself, such as totals, document numbers, or calculated dates. NetSuite may reject a record when one of these fields is sent, so marking the column read only lets you see the value on the sheet without it being included in the upload.
The trash icon on a column's row takes the column off the template.
Important: The column layout is fixed when a sheet is created. Changing columns here affects sheets created after you save, not sheets that already exist. See Keep Templates Up to Date.
Next step: Filters