Concept: Creating Workbooks
A workbook is the main container, or spreadsheet, in Worksheets. You can create a workbook in several ways, depending on the source data for the workbook:
Workbook Source Data | Steps | Notes |
|---|---|---|
New data. | From Drive, select . | Worksheets creates a blank workbook. |
Imported (uploaded and converted) from a non-Workday file. | To upload and convert a Microsoft®
Excel® file, or any file in comma-separated values (CSV) or HTML format, use one of these methods from Drive:
When you upload a type of file that Worksheets supports, Worksheets automatically converts it into a workbook. | Workday:
|
Workday application data (grid). | From the Workday action menu or from the Workday Reports page, select Export to Worksheets . | If you have access to Worksheets, the Export to Worksheets icon displays next to the Export to Excel icon. The created workbook:
|
Workday report. | From Drive, select . Then in the workbook select . For custom composite reports specifically, you can also click the Create Workbook button in the top right area of the report to automatically create a new workbook and add the results as live data. | You can insert data only from Workday reports that you have access to. You can manually refresh the workbook data and workbook owners can also schedule automatic live data refreshes. |
Integrating applications such as Payroll, Projects for Resource Forecasting, Mass Actions, Org Studio, and so on. | Follow the workflow steps in the integrating application documentation. |