Exporting and Importing data via spreadsheet from/to solicitation campaign workbench

Summary:

How to Export and Import data via spreadsheet from/to solicitation campaign workbench?

Content (required):

Although we can export workbench content into spreadsheet today, there is no out-of-box functionality to import an edited version. Even if we go ahead to develop a “template” to convert supplier input into csvs before loading, there will be many steps and issues. Here are a few concerns off my head.

1. The exported spreadsheet cannot be directly used. Instead, user has to copy those content and paste them into our “template”.
2. The “template” may be only able to generate csvs instead of xmls as xsd doesn’t have “GtmCampaign”.