Export and import a deliverables list
After you export a deliverables list for a service line, you need to make sure that the list is correctly formatted before re-importing to GoFileRoom.
Export and format your deliverable list
Follow these steps to export and format your deliverable list:
- In GoFileRoom, selectAdministration,Manage FirmFlow, theListstab, then select the drawer and service.
- SelectDeliverablesfrom theListdropdown, thenExport.
- In theOpen or Savewindow, selectSave Asfrom the dropdown.
- Save the file as aCSV (Comma Delimited)file type.
- Open a new blank Microsoft Excel workbook and select theDatatab.
- Follow the step based on your version of Microsoft Office:
- Office 2010 or 2013: SelectFrom Text.
- Office 365, Excel 2016 or later: SelectGet Data,Legacy Wizards, thenFrom Text (Legacy).noteTo turn on the legacy import wizard in Microsoft Excel, selectFile,Options,Data, then mark theFrom Text (Legacy)checkbox.
- In the Import Text File window, select the CSV file you saved in Step 4, thenImport.
- In the Text Import Wizard, selectDelimited, thenNext.
- In the Delimiters section, clear theTabcheckbox and mark theCommacheckbox, then selectNext.
- In the Column data format section, selectText.
- Select each Data preview column and change each Data format to text. Repeat this step for each column in the data preview area.note
- You'll need to scroll to reveal all columns.
- Use ALT + T as a shortcut to change each column to ext data format.
- SelectFinishand save the file as anXLS (Excel 97-2003 Workbook)file
Once the file is saved, you can add additional deliverables or modify existing deliverables and their associated due date.
Import the deliverables list to GoFileRoom
Follow these steps to import the updated deliverables list to GoFileRoom:
- In GoFileRom, selectAdministration, thenManage FirmFlow.
- Select theListstab, then the drawer and service.
- SelectDeliverablesfrom theListdropdown.
- SelectBrowse.
- Go to your saved XLS/XLSX file and selectImport.
- SelectImport.