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?
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
-
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
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.
-
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