4

so I know we can export a single list to an Excel Spreadsheet, but is there a way export multiple lists on that same spreadsheet?

Improve this question

4 Answers 4

Reset to default
2

there is no OOT functionality which support this but here is workaround, which may solve you problem.

  1. Go to SharePoint List A and then click on List tab on Ribbon control

  2. Then click on ‘Export to Excel’ button on ribbon control

  3. Save the file with meaningful name, for example: owssvrA.

  4. Repeat the steps for 1 to 3 for List B and save file with another name:owssvrB.

  5. Now we have 'MS Excel Web Query File' files for both lists.

  6. Open new excel application.
  7. Go to Sheet1 and click on any cell.

  8. Click on Data in ribbon

  9. Click on Existing Data Connection

  10. Click on ‘Browse for More’ and go to the location where ‘'MS Excel Web Query File’ files are saved.

  11. Select List A’s Query File and click Open.

  12. On Import Data pop up select ‘New Worksheet’, (if you know exact column numbers then choose existing worksheet and cell range).
  13. Now you have data of List in your Excel sheet.
  14. Rename sheet with name: “Sheet1” and you are done for list A.
  15. Now repeat same steps for List B and you have two lists data in two separate sheets. You can refresh data as well from the ribbon button. Isn’t it easy??

Source

Improve this answer
5
  • Just curious what does OOT mean in this context?
    – Burgi
    Commented Nov 26, 2015 at 11:34
  • 1
    Oot means sharepoint provides that functionality with one click
    – Waqas Sarwar MVP ♦
    Commented Nov 26, 2015 at 11:42
  • But what do the letters actually mean?
    – Burgi
    Commented Nov 26, 2015 at 11:49
  • 2
    Out of the box...some use oot n some use oob or ootb
    – Waqas Sarwar MVP ♦
    Commented Nov 26, 2015 at 11:56
  • Wondering whether there is a OOTB way now..
    – Rafs
    Commented Sep 8, 2021 at 13:45
2

Once you have an Excel workbook open, any time you Export a list to Excel it will prompt you asking where to put it. So if you want it in the same sheet or the same workbook, you can just select that option.

enter image description here

Improve this answer
1
  • Absolutely brilliant. Still works in 2022
    – SRR
    Commented Jan 18, 2022 at 14:10
0
  • Open List A in MS-Access
  • Open List B in the same Access file
  • Create a Query to Join the 2 lists
  • Export or Link to one Excel file
Improve this answer
0

I have seen this so many times and also always wanted to know if there was a way. Craig Tarr wrote up a way on how to do it using front-end code. Basically the script structures unstructured data using REST API. Once you have the data you can export to excel or another DB. Completely configurable.

https://www.gtconsult.com/extracting-unstructured-data-that-should-be-structured/

Improve this answer
1
  • The link works no more
    – Rafs
    Commented Sep 8, 2021 at 13:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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