Darty-Ai Tables: From Spreadsheet to Styled Design

Create the table from your data. Make it part of your design.

Choose your source, select the content and let Darty-Ai Tables build the table inside Adobe Illustrator. Rows are created from the data, reusable rules handle the styling, and sizing and text-fitting controls adapt the result to your layout. Create a single table or use one setup across a whole product range.

Here, we take a Victoria plums nutrition table from an Excel workbook and turn it into a coordinated design with a header, alternating row colors and an icon for each nutrient. The content remains editable through the Tables panel as the design develops. We also look at the Sheet Builder packaging project to show how source selection, automatic rows and table sizing work across different products.

The finished table combines imported data, styled text and anchored Illustrator artwork.

Start with a shape and your data

Draw a shape where the table should appear, then give it a Darty-Ai tag. The tag identifies the target in the Tables panel and connects the table setup to the artwork.

  1. Open the Darty-Ai Tables panel and use the tagged shape as the target.
  2. In Source, choose File and select the Excel workbook.
  3. Choose the worksheet by its name or number. Set a cell range if you only need part of the sheet.
  4. Load the data and check the resulting rows and columns on the artboard.

You can also create a table directly and enter its content in the panel. In this example, the workbook supplies the nutrient names, quantities and notes.

Choose the worksheet and range, then decide which source formatting to retain.

One source, a table ready to style

Creating a table can be as simple as choosing a source, selecting the data you want and applying it to a tagged shape. Darty-Ai builds the cells from that data. You can then concentrate on typography, spacing and the design around it.

Choose the source that suits the way you work
Your contentHow to use it
Excel or another local fileChoose the file, then a worksheet and range where needed. Supported sources include XLSX, ODS, CSV and TSV.
Google SheetsUse an accessible sheet URL and select the worksheet and range for the table.
Copied or typed textPaste delimited text or a Markdown table into the Source editor. Choose the delimiter if the structure needs clarification.
A table built directly in IllustratorStart with a blank table, enter the content, and add or remove rows and columns as the design develops.

A practical example: fifteen products from one setup

The Sheet Builder project keeps its growing instructions in a simple workbook. Herbs, Flowers and Vegetables each have five product columns. Each column starts with a product name, followed by one instruction per cell.

Keep the source simple: one product per column, with one instruction in each cell.

In Builder, choose the source workbook once in the Table method’s header. Click the Sheet Name and Range labels to include those fields for each record. Each product then needs only its worksheet and cell range to pick the right instructions. The shared table styling and artwork setup can be reused across the range.

Set the workbook once; vary the worksheet and range for each product.

For example, Herbs → C1:C5 supplies the Garden Chives title and four instructions. Herbs → E1:E8 supplies the Common Thyme title and seven instructions. Start at row 2 instead if you want only the instructions, without the product-name row.

The data creates the rows

You do not need to draw a separate cell for every new line. When you create a table from a source range and leave the row and column counts to the data, Darty-Ai creates the required structure automatically. A product with more instructions gets more rows; a shorter product can use fewer.

These two tables come from the finished Sheet Builder artwork. Both use the same width, typography and row treatment. The extra instructions make the Common Thyme table taller. The crops are turned upright here so you can compare them easily.

Garden Chives: four instructions plus the title, from Herbs!C1:C5.
Common Thyme: seven instructions plus the title, from Herbs!E1:E8.

Leave room in the source with Auto Trim

You can use an exact range such as C1:C5, or allow room for growth with C1:C20 and enable Auto Trim. Empty rows at the end are removed, so they do not become blank bands in the finished table. Empty outer columns can be trimmed too; intentional gaps inside the data remain.

When another instruction is added within that range, reload the source or run the Builder record again and it can become another table row. If the data extends beyond the selected range, extend the range as well. Leave explicit row and column counts unset when the source should determine the structure.

Let the table size follow the job

Keep the rows consistent and let the table grow when the design has room. A longer specification list or set of instructions can make a taller table, as in the comparison above. This preserves a consistent treatment for each row.

Fit different content into a fixed area when the table must stay inside a label or packaging panel. The target shape can supply its size and rotation; overall width and height can also be set explicitly. Row heights and column widths determine how that area is divided, while text fitting helps handle longer entries.

The Layout controls also provide automatic row and column fitting, with minimum and maximum sizes. Use these when cell dimensions should respond to their content. Row/column fitting changes the available space; Shrink To Frame changes the text to fit that space. Choose the combination that suits the design and check its shortest and longest records.

You can refine a managed table directly in Illustrator by adjusting its outer dimensions or row and column dividers. The table reflows its cells and reruns its stored text-fitting rules. Automatic rotation is useful for a side panel: prepare the placeholder upright, rotate it into position, then let the new table follow it.

Decide how the content should look

Preserve Source Formatting brings supported spreadsheet formatting into Illustrator. Use it when the workbook already has useful text styling, fills, alignment or merged cells. The panel describes which formatting is supported, so check the result after import.

Parse Markdown interprets markup in the cell content, including markers for bold and italic text. This is useful when the source contains formatting instructions as text. Review the imported content before applying the final table style.

