Create a Filemaker database and spreadsheet conversion routine

I need to be able to convert music metadata spreadsheets into different layouts. There will be a master spreadsheet with about 100 columns containing music library metadata like song name, mood, composer etc. The program will need to be able to import data from a spreadsheet with that format into a database window I can view. It will then need to be able to export the data to several other basic spreadsheets. It will need to change the column header for some columns. It will also need to be able to combine certain sets of cells into a single cell with a pipe command inserted to delineate where the original cell separations were. It will also need to be able to recognize empty cells and bypass them. It will also need to up convert the condensed spreadsheets back into the master spreadsheet format. I will provide the individual master spreadsheets along with instructions about the conversions.