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: