![convert filemaker pro to excel convert filemaker pro to excel](https://img.wonderhowto.com/img/07/95/63475510613586/0/convert-currency-with-data-from-web-query-excel.1280x600.jpg)
So in this case, what you want to do is pick just the fields that you want to export, if you want to move all of the fields just hit move all and you'll notice that some container fields cannot be exported, so it's going to move all my fields except for my logo container.
#Convert filemaker pro to excel windows#
So to specify field order for export windows what you'll see no matter which format you choose. So in this case, we're going to want to choose some fields to export. You're going to see this no matter what format you choose. So I'm going to hit save and because I chose Excel, I have some other options that are specific to an Excel spreadsheet I don't have to put any of those in right now, I'll just advance on to the specify order for export window.
![convert filemaker pro to excel convert filemaker pro to excel](https://i0.wp.com/warecrack.com/wp-content/uploads/2019/07/FileMaker-Pro-Advanced-18-Crack.png)
So currently in the FileMaker 18 platform, I can export it as a Tab or Comma-Separated Value file, or I can create another file in the form of DBF, a Merge, I can create an HTML Table with my exported data, or I can create a new FileMaker Pro File that contains all the data that I'm exporting and that same is true for XML and in this case I'm going to choose an Excel Workbook that way we can preview it in Excel to see what our export looks like. So here I've got some other decisions to make what do I want to name my export? I'll just call it ExportTest and then where I want to save it, I'll just save it to the desktop, I'll check automatically open the file if it's not already checked and then I can choose from the different types. So now that I've determined what table I'm going to export from and the subset of data that I'm going to export, I'll go under the file menu and choose the export records option.
![convert filemaker pro to excel convert filemaker pro to excel](https://img.bhs4.com/38/3/38311B033C73D6D5431D1EF34AEFCF768D53DDDD_large.jpg)
If I wanted to export all 1523, I could just do show all but in this case, let's say we're just going to export the 24 of them. So in that case, I would go into find mode, I would put in whatever criteria would help me narrow down those records and I see that I get 24 records, so out of all the 1523 records only 24 of them are from the State of California. Let's say I don't want to export all of those records, I just want to export the records from California. That means that, that's how many records are stored in my customer table. The next decision I have to decide is do I want to export all of the records in my database or just some of them, and if I want to just do some of them what might that criteria be? Well, you see here that I've got 1523 records I can tell that because in the upper left-hand corner, you see it says 1523 total. You see here, that's our table called the customers. So I'm going to go to a layout that's based on the customer table. So in my example, I mentioned I want to export customer data for a mail campaign. First of all I have to go to a layout that's based on the table, that has the data that I want to export. So in that case, I would open up my FileMaker file and I'd have a couple decisions to make. Say for example, somebody wants to get all of my customer records out so they can import it into some mail campaign, that they're doing in another application. Specifically if you don't have one of those options I just mentioned available. But let's say sometimes you just want to dump some data out of your database and have it imported into another system. You can even have other FileMaker files connect to your FileMaker file persistently and share data between them. You can host it on FileMaker server and have another application connect to it through to ODBC connection. For example, you can host it a non FileMaker server, treated as a web service and people can connect to your data through the FileMaker data API.
![convert filemaker pro to excel convert filemaker pro to excel](https://rsload.net/images5/FileMakerProAdvanced2.png)
So FileMaker has a ton of really sophisticated ways that you can share data that's inside your custom app with other non FileMaker data applications.