In QuarkXPress 6.1 and above, you can import a spreadsheet from Microsoft Excel as a table, optionally maintaining the formatting from the spreadsheet.
The table keeps a dynamic link to the original Excel spreadsheet, so when the spreadsheet changes, you can instantly update the data in the QuarkXPress table. To update the table, or to see if the Excel spreadsheet has changed, choose Utilities> Usage and click the Tables tab.
Warning: if you have applied any formatting to your table in QuarkXPress, it will be lost when you update it with new Excel data, so you’ll probably want to use the spreadsheet as-is.
Tip: when first importing an Excel spreadsheet, leave the Include Formats and Include Geometry options unchecked. Some spreadsheets are enormous, so it’s best to see how big it is first.
Jay Nelson is the editorial director of PlanetQuark.com, and the editor and publisher of Design Tools Monthly. He’s also the author of the QuarkXPress 8 and QuarkXPress 7 training titles at Lynda.com, as well as the training videos Quark includes in the box with QuarkXPress 7 . In addition, Jay writes regularly for Macworld and Photoshop User magazines and speaks at industry events.