Convert FileMaker Pro 4 Data to Excel (Export as Merge Text File)

FileMaker Pro version 4 (FMP4) has the ability to export a text file that can be inserted into Excel 2013 or 2016. Note: Other higher versions of FMP can do this as well. These steps focus on FMP4 specifically.

Note: You should have saved the FileMaker Pro file to a known location on your computer. You will need to locate it with Excel.

  1. Open the FileMaker file. Find the records you wish to export to Excel.
  2. From the File menu choose Import/Export then Export Records.
  3. From the Save as type box choose Merge (*.MER).
  4. In the File name box, enter a name for the exported file. Be sure to add the .TXT extension rather than .MER.
  5. You can choose to save the file to the desktop or to the same folder as the FileMaker file.
  6. Click Save.
  7. From the left side, double click on the field names you wish to export. Their names will appear on the right side.
    Note: Once the names are on the right side, you can re-order them by clicking and holding on the double sided arrows beside their name. Move up or down as needed. This becomes the export order.
  8. Click Export. This wil create the text file to be imported with Excel.
  9. Open a blank or existing Excel 2013 or 2016 spreadsheet.
  10. Click the Data tab on the Ribbon and choose From Text.
  11. Choose the text file you want to import and double click.
  12. This will open the Text Import Wizard. Your data type will be Delimited. Click Next.
  13. For the Delimiter, un-check the Tab box. Then check the Comma box.
  14. The Text qualifier should be a double quote.
  15. Click Finish.
  16. A final window will be displayed asking where you wish to put the data into the sheet. Chose A1.
  17. Click OK.

Your data will now be in Excel.