Skip to main content

Working with Templates: Renaming Field Names in an ExtendInsights Table

ExtendInsights Data Management | How to rename column headers in Excel

Some NetSuite field names may not be intuitive for all users. For example, when entering Vendor Bills, the NetSuite field Entity actually refers to the Vendor.

To make templates easier to use, you can rename column headers in Excel without affecting how data maps to NetSuite.


What You Can Rename (and What You Can’t)

✔️ You can rename:

  • Column headers in Row 2, starting from Column C onward

  • This is the visible header row used by end users

❌ You must NOT rename or reorder:

  • Column A – Reserved Status Column

    • Used by ExtendInsights to display success, warning, and error messages

  • Column B – Internal ID Column

    • Used to track NetSuite record identifiers

  • Row 1 (hidden mapping row)

    • Contains the field mapping between Excel and NetSuite

⚠️ Renaming, reordering, or editing any of the above can cause uploads or updates to fail.


How to Rename Column Headers Safely

  1. Locate Row 2 in the ExtendInsights table (the header row).

  2. Start renaming headers from Column C onward.

  3. Click the header cell you want to rename (for example, Entity).

  4. Enter a more user-friendly name (for example, Vendor Name).


⚠️ Important Notes

  • Renaming a header changes only its visible label; it does not change how data maps to NetSuite.

  • Header renames are not saved with the template. Reloading the template restores the original headers.

  • Keep Column A and Column B in place, and do not edit or move Row 1.


Need Help?

If you’re unsure which columns are safe to rename:

📎 Include a screenshot of your template if possible.

Did this answer your question?