Formula Errors

How to Fix Excel Concatenation Formula for InDesign vCard QR Codes

Maira Mehtab Oct 10, 2026 869 views

Question details

The user is attempting to generate vCard QR codes for name badges using InDesign data merge but receives a data-not-available error due to an issue with the Excel concatenation formula.

Fix Excel Concatenation Formula Errors for InDesign vCard QR Codes

Product: Excel / Adobe InDesign
Device & OS: not provided
Scenario: Using an Excel spreadsheet to concatenate contact fields into a vCard string, which is then fed into Adobe InDesign's Data Merge feature to generate QR codes automatically.
Observed behavior: The formula output is rejected by InDesign, resulting in a 'data-not-available' error instead of successfully generating the expected vCard QR codes.

Before you start

Before modifying your formula, create a perfectly working plain-text vCard string in Notepad and test it manually in InDesign to establish a functional baseline for comparison.

Solution 1Recommended

Format and Validate the vCard Concatenation String

Ensure the Excel formula produces a strictly formatted vCard string containing all necessary tags, proper line breaks, and the mandatory closing statement.

InDesign's QR code generator is extremely strict regarding vCard syntax. Missing line breaks, incorrect headers, or omitting the closing END:VCARD tag will immediately cause a 'data-not-available' error.

Construct the exact vCard syntax

Structure your formula to include all required vCard elements. It must begin with 'BEGIN:VCARD' and 'VERSION:3.0', include standard property tags like 'N:' or 'FN:', and strictly end with 'END:VCARD'.

Insert line breaks using CHAR(10)

In your Excel formula bar, use the CHAR(10) function joined by ampersands (&) to insert the mandatory line breaks between vCard properties. For example: ="BEGIN:VCARD" & CHAR(10) & "VERSION:3.0" & CHAR(10) & "N:;;" & A2.

Compare output against a working text string

Right-click the cell with your formula, select 'Copy', then right-click an empty cell and choose 'Paste as Values'. Compare this static output character-by-character with a known working plain-text vCard to identify missing separators or line breaks.

Format and Validate the vCard Concatenation String

Enable Wrap Text: After using CHAR(10) in your formula, ensure you click 'Wrap Text' on the Home tab so you can visually verify that the line breaks are being applied correctly within the cell.

Advanced Spreadsheet Tool

Prepare Data Merge Sources Flawlessly with WPS Spreadsheet

Use WPS Spreadsheet to accurately concatenate text and prepare CSV files for InDesign data merges. With full support for advanced text formulas, CHAR(10) line breaks, and strict CSV encoding, you can generate error-free vCard strings for your QR codes.

1. Import Your Contact Data: Open WPS Spreadsheet and import your raw contact list or database into a new workbook.
2. Build the vCard Formula: Use the formula bar to string together your columns with the & operator and CHAR(10) to format the exact vCard syntax.
3. Export as CSV: Click on Menu > Save As, and choose 'CSV (Comma Delimited)' to create a clean data source ready for InDesign.

Fully compatible with Microsoft Excel formulas like CONCATENATE and TEXTJOINHandles complex text formatting and CHAR(10) line breaks seamlesslyExport clean CSV or TXT files perfectly formatted for Adobe InDesign data mergeFree, lightweight, and fast alternative for managing large contact databases

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel vCard formula show as a single line in InDesign?

If you used CHAR(10) for line breaks, the issue usually stems from how the CSV file was saved or encoded. Try saving the file as a UTF-8 CSV or TXT file to preserve carriage returns perfectly during the InDesign data merge import.

What is the absolute minimum information required for a valid vCard QR code?

A valid vCard must start with BEGIN:VCARD, followed by the VERSION (typically VERSION:3.0), the N (Name) or FN (Formatted Name) property, and must strictly conclude with the END:VCARD line. If any of these are missing, QR code generators will fail to parse it.

Why do I get a 'data-not-available' error specifically in InDesign?

InDesign throws the 'data-not-available' error when its internal QR code generator receives an invalid text string that it cannot parse into the expected format. It means the data source contains syntax errors, extra spaces, or missing line breaks that break the vCard standard.

Excel & Data Problems