Chose A1.Here's a little speed run I did when I got locked out of the command line on my previous Linux based FileMaker Server. The Text qualifier should be a double quote.Ī final window will be displayed asking where you wish to put the data into the sheet. Click Next.įor the Delimiter, un-check the Tab box.

Open a blank or existing Excel 2013 or 2016 spreadsheet.Ĭlick the Data tab on the Ribbon and choose From Text.Ĭhoose the text file you want to import and double click. This wil create the text file to be imported with Excel. This becomes the export order.Ĭlick Export. 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. Their names will appear on the right side.

You can choose to save the file to the desktop or to the same folder as the FileMaker file.įrom the left side, double click on the field names you wish to export. In the File name box, enter a name for the exported file. Find the records you wish to export to Excel.įrom the File menu choose Import/Export then Export Records.įrom the Save as type box choose Merge (*.MER). Note: You should have saved the FileMaker Pro file to a known location on your computer. Note: Other higher versions of FMP can do this as well. Having not done it myself, i would try this method:Ĭonvert FileMaker Pro 4 Data to Excel (Export as Merge Text File)įileMaker Pro version 4 (FMP4) has the ability to export a text file that can be inserted into Excel 2013 or 2016. I always assume there is an easier way to do it.

Python and filemaker