Hello everyone. This is my first post. I welcome any thoughts, comments, or recommendations. Be advised that I am only self-taught when it comes to sharepoint development. I am a site collection admin, but do not have "higher" server-side admin access. Although I have access to Visual Studio and other development tools, any VS-based solutions will be over my head. I am just learning workflows. Fortunately, we have Nintex.

To illustrate my environment and specific requirements, I offer the following description:

4) Both spreadsheets are generated by two totally independent systems with which I have no interface capability. In other words, the spreadsheets will be the only mechanism that can provide updated data that needs to be reflected in the SPS list (item #1).

Endstate:

When "Alpha.xls" is uploaded to its' dedicated doc library, a workflow automatically starts and:1.Updates the list with any common records (based on Column 5) from the xls that already exist in the list2.Adds any records (based on Column 5) to the list from "Alpha.xls" that doesn't currently exist in the list3.Deletes any records (based on Column 5) from the list that are not in "Alpha.xls"4.No columns are ever added or deleted from the list.

When "Bravo.xls" is uploaded to its' dedicated doc library, a workflow automatically starts and:1.Updates the list with any common records (based on Column 5) from the xls that already exist in the list.2.No columns are ever added or deleted from the list.

My research implies that there should be a way to manually upload each spreadsheet into a document library or two different doc libraries (dedicated for this purpose) and have a workflow extract the relevant information from each XLS and update the SPS list as referenced in the above endstate. I have seen the Nintex-based CSV parse to SPS list solutions but it looks like my solution will be different.

\

Thanks in advance

Message was edited by: Mark Bailey Just added a clarification about which column is the primary data point that is common throughout all lists/excel docs/etc