Skip to main content
Solved

Excel file too large to read (error)

  • February 22, 2024
  • 1 reply
  • 46 views
vxn43
Supporter
Forum|alt.badge.img+18

I have an Excel 365 .xlsx spreadsheet that I am trying to read into a FME 2021 workspace. When I try to read it, it gives me an error message: 

|ERROR |Excel Reader: Could not open file '...\input.xlsx', file is too large. Try switching to 64-bit FME, or exporting the Excel file to CSV. If the file is exported to CSV, formulas and formatting will be lost...
T

 

I cannot change the spreadsheet to a .xls, it has to remain a .xlsx. 

Any ideas on how to solve this? 

 

The spreadsheet I need to read is 22mb with approximately 93,000 records. 

 

Best answer by danilo_fme

Hi @vxn43 

 

I found this question.

Excel reader: Could not open file, file is too large... | Community (safe.com)

 

Could you share your data?

View original
    danilo_fme
    1 person upvoted this
    • danilo_fme
      danilo_fme
    Did this help you find an answer to your question?

    1 reply

    danilo_fme
    Evangelist
    Forum|alt.badge.img+45
    • danilo_fmeEvangelist
    • Evangelist
    • Best Answer
    • February 22, 2024

    Hi @vxn43 

     

    I found this question.

    Excel reader: Could not open file, file is too large... | Community (safe.com)

     

    Could you share your data?

    virtualcitymatt
    hkingsbury
    vxn43
    3 people upvoted this
    • virtualcitymatt
      virtualcitymatt
    • hkingsbury
      hkingsbury
    • vxn43
      vxn43

    Reply


    Helpful Members This Week

    Community Stats

    31,223
    Posts
    118,401
    Replies
    38,824
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.