The demo also removes an unwanted line from the title cell. Edit the content in the panel and commit the change to update the Illustrator table. Cleaning up the source at this stage makes the later layout adjustments easier to judge.

Choose a style and define the header

Open Styles and choose a built-in table style as a starting point. Define the header row so it can receive its own treatment, then try a banded style to make neighboring rows easier to follow.

The style controls let you choose which parts to apply: Fill & Borders, Text, Artwork, Layout and Cell Structure. This lets you apply the parts you need while retaining other settings you have already adjusted. You can also save your own styles for future tables.

Sage Banded supplies a coordinated starting point; the category checkboxes control what the style changes.

Use rules that follow the table as it changes

A rule for Header, Footer or odd/even rows follows that part of the table as its size changes. Alternating fills can continue across new rows automatically. Use an explicit cell or range when a treatment belongs to a particular location.

In the Sheet Builder example, the table style supplies fills and borders while the template keeps its text settings and anchored sun artwork. Choosing the style categories deliberately lets you reuse a look without replacing every part of the setup.

Fit longer text to its cells

The notes column contains a mix of short phrases and longer descriptions. Select that column or its cell range, open Text, and choose Shrink To Frame under Fitting Method to bring overflowing text inside the cells.

You can target the whole table, a row, a column or an individual cell. In the demo, the notes receive a fitting rule, then the text size is adjusted across the data range. Check the longest entries as you work, and use the minimum and maximum font-size controls when you need limits on the fitting.

Apply fitting to the selected range, then check the text at the size it will appear in the design.

Anchor an icon beside each label

Small illustrations can make a table easier to scan. Our example uses a lightning bolt for energy, cubes for sugars and a different symbol for each remaining nutrient.

First, increase the first column’s left padding to leave room beside the text. Padding gives the artwork space without forcing it over the nutrient names.

Reserve space in the first column before adding the icons.
  1. Select the cell that should contain the icon.
  2. Open Artwork and add an anchored artwork rule.
  3. Choose Tagged object and enter the source artwork’s tag. The energy icon uses nutrition-icon-energy.
  4. Set the anchor and offsets to position the icon beside the label, adjusting its size as needed.
  5. Repeat for the other nutrient cells, then review the spacing across the whole column.
The rule connects a tagged Illustrator object to a particular table cell.

The video condenses the repeated icon setup. Each icon still has its own cell assignment, so the finished table keeps the relationship between its text and artwork.

Bring the table into your color palette

Once the icons are in place, refine the padding and text fitting together. Then select the whole table and adjust its colors to suit the design.

The assembled table before the final change to the plum palette.

The demo changes the green style to a plum palette, coordinating the header with the alternating rows. The result shown at the start of this article uses the same content and icons with a different color treatment.

Refresh the content and reuse the setup

For a file or Google Sheets source, Reload Source reads the saved connection again. This is useful when prices, specifications or instructions change. A normal formatting edit does not reimport the data. Review Preserve Source Formatting and Reset Existing Formatting so a reload keeps the balance you want between source appearance and Illustrator styling.

In Builder, applying the method editor saves its settings to the sheet; previewing or running the record applies them to the artwork. Keep shared settings in the method header and put only the differences in the product records. Preview both a short and a long table, particularly when updating an existing managed table.

Use Edit range to work through the data by row or by column. Editing a column is useful when you want to review all the nutrient labels together; editing a row keeps one nutrient’s name, quantities and note together.

The column editor brings related values into one place for editing.

The panel also offers different input formats, including CSV and Markdown tables. Choose a format that matches the data you are supplying, and check the resulting table after a change. Markdown as an input format describes the table’s structure; Parse Markdown controls markup within the cell text.

Choose the input format to match your source data.

For variable-data work, a Table method can become part of a spreadsheet-driven Darty-Ai job. Shared source and styling settings can be reused while each record supplies the content that changes.

The Sheet Builder guide shows this next step: one packaging template becomes a range of products, each with its own growing-instructions table. Start with one table, get its content and appearance right, then reuse that setup wherever the design calls for it.

Beyond nutrition and packaging

The same approach works for price lists, product comparisons, schedules, menus and specification sheets. Choose the source that is easiest to maintain, then let the table carry your design’s typography, colors and spacing.

A product comparison table from our existing Illustrator sample: the same table tools apply to specifications and catalogs.

For more involved layouts, insert or delete rows and columns, merge or split cells, and distribute their spacing through the table controls. A heading can span several columns, while selected rows, columns or cells receive their own borders, fills and text settings.

The result is editable Illustrator artwork: text frames, backgrounds and divider paths. Darty-Ai keeps the table’s structure, source connection and rules available for further managed edits. Save a table style to reuse its appearance; use Save Table for an Excel methods-sheet snapshot that recreates the displayed table.

Export as HTML also provides a table fragment to copy into a website or a standalone HTML page to save. It carries the cell content and supported formatting as a snapshot; attached artwork and Illustrator effects are not included. This gives the same underlying information another useful destination.

Scroll to Top