Import tab delimited data into a Pages table or spreadsheet

Question

Level 1

12 points

Import tab delimited data into a Pages table or spreadsheet

How can I import data into a Pages table or spread sheet. I have my data in Filemaker Pro 7 and I can export it as Tab delimited. It would be nice to get it into pages so I can plot it there.

IMac Intel Mac OS X (10.4.5) iWork '06 with Pages 2

Posted on Mar 24, 2006 10:54 AM

Reply

Answer 1

Best reply

Magnus Lewan

Level 4

3,663 points

Mar 24, 2006 11:50 AM in response to Richard O

A little cumbersome, but try the following:

1) Export to tab-limited.

2) Open as text (even in TextEdit if you like to).

3) Copy the text.

4) Create a new table in Pages with the right number of rows and columns. Highlight all cells, so they are surrounded by the yellow rectangle.

5) Paste.

Reply