SharePoint Document Issues

How to Change a SharePoint List Column's Internal Name

Amos GikundaAmos Gikunda Nov 3, 2026 868 views

Question details

Users need to change the internal name of a SharePoint list column, which is often automatically generated (e.g., field_1) when importing from Excel templates, to ensure proper integration with Power Automate.

How to Change a SharePoint List Column's Internal Name
Product
SharePoint
Device & OS
not provided
Scenario
Modifying SharePoint list structure and renaming columns for Power Automate and other integrations.
Observed behavior
The internal name of a SharePoint list column cannot be modified after it is created, preventing accurate references in external integrations.
Before you start

Before proceeding, ensure you have Full Control or Design permissions on the SharePoint list and note down all Power Automate flows, formulas, or list views that currently reference the original column.

Solution 1Recommended

Create a New Column and Migrate Existing Data

Since SharePoint permanently locks a column's internal name upon creation, the only way to change it is by creating a brand-new column with the correct name and transferring your data.

SharePoint sets a column's internal name exactly as it is typed at the moment of creation. If a column is created from an Excel template, it might default to generic names like 'field_1' or 'field_2'. Because this internal name is used heavily by Power Automate flows and API integrations, it cannot be modified later.

To resolve this, you must create a new column with your desired internal name, copy the data over, update your integrations, and safely delete the old column.

1
Create the new column

Navigate to your SharePoint list, click 'Add column', and choose the appropriate data type. In the 'Name' field, type the exact internal name you want (without spaces). Click Save.

2
Update the display name

If you want the display name to contain spaces or differ from the internal name, edit the column settings now and change the name. The internal name will remain locked as what you first typed.

3
Copy the existing data

Click 'Edit in grid view' on the SharePoint list. Select the data cells from the original column, copy them, and paste them into the newly created column. Click 'Exit grid view' to save the changes.

4
Update your integrations

Open Power Automate, Power Apps, and any list views or formulas that referenced the old column. Reconfigure them to map to the new column's internal name.

5
Delete the original column

Once all data is safely transferred and your integrations are functioning correctly, go to the old column's settings and click 'Delete' to keep your list organized.

Create a New Column and Migrate Existing Data
Avoid spaces when creating columns: When creating a new column, do not use spaces. SharePoint replaces spaces with '_x0020_', making the internal name overly complex. You can add spaces to the display name after the column is initially saved.
Free Microsoft Office alternative

Manage Your Spreadsheet Data Seamlessly with WPS Office

While SharePoint lists have strict rules for internal column names, managing your source data in spreadsheets shouldn't be restrictive. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, allowing you to easily prepare and format your Excel templates before importing them into SharePoint.

  1. 1. Download and install WPS Office: Visit the official WPS website to download the free office suite for your desktop or mobile device.
  2. 2. Prepare your spreadsheet data: Open your existing .xlsx files directly in WPS Spreadsheet. Format your column headers correctly, avoiding special characters or spaces if you plan to import the data into SharePoint.
  3. 3. Save in standard formats: Save your work in the standard Microsoft Excel format (.xlsx) to ensure a smooth transition when importing to external platforms.
Fully compatible with Microsoft Excel (.xlsx) formatsLightweight application that runs smoothly on all devicesFamiliar user interface with zero learning curve for Office usersFree to use for everyday document and spreadsheet management
microsoft office alternative - wps office

Frequently Asked Questions

How do I find the internal name of an existing SharePoint list column?

Go to 'List Settings' (via the gear icon) and click on the name of the column you want to check. Look at the URL in your web browser; the internal name is the text that appears exactly after 'Field=' at the very end of the URL.

Why did my SharePoint column get named field_1 automatically?

When you create a SharePoint list by importing an Excel spreadsheet, SharePoint often bypasses your custom headers to automatically generate generic internal names (like field_1, field_2) for stability. It then assigns your actual Excel headers as display names.

Can I change a SharePoint column's display name without affecting integrations?

Yes. You can rename a column at any time from the column settings. This only changes the display name visible to users. The underlying internal name remains exactly the same, so your Power Automate flows and integrations will not break.

Will deleting the original column break my Power Automate flows?

Yes, deleting the original column will break any flow, Power App, or calculated formula that references it. You must systematically update all dependencies to point to your new column before you delete the old one.