Export to excel - Multiple lists

Question

Hi All,

Please help me with below task.

I have two lists. List1 having reqid, attachments, title, description etc., and List2 having reqid,approvers,status,created etc.,

For eg., 
List1:

Reqid Attachments Title
1 1.docx   Test
2.ppt
3.xlsx

List2: 
Reqid Approvers  created
1 user1 8/10/2018 11:00 a.m
1 user2 8/11/2018 11:00 a.m
1 user3 8/12/2018 11:00 a.m

Now I need to export the data to the excel format which contains this data with reqid, attachments, approvers, created.

Please let me know if you need any information.

Regards,
Kumar

Answer 1

You can simply make a .txt or .csv - file of the lists and simply open them in Excel.

Answer 2

Hi,

Can you please let me know how to consolidate in one sheet with all the data? Hope there is no OOB way to consolidate for this format.

Please correct me if I am wrong.

Regards,

Kumar

Answer 3

Hi,

SharePoint OOTB feature supported to export list data to Excel:

You could do this action for each list to make it work.

Thanks

Best Regards

---

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [e-mail].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

Answer 4

Hi Jerry,

Thanks for your response. If you reefer my initial thread, I would like to export and consolidate the data from two lists based on the Reqid.

Please let me know if you have any clarifications.

Regards,

Kumar

Answer 5

Hi Kumar,

I understand you want to link the two list data based on the Reqid and export to Excel. Then there are two options:

1. Create a linked data source list like this and then export to list:

Join two Sharepoint Lists together by ID

Here is the same requirement thread for your reference:

collating two list into one and export to excel

2. Export two list with "Export to Excel" feature I suggested above and then use Excel build in formula "vlookup" function to merge the two list data:

Merge tables with VLOOKUP

Thanks

Best Regards 

---

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [e-mail].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

Answer 6

Hi Jerry,

Thanks for you suggestions. Can you please suggest any alternate way instead of doing it through designer. As this is the production application and having bulk in data, Request you to help me with any other approach.

Regards,

Kumar

Answer 7

Hi,

Without Designer, you will need to write CAML Query to join the two list data like this thread:

Join 2 lists in SharePoint using CAML query

And then export the data to Excel programmatically:

Export SharePoint list to Excel Programmatically using c#- SPListItemCollection.GetDataTable method

Thanks

Best Regards

---

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [e-mail].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

Answer 8

Hi,

 

I am checking to see how things are going there on this issue. Please let us know if you would like further assistance.

 

You can mark the helpful post as answer to help other community members find the helpful information quickly.

 

Thanks

 

Best Regards

---

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [e-mail].


Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

Answer 9

Hi Jerry,

Thanks for your help.

Regards,

Kumar