Forum Discussion

AndrewCrompton's avatar
AndrewCrompton
Copper Contributor
Aug 14, 2025
Solved

Create SPO list from csv with schema with calculated columns

Hi, I am trying to create a new SPO list from csv with schema. (I take the standard route: New, List, CSV. Then upload the csv file from my pc.) In general it is working ok, but I am unable to proc...
microsoft lists
  • PankajBadoni's avatar
    PankajBadoni
    Aug 15, 2025

    CSV import doesn't support formula logic: When you upload a CSV to create a list, SharePoint treats all columns as static data. Even if you include schema XML, calculated fields are not parsed as formulas — only their current values are imported.


    Calculated fields require manual creation: SharePoint needs you to define calculated columns directly in the list settings or via PowerShell/REST API — not via CSV.

PankajBadoni's avatar
PankajBadoni
Iron Contributor
Aug 15, 2025

CSV import doesn't support formula logic: When you upload a CSV to create a list, SharePoint treats all columns as static data. Even if you include schema XML, calculated fields are not parsed as formulas — only their current values are imported.


Calculated fields require manual creation: SharePoint needs you to define calculated columns directly in the list settings or via PowerShell/REST API — not via CSV.

  • AndrewCrompton's avatar
    AndrewCrompton
    Copper Contributor
    Aug 16, 2025

    Hi, Pankaj

    Thanks for this. Looks like I'll have to deal with the calculated fields manually, then. Maybe MS will get around to parsing such fields as formulas at some point - would be useful.

    Andrew

Resources