0

So I have a huge excel spreadsheet, with multiple lists and columns, how would I incorporate this into my SharePoint website as a new link? I know how to add an app, etc...but how do I add the spreadsheet with everything still intact with the different pages?

0

You upload each table as a separate list into SharePoint. However by the sounds of it this may not be the best solution as your excel document sounds quite complicated. You may have to do a bit of fiddling to get any connections and formulas right.

To export a given table into SharePoint click on the table and go to the table tab (Design) and click export > export table into SharePoint

| improve this answer | |
  • This might be my best bet. I didn't know if there were any simpler ways but thanks for the help! – J. McCormick May 8 '16 at 23:20
0

You can upload the spreadsheet in a document library and on the landing page of you SharePoint site, place the document library list view web part or you can just edit the page and insert a hyperlink and reference the Excel sheet.

| improve this answer | |
  • So there's no way to keep the formatting going from excel to SharePoint? I want the document to become a SharePoint list then from SharePoint to export to excel. – J. McCormick May 8 '16 at 18:42
  • if you have Excel Services installed on your environment, you can use it : support.office.com/en-us/article/… – Ahmed Mahmoud May 8 '16 at 21:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.