GoPie Logo

Exporting Results

Export your query results and visualizations from GoPie in various formats

Export your data, visualizations, and reports from GoPie in multiple formats to share insights with your team or integrate with other tools.

Export Formats

Data Exports

CSV (Comma-Separated Values)

  • Universal compatibility
  • Excel and spreadsheet ready
  • Preserves data types
  • Configurable delimiters

Excel (XLSX)

  • Multiple sheets support
  • Formatting preservation
  • Formula compatibility
  • Charts and pivot tables

JSON

  • Structured data export
  • API integration ready
  • Nested data support
  • Schema included

Parquet

  • Columnar storage format
  • Efficient compression
  • Big data compatible
  • Type preservation

Visualization Exports

PNG

  • High-quality images
  • Transparent backgrounds
  • Print-ready resolution
  • Email friendly

SVG

  • Vector graphics
  • Scalable without quality loss
  • Web-optimized
  • Editable in design tools

PDF

  • Document integration
  • Print-optimized
  • Multi-page support
  • Embedded fonts

Interactive HTML

  • Fully interactive charts
  • Self-contained files
  • Shareable via email
  • No dependencies

Export Options

Query Results

Full Dataset

Export complete query results:

  • All rows and columns
  • Applied filters included
  • Sort order preserved
  • Aggregations maintained

Filtered Data

Export subset of data:

  • Current view only
  • Selected columns
  • Row limits
  • Sampling options

Visualization Settings

Chart Configuration

  • Size and resolution
  • Color schemes
  • Labels and titles
  • Legend positioning

Layout Options

  • Single chart export
  • Dashboard export
  • Multi-chart layouts
  • Custom templates

Automated Exports

Scheduled Exports

Set up recurring exports:

  • Daily/weekly/monthly
  • Email delivery
  • Cloud storage upload
  • API webhook

Export Triggers

  • Query completion
  • Data refresh
  • Threshold alerts
  • Custom events

Export Destinations

Direct Download

  • Browser download
  • Compressed archives
  • Batch exports
  • Progress tracking

Cloud Storage

  • AWS S3
  • Google Cloud Storage
  • Azure Blob Storage
  • Dropbox/Box

Email Delivery

  • Attachment or link
  • Multiple recipients
  • Custom messages
  • Delivery scheduling

API Integration

  • Webhook delivery
  • REST API endpoints
  • Custom headers
  • Authentication support

Advanced Features

Data Transformation

Apply transformations during export:

  • Column renaming
  • Data type conversion
  • Custom formatting
  • Calculated fields

Templates

Use export templates for:

  • Consistent formatting
  • Brand compliance
  • Report standardization
  • Quick configuration

Compression

Optimize file sizes:

  • ZIP compression
  • GZIP for APIs
  • Streaming large files
  • Chunked downloads

Security and Compliance

Access Control

  • Permission-based exports
  • Audit trails
  • Download tracking
  • Expiring links

Data Protection

  • Encryption options
  • Watermarking
  • PII masking
  • Compliance tags

Best Practices

  1. Choose Appropriate Format: Match format to use case
  2. Consider File Size: Compress large exports
  3. Maintain Quality: Use vector formats for charts
  4. Document Exports: Include metadata and context
  5. Test Compatibility: Verify in target applications

Common Use Cases

Business Reporting

  • Executive dashboards (PDF)
  • Financial reports (Excel)
  • KPI tracking (automated email)

Data Science

  • Model training data (Parquet)
  • Analysis results (CSV)
  • Jupyter notebooks (JSON)

Presentations

  • Chart images (PNG/SVG)
  • Interactive demos (HTML)
  • Slide integration (PDF)

System Integration

  • Data pipelines (API)
  • BI tool import (CSV/Excel)
  • Database loading (Parquet)

Troubleshooting

Large Exports

  • Use pagination
  • Apply filters first
  • Choose efficient formats
  • Enable compression

Format Issues

  • Check encoding (UTF-8)
  • Verify delimiters
  • Test in target app
  • Use preview option

Next Steps