convert filemaker file into an excel spreadsheet?

[indlvin]

hello guys,

I'm quite new to filemaker and i've been solving many of the problems i've faced by googling the stuff. but this i could never get any clue how to do it.

So i'd appreciate if anybody tells me how i can convert a filemaker file into an excel spread sheet?

regards,

indlvin

[Steve T.]

Howdy, indlvin, and welcome to FMFORUMS! I think you'll find better help here than you can get from generic internet searches. Now, as to your Q, I think it's easier than you think if I understand correctly. I think all you have to do is EXPORT your data as a MERGE file and then open that file in Excel. If Excel does not launch its import wizard, you may have to change the extension to .txt first and then launch Excel and open the file from Excel's FILE > OPEN menus.

FileMaker's table view simulates this, though, so if you just want to see the data as a table, I think you can do so from within FileMaker's VIEW menu.

Hope this helps!

--ST

[MoonShadow]

Although a funky work-around, I also have a few Users who want to pull FM data into existing Excel spreadsheets in specific locations. An FM table and a found set can be copied via script or from menu (Copy All Records) -- yeah, hold on ...

User then just clicks into the cell where the data should start and pastes. They get their pretty flatline column file.

Okay. It messes their clipboard; but it's them doing it and not the Developer messing with their clipboard behind the scenes. Some of my Users love this ability. After all, the clipboard is theirs.

[***ANDY***]

You can also go to menue FILE, click EXPORT RECORDS, under save as type choose .csv (comma separated text files), enter a file name above and SAVE. Then open EXCEL, choose CSV files to open and voila, you got your data in an Excel spreadsheet.

[-Queue-]

You can also export as type .mer and name the file with a csv extension. It can then be opened directly and will contain the field names in the first row.