13 Replies Latest reply on Jul 19, 2016 8:57 AM by monkeybreadsoftware

    Export alternatives for xls/xlsx

    PeterWindle

      Hello my fellow labourers of data...

       

      I have a client who often has to export xls format, in order to exchange data with overseas vendors... but they are moving to FileMaker 14, which drops the xls format in exporting.

       

      I want to move all exports to the one format, so I'm looking for alternative file formats that will be as Excel friendly as possible.

       

      In some cases, we will need to have the field names exported, so csv and tab separated text will not do. The merge format contains field names, but is not converted to Excel very well...

       

      I suppose I could create the first record to export to become the field names, but this seems like a band aid.

       

      Any other suggestions?