Importing spreadsheet or database text into a table

When you import data into a table, you need to begin by formatting data in a text-only file in a way that GoLive accepts. For a single-celled table, you should simply format the data as you'd like it to appear in the table. For a multiple-celled table, you should format the data so that each line represents the contents of a row and contains column separators (tabs, commas, spaces, or semicolons) to separate the data between columns. Most spreadsheet and database applications can export data to a text-only file in one of these column-separated formats.

Rather than setting up a column-separated file to import data, you can simply copy the data from cells in another application and paste it into a GoLive table. Rows and columns will be added to the GoLive table as needed. (See Pasting and dragging text to a table.)

To import data from a text-only file into a table:

1. Create a text-only file that contains data that you want to import into a table.
2. In GoLive, select a table or cell of the table you want to place the imported data into.

When GoLive imports the data into the table, the table creates additional rows and columns as necessary to accommodate the data.

3. Click Import in the Table tab of the Table Inspector or select Import Teletext from the context or Special > Table menu.
4. In the Open dialog box, select the text-only file, and then choose an option from the Col. Separator pop-up menu to specify the column separator used in the text-only file.