How to Connect Cardly to Excel (4 Methods Compared)

The Problem With Getting Workbook Data In and Out of Cardly

You have an Excel workbook full of recipient data — names, postal addresses, personalised messages, artwork IDs, campaign segments. You need it in Cardly so the send can go out, or you need Cardly's order and credit data back in the workbook so finance can close the books.

Cardly is good at turning rows of customer data into personalised physical cards at scale. But the path from Excel to Cardly is rarely clean. The default flow is to export the worksheet as a CSV, fix whatever the export broke in the header row, upload it through Cardly's import UI, and fix the field mismatches on the other side.

Below are the four common ways teams handle this. Only the last one scales.

Method 1: Manual Copy-Paste (or CSV Export)

For Excel users, this usually starts with File → Export → CSV rather than copy-paste directly, because Cardly's import UI expects a file. You save the CSV, open it to check the column order, realise the export dropped a column or wrapped a postcode in quotes, fix it, re-export, and upload.

For a one-time campaign of twenty recipients, the pain is manageable. For a recurring monthly send, the re-export-and-recheck cycle becomes its own standing task on someone's calendar — one that exists entirely because two tools can't talk to each other directly.

The real cost is attention. Every reformat is a decision: does this column go here or there, do I strip the country code, does this field allow ampersands.

Method 2: Power Automate

Power Automate has a Cardly connector. You can build a flow that triggers on an Excel table row update, calls Cardly, and creates a contact or places an order.

Quick check before you continue: are you comfortable working in Power Automate's flow designer? Do you know what a "dynamic content" token is, how to configure an HTTP action, how to map Excel column outputs to API body fields? If not, skip to Method 4 — it will get you moving faster.

If you're still here: the flow works. You authenticate the Excel connector, set your trigger, map each column to its Cardly counterpart, and test. When it fires cleanly, it's reliable.

But it fires one row at a time.

Sending 150 contacts through the flow means 150 trigger evaluations, 150 API calls, and a run history that becomes very difficult to read when row 67 fails because of a missing postcode and the rest of the rows keep going.

You probably just need the list uploaded and a preview generated. You probably have no idea how to build a Power Automate flow that batches rows, retries failed ones, and logs errors cleanly — and that's completely fair, that's not what you were hired to do. So it goes on the IT backlog, and you wait.

Meanwhile the send date doesn't move.

Method 3: The Previous Generation — Connector Add-Ons

Until recently, the best option for repeatable Excel ↔ Cardly workflows was a category of add-ins that let you save a field mapping template, point it at a named table, and run it. You configured it once, saved the config, and re-ran it each campaign.

That was genuinely better than exporting CSVs by hand. The output was predictable, the mapping was saved, and you didn't have to redo the column order every time.

But you were still on the hook for the template design, the conditional logic, which rows to include and which to skip, and what happens when someone renames a column. The add-in got the data through the pipe, but every decision about the data was still yours. The moment the workbook structure changed, the saved config needed a manual update.

This is the previous generation. It solved the formatting problem but not the thinking problem.

The Easy Way: Using SheetXAI in Excel

There is a different way entirely. SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you're looking at, and through its built-in Cardly integration it can push to or pull from Cardly for you. No import template, no Power Automate flow, no CSV reformatting. You just ask.

Example 1: Generate card previews for an entire recipient list

For each row in my "Mailing List" worksheet (columns A–E: Name, Address Line 1, City, Postcode, Country), generate a Cardly preview using the artwork ID in cell B1 and write the preview URL to column F.

Each URL lands in the correct row. You can review the full preview list in the workbook before placing the order.

Example 2: Export order history into the workbook for budget review

Export all Cardly orders from the last 90 days to this workbook — include order ID, recipient name, template used, cost, and delivery status in separate columns.

The pattern: instead of exporting from Cardly and cleaning the data in Excel, you ask for both the pull and the column layout in one prompt. SheetXAI handles the formatting inline.

Try It

Get the 7-day free trial of SheetXAI and open any Excel workbook with recipient data or Cardly campaign records, then ask it to do one of the tasks above. The Cardly integration is included in every SheetXAI plan.