Skip to main content

Fill in the Sheet

Data rows start below the column headers. Type values, paste them from another workbook, or download existing records and change them. This page covers what to enter in each kind of column and how rows are grouped into records.

New Records and Existing Records

The Internal ID column decides what happens to a row when you upload.

  • Leave Internal ID blank to create a new record.
  • To create a record from another transaction, such as a fulfillment from a sales order or a bill from a purchase order, also fill in its Created From cell. See Create Records From Another Transaction.
  • To update an existing record, download it first and then change the cells you need to. Downloaded rows arrive with their Internal ID, their Line IDs, and every current value filled in, so only your changes are sent. See Edit Existing Records.
  • On a sheet that matches records by External ID, the External ID in column A decides instead: a new External ID creates a record, and one NetSuite has updates that record. See Match Records by External ID.
  • On a sheet with a Delete column, pick Delete to delete the record when you upload. See Delete Records.

Warning: Let downloads and uploads fill in Internal ID, and never type one onto a row yourself, whether to edit a record or on a row you meant as a new one. If a record with that ID exists, the upload treats the row as that record's complete set of values: any column left empty clears that field in NetSuite, and because the row has no Line IDs, the record's existing lines are deleted. If no record has that ID, NetSuite rejects the row. The one exception is deleting a record: a row with only its Internal ID and Delete deletes it. See Delete Records.

A new record typed into a bulk record sheet

What to Enter in Each Column

Column typeEnterNotes
TextAny text.
NumberA number.Enter whole numbers in Integer columns.
Checkboxtrue or false.The column is text-formatted so Excel leaves the value as typed.
DateA date in your NetSuite date format, or yyyy-mm-dd, or an Excel date.Displayed as yyyy-mm-dd.
Date/TimeA date and time, for example 2026-03-15 14:30.Interpreted in the sheet's Time Zone, shown after the filter cells.
List (dropdown)Pick a name from the dropdown.To name a record by internal ID, enter id_ followed by the ID, for example id_42.
Multi-selectValues separated by ^, for example East^West.
FileAn image, PDF, or other file: its full path, or its name, such as taxi.pdf. Or right-click the cell and select Attach File....See Upload Files.

Remarks

  • A blank cell on a row that already exists in NetSuite clears that field when you upload. To uncheck a box, enter false. A blank checkbox on the record's body, or a blank custom checkbox, also unchecks it.
  • If the template gives a column a Default value, blank cells in that column receive it at upload.
  • Values that are only reference information (columns marked read only in the template) are never sent.

Columns whose template field has a list show an Excel dropdown. Pick from the list or enter an internal ID. Excel rejects other values with an alert.

Dropdown on a list column

If pasting removes a dropdown, select the cells and choose the list from Data Retrieval > Dropdowns to put it back. A list fetched from NetSuite or typed by hand is under Bulk Records, and a Finsyte list such as Customer or Item has its own entry in the menu. To take a dropdown off a range, use Productivity > Remove Dropdown.

Records With More Than One Row

For record types with lines, such as invoices, sales orders, and journal entries, each line is its own row. The header (body) fields are repeated on every row of the record, and the line fields differ from row to row. Lines of different sublists, such as a bill's item and expense lines, share rows side by side.

Each sublist also has a Line ID column, such as Items: Line ID, that holds NetSuite's ID for the line on that row. Leave it blank when you type new lines. See Work With Lines for how Line IDs decide which lines are kept, added, replaced, and deleted.

Records where some span several rows

Finsyte decides which rows belong together in one of two ways.

  • With a Record Group column (recommended): rows with the same Record Group value are one record. The rows do not have to be next to each other. Downloads fill in Group 1, Group 2, and so on. On rows you type yourself any value works, such as 1, 2, 3 or INV-A, INV-B.
  • Without a Record Group column: consecutive rows with identical body field values are one record. Change any body value, or leave a blank row, to start a new record.

In both cases, rows that share the same non-blank Internal ID are always treated as one record.

Remarks

  • Keep body fields identical on every row of a record. If they differ, Validate Sheet flags the cells. For a new record the first row's value is used. For an existing record the record is withheld from upload until the rows agree.
  • Keep the Internal ID on every row of an existing record. A row without it is read as a new record.
  • Templates that include Inventory Assignment fields show each row of a line's inventory detail on its own sheet row. See Inventory Detail.
  • To add, copy, replace, or delete lines on a downloaded record, follow the steps in Work With Lines.

Date/Time Columns and the Time Zone

Sheets with Date/Time columns show a Time Zone after the filter cells. Values you type are read in that zone and stored in NetSuite accordingly. The zone is stamped into the sheet when it is created, from the Override Computer Time Zone setting in General preferences or your computer's zone, and cannot be changed on the sheet. To work in a different time zone, change the preference and then create a new sheet from the template.

Date/Time column and the sheet's Time Zone

Tip: Run Validate Sheet before uploading. It catches names that are not on a list, dates in the wrong format, and missing required values without sending anything to NetSuite.

Next step: Upload Files