Skip to main content

📤 Guestlist Export Showing Empty or Missing Columns

If your exported Excel file shows an empty column (such as Event Attendance or any other tag), don’t worry this usually means there’s an issue with how some entries or tags are formatted inside your guestlist.

Nina Dobrev avatar
Written by Nina Dobrev
Updated over 2 months ago

Why this happens

This issue typically occurs when one or more guest entries contain tags or values that aren’t formatted the same way as the rest.
Even a single inconsistent, duplicated, or incorrectly added tag can disrupt the export and cause the entire column to appear blank in Excel.

🛠 Step-by-step: How to fix it

1️⃣ Open your guestlist in TTO


Go to your event in That’s The One and open the Guestlist section.

2️⃣ Review the column that is exporting empty


Look through the column (Attendance, Meal Choice, Tag, etc.).
You’re looking for entries that seem:

  • Duplicated

  • Incomplete

  • Mistyped

  • Using a different format or tag than others

3️⃣ Remove duplicate tags or repeated entries
If you see:

  • A guest with the same tag repeated

  • Multiple tag variations that should be identical

  • Duplicated guest rows

Delete or clean these duplicate/incorrect entries. This ensures the export reads the column consistently.

4️⃣ Correct or re-apply incorrect values


For any row with unusual or mismatched tags:

  • Edit the entry so it matches the other guests’ tag format, or

  • Remove the tag and re-apply it correctly

This helps standardize the data so Excel can read it properly.

5️⃣ Re-export the guestlist


After cleaning up:

  • Click Export again

  • Open the new file

  • Check the column

It should now populate correctly with all the intended values.

💬 Need help?
If you're unsure which entries are causing the issue, send us your guestlist link—we’re happy to look through it and help you fix the formatting.

Did this answer your question?