We help IT Professionals succeed at work.

Read Excel in php

Richard Korts
Is there a way to read an Excel file directly in php on a web server?

I'm looking at files of format .XLS & .XLSX

This is WITHOUT first saving them as csv or tab delimited, read the EXCEL directly.

Or mayby a utility that can be run on the web server that will read .XLS & output CSV?

Watch Question

PHPExcel can do this.  http://phpexcel.codeplex.com/wikipage?title=Features&referringTitle=Home

Read different file formats into your spreadsheet object

    Excel 2007 (spreadsheetML)
    BIFF5 (Excel 5.0 / Excel 95), BIFF8 (Excel 97 and higher)
    PHPExcel Serialized Spreadsheet
    Excel 2003 XML format
    Open Office Calc (.ods)
    Symbolic Link (SYLK)
    CSV (Comma Separated Values)