Skip to main content

Excel

Excel is Microsoft's popular spreadsheet application widely used for data analysis, reporting, and business intelligence.

Supported File Formats​

  • XLS: Legacy Excel format
  • XLSX: Modern Excel format
  • Advanced features: Merged cells and formulas supported

Supported Storage Locations​

  • Local: Direct file access
  • FTP/SFTP: File Transfer Protocol servers
  • SMB: Server Message Block protocol (versions 1.x, 2.x, 3.x)
  • Amazon S3: AWS S3 buckets
  • Alibaba OSS: Object Storage Service

Supported Data Types​

BOOLEAN, DATE, DOUBLE, STRING, TEXT

Quick Setup Guide​

1. Prepare File Access​

Ensure your Excel files are accessible via one of the supported protocols with appropriate credentials.

2. File Requirements​

  • Keep file sizes under 512 MB for optimal performance
  • Use consistent data types within columns
  • Include headers in the first row

Limitations​

  • Source only: Excel can only be used as a source in XPipes
  • One table per connection: Each connection represents a single worksheet/table
  • File size limit: Recommended maximum of 512 MB per file
  • No deletion sync: File or data deletions are not synchronized
  • Transformation only: Available only for data transformation tasks, not direct replication