2019

BOXES, LINES, AND TABLES
136 | A Guide to QuarkXPress 2019
Importing Excel tables
Table data often originates in a spreadsheet program such as Excel, and you can
import table data just as you import pictures. Although the technique is slightly
different, the results are the same: The table in QuarkXPress is linked to the Excel
file for tracking and updating.
You can import only .xlsx files in QuarkXPress. 
If you import a table from Excel using the Link to External Table option in the
Table Properties dialog box, table usage will be tracked just as picture usage is
tracked. This ensures that you’re notified if the source table changes, and that you
have the latest table data when you output the layout, whether you print, collect
for output, or save as a PDF. To check the status of a table, choose Utilities > Usage,
and then click the Tables tab.
You can also import a table from Excel using the Create Table from External
Source under the Table menu.
Although you can update tables just as you can update pictures, you’ll need to keep
the following points in mind:
If you check Include Formats in the Table Link dialog box when you first •
import an Excel table, the table’s Excel formatting is preserved (as much as
possible) in QuarkXPress. If you later update the table, any local formatting you
have applied in QuarkXPress is removed and replaced with the formatting from
the Excel file.
If you do not check Include Formats in the Table Link dialog box when you •
first import an Excel table, the table’s Excel formatting is discarded. If you later
update the table, QuarkXPress attempts to preserve any local formatting you
have applied to the table in QuarkXPress.
To import an Excel table and maintain the link in QuarkXPress:
Using the Tables tool, drag to draw a table of approximately the dimensions 1.
you need. The Table Properties dialog box displays when you release the mouse
button.
Check Link to External Data. 2.
Click OK to display the Table Link dialog box. 3.