Export Import to Excel

Table of contents

1. Export Import to Excel
   1. Overview
   2. Export Process
      1. Export to Excel
      2. Export Workflow
   3. Import Process
      1. Standard Import Process
      2. Import Workflow
   4. Complete Import Export Workflow

---

Export Import to Excel

Drawing Layers provides import and export capabilities that allow you to export layer data to Excel for external editing, analysis, and standarization or backup purposes, as well as import updated layer data with change detection feature.

Overview

Export and import functionality allows you to:

• Export layer data to Excel format for external editing
• Import updated layer data from Excel files
• Detect changes in imported data
• Review and validate changes before applying

Export Process

Export to Excel

Export data for external editing:

• Layers Export - Export layers data to Excel
• File Saving - Save Excel file with layer data
• External Editing - Edit data in Excel environment
• Data Preservation - Preserve all layer data and properties

GIF Placeholder: Demonstrate export to Excel

Export Workflow

1. Select Data - Choose data to export (for individual use or collaboration)
2. Configure Export - Set export options and settings
3. Choose Location - Select file save location
4. Execute Export - Perform the export operation
5. Verify Export - Verify exported data integrity
6. Share & Collaborate - Share file with team members for external editing (optional)
7. Collect Updates - Collect changes from team members and import back to tool (optional)

GIF Placeholder: Demonstrate standard export workflow

Import Process

Standard Import Process

The import process provides comprehensive data import capabilities with automatic change detection and flexible configuration options:

• File Selection - Select Excel file for import (updated data or team member files)
• Import Configuration - Configure import parameters, data mapping, and validation rules
• Change Detection - Automatically detect and highlight changes with color coding
• Data Selection - Choose specific data subsets, partial imports, or filtered data sets
• Change Review - Review detected changes with visual indicators and summary
• Validation - Validate imported data and detected changes for accuracy
• Custom Options - Create custom import configurations as needed

GIF Placeholder: Demonstrate standard import process

Import Workflow

1. Select File - Choose Excel file to import (from team members or updated data)
2. Configure Import - Set import options and settings
3. Review Changes - Review detected changes with color highlighting (changed values highlighted in green)
4. Validate Data - Validate imported data and changes
5. Apply Changes - Apply verified changes to layer data

GIF Placeholder: Demonstrate standard import workflow

Complete Import Export Workflow

The complete import export workflow:

1. Export Phase
   • Export layer data to Excel
   • Share file with team members
   • Allow external editing in Excel
2. Import Phase
   • Receive updated files from team members
   • Import changes with automatic detection
   • Review and validate all changes
   • Apply verified updates to layer data

GIF Placeholder: Demonstrate complete collaborative import export cycle