locked
Export Excel File With Formulas into A SharePoint List RRS feed

  • Question

  • Hello,

    I have an MS Excel file with formulas in the columns. How can I export this excel file into sharepoint list to maintain this formulas?

    Thank you.

    Tuesday, October 16, 2018 10:49 PM

Answers

  • Hi

    You can create a list according your excel column. Create calculated field for the columns with formulas.

    There is no other way.


    Justin Liu Office Servers and Services MVP, MCSE
    Senior Software Engineer
    Please Vote and Mark as Answer if it helps you.

    • Marked as answer by Tonik Systems Thursday, October 18, 2018 9:37 AM
    Thursday, October 18, 2018 1:00 AM

All replies

  • Hi

    Do you want to edit the excel online or import the excel data to SharePoint list?


    Justin Liu Office Servers and Services MVP, MCSE
    Senior Software Engineer
    Please Vote and Mark as Answer if it helps you.

    Wednesday, October 17, 2018 2:29 AM
  • Thanks for your response.

    I want to import to SharePoint List.

    I have an excel file that has calculated columns. Sample Columns: Name, Loan Amount, Interest, Principal, Balance etc.

    If Loan Amount if entered on the excel, it calculate other columns.

    What I want is to import this excel file into SharePoint List to maintain the calculation as it work on the excel file without having to redo the calculation on SharePoint List Setting.

    Thank you.

    Wednesday, October 17, 2018 1:25 PM
  • Hi

    You can create a list according your excel column. Create calculated field for the columns with formulas.

    There is no other way.


    Justin Liu Office Servers and Services MVP, MCSE
    Senior Software Engineer
    Please Vote and Mark as Answer if it helps you.

    • Marked as answer by Tonik Systems Thursday, October 18, 2018 9:37 AM
    Thursday, October 18, 2018 1:00 AM
  • Thank you. I appreciate.
    Thursday, October 18, 2018 9:37 AM