Skip to main content
Documentation
Feature Requests Trust Center Status Page

Community

File Sync: Support XLSX files.

Answered
Ken Nguyen User

Fivetran File Sync is a great feature suite that can sync numerous file types: https://fivetran.com/docs/files#supportedfileformats

It would be great if Fivetran could support .xlsx file type as well, which is a spreadsheet file type. 

One of our data source is containing crucial meta data in a .xlsx file on their FTP server, we are having a custom script to periodically sync that file to BigQuery. Would be great if Fivetran can help automate this for us with the File-Sync Feature. 

Thank you for the great work, Really loving Fivetran so far!

Please sign in to leave a comment.

Comments

8 comments

Date Votes
  • Official comment
    Alison Fivetranner
    • Edited

    Hi Ken,

    Just a quick update on the current status of our support for Excel. We have been working to develop our support and have now released support for Excel files for all our of Magic Folder Connectors.
    Read more in our docs: https://fivetran.com/docs/files#supportedfileformats.

    We will continue to invest in our file product and love hearing feedback from our customers.

  • Prasad User

    Excel, JSON, XML, Avro, Parquet support is key 

  • Justin Wicks User

    Yes, this is urgently needed as so many business users work with plain Excel files, it would be really handy for them.

  • sivakumar Vanjavaka User

    Yup, should support basic flat files like xls, xlsx, txt and csv

  • Kevin Kim Fivetranner

    Hi Ken,

    Thank you for your feedback! Excel file support is a very common feature request for our file connectors, and is something many of our other customers have asked for.

    While we don't currently have planned, this is certainly something on our radar, and we will determine priority for it amongst other projects in our planning process. When we build this feature, you will be sure to hear from us in a product update!

  • Alex LEATHARD User

    Basic XLS and XLSX support for simple ranges is essential, e.g. read MyTab!B2:E45.

    More advanced features would be parsing column names, tables, named ranges.

    Even starting with, say, a dump of an XLS/XLSX to CSV, and using the existing CSV connector - and putting the onus on users to ensure the data are well-managed within the Excel document - would be a start.

  • Justin Wicks User

    Upvoting this request. I am getting many requests from the business for Excel file types via file syncs, SFTP/S3/Azure BLOB etc.

  • Kelly Anderson User

    Would love to have this option added for SFTP and S3.