Once you created a workbook with one worksheet, you can easily add multiple worksheets to it.
Please follow the next steps to add another worksheet.
- Click on the "+" symbol to add another worksheet.
- It will open another window to select the name for the new worksheet.
- Click "Next"
- It will ask you to select the data source either by importing a "csv" file or select the existing managed data source
- By selecting "Managed Data Sources" and clicking on next.
- You will be moved to another screen like below, to select the type of "Managed Datasource" for example "competitor prices"
- Click on "Next"
Once the data source is selected, the user determines what data will be included and how it will be formatted (Example below)
Select the fields to be included: Identify which columns should be included in the workbook by selecting the “+” icon. They will turn into a check mark when chosen
One fields will be flagged as a having a unique property (ex. Product ID) for sorting purposes
Later on you will define the Data Type, by selecting the format of the data from the options available
Finalize the import: Review the selections and select “Finalize"
- The result after adding new worksheet will be as follows:
