locked
How to import data from excel sitting on sharepoint into excel RRS feed

  • Question

  • Hi All,

    I have an excel template and from that i want to connect to sharepoint and import data from a temp excel file sitting on sharepoint documents library. Is it possible to do it?

    I tried Get external data - other sources within excel to connect to sharepoint but i am not able to connect.

    Thanks,

    Zav

    Thursday, March 31, 2016 6:18 PM

Answers

  • Hi ZAV,

    have the method worked for you?

    First you should follow this video to create a excel file:
    https://www.youtube.com/watch?v=weyli9OGJhk

    Than you create a new tab in this excel file.
    In this new Tab put all your needed data and logic.

    Now you can get data from you sharepoint tab...

    Saw it in another thread:

    https://social.technet.microsoft.com/Forums/sharepoint/en-US/bc2f0180-e518-4d69-8ed9-9470aab813d2/import-data-from-excel-sitting-on-sharepoint-into-excel?forum=excel

    regards,

    • Proposed as answer by ruirds Monday, April 18, 2016 8:35 AM
    • Marked as answer by Chris yuri Wednesday, April 20, 2016 7:53 AM
    Monday, April 18, 2016 8:35 AM

All replies

  • Hi Zav,

    According to your description, you want to import excel data to SharePoint.

    Here are two ways to achieve this:
    1. Use “Import Spreadsheet” list. Here is a link:
    http://www.dummies.com/how-to/content/how-to-import-a-spreadsheet-into-sharepoint-as-an-.html

    2. Import data to SharePoint via MS access. Here is a video for SP 2010, it’s the same in 2013:
    https://www.youtube.com/watch?v=k0uSc-rFrAs

    You can check which is helpful to you.

    Best Regards,

    CY


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.


    • Edited by Chris yuri Friday, April 1, 2016 3:13 AM
    Friday, April 1, 2016 3:13 AM
  • Connect to the SharePoint Site from the Data connections in excel and then try to import data to and fro.

    Regards

    • Proposed as answer by Aravinda_SP Friday, April 1, 2016 5:21 AM
    Friday, April 1, 2016 5:21 AM
  • Hi Chris,

    I don't want to import data into sharepoint from excel, I want to import data from an excel (SP.xls) sitting on sharepoint to another excel sitting on my desktop (DP.xlsm).

    So i will open my excel DP.xlsm sitting on my desktop and via code or manually want to connect to sharepoint and import data from excel sitting on it (SP.xls)

    Thanks,

    Zav

    Friday, April 1, 2016 7:37 PM
  • I have mentioned in my post that

    I tried Get external data - other sources within excel to connect to sharepoint but i am not able to connect.

    Friday, April 1, 2016 7:38 PM
  • Hi ZAV,

    have the method worked for you?

    First you should follow this video to create a excel file:
    https://www.youtube.com/watch?v=weyli9OGJhk

    Than you create a new tab in this excel file.
    In this new Tab put all your needed data and logic.

    Now you can get data from you sharepoint tab...

    Saw it in another thread:

    https://social.technet.microsoft.com/Forums/sharepoint/en-US/bc2f0180-e518-4d69-8ed9-9470aab813d2/import-data-from-excel-sitting-on-sharepoint-into-excel?forum=excel

    regards,

    • Proposed as answer by ruirds Monday, April 18, 2016 8:35 AM
    • Marked as answer by Chris yuri Wednesday, April 20, 2016 7:53 AM
    Monday, April 18, 2016 8:35 AM