Importing from Excel - Horizontal vs Vertical

[Jeff M]

I'm receiving excel documents from a coworker that are vertical in format rather than horizontal. In other words, each column in excel is a record, with the first column (A) being the field names. FileMaker seems to insist on assuming that each row in a spreadsheet is a record. Can someone suggest a way of getting that data into FileMaker correctly without altering the excel document? It's a data template that's been in use forever, so I need to find a way to work with it as is.

[Kevin Frank]

The easiest solution would be to copy the cell range from the original spreadsheet, create a new spreadsheet, click on cell A1 in the new spreadsheet, and choose Edit > Paste Special > Transpose.

Now your data will be in the format FM expects it to be in, and you can import this new spreadsheet into Excel.

Hope this helps,

Kevin