3

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?

1

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

  • Just curious what does OOT mean in this context? – Burgi Nov 26 '15 at 11:34
  • 1
    Oot means sharepoint provides that functionality with one click – Waqas Sarwar MVP Nov 26 '15 at 11:42
  • But what do the letters actually mean? – Burgi Nov 26 '15 at 11:49
  • 2
    Out of the box...some use oot n some use oob or ootb – Waqas Sarwar MVP Nov 26 '15 at 11:56
1

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

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
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/

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.