In addition to CSV and other formats, Designer Cloud Enterprise Edition can directly import Microsoft® Excel® workbooks. When the workbook is uploaded, you can select one or more of the worksheets to become separate datasets or to combine them into a single dataset.
Steps:
- In the menu bar, click Library.
In the Library page, click Import Data to select and upload your Excel workbook as an imported dataset. See Import Data Page.
Figure: Upload Excel workbook
Tip: If you experience issues uploading XLS/XLSX files that are larger than 35MB, you can convert the files to CSV files and then upload them.
- To add datasets:
- Create one dataset with all workbooks: Click the Plus icon next to the top-level item (
PointOfSaleData
in the above image). - Create individual datasets: Click the Plus icon next to each item you want to add as a separate dataset. The item is added to the right panel.
- You can always combine datasets together later using a union operation. See Union Page.
- Create one dataset with all workbooks: Click the Plus icon next to the top-level item (
- After your datasets have been added, you can edit the name and description information for each in the right navigation panel.
- Optionally, you can assign the new dataset(s) to an existing flow or create a new one to contain them.
This page has no comments.