You export your guest list to send the final headcount to your caterer. You open the file in Excel to double-check it before sending — and every phone number now reads 919876543210 or, worse, 9.19876543210E+11. The + is gone. So are the spaces. If you re-import that file later, or if anyone tries to call one of those numbers by copying it out of the spreadsheet, it's now wrong.
This isn't a bug in your spreadsheet. It's how Excel decides what counts as a number, and it's fixable — but the fix has to happen when the file is written, not after you've opened it.
Why this happens
Excel and Google Sheets both try to be helpful by auto-detecting what kind of data is in a cell. A cell containing only a + and digits — +919876543210 — looks like a number to both programs, specifically a number with a plus sign, which neither format preserves. Numbers don't get a leading +, and they don't get leading zeros either, which is the same reason a phone number starting with 0 gets shortened the moment you open it.
The moment the file opens, the damage is done. There's no setting you can toggle afterward to bring back a + that Excel has already stripped — you'd need to have formatted the column as Text before opening the file, which isn't something you can do to a file that's already been opened once with the wrong formatting.
The actual fix: a space after the country code
The reliable fix doesn't depend on you remembering to format a column before opening a file — it changes what gets written to the export in the first place. A phone number exported as +91 9876543210 — with a space between the country code and the number — is no longer a value Excel or Google Sheets can interpret as a number at all, because a space makes it text by definition in every spreadsheet program. It stays exactly as written, +, spaces, and all, however you open it.
This is a small detail, but it's the difference between a guest list you can hand to a caterer and get back unchanged, and one that quietly corrupts every time it passes through a spreadsheet.
What to check before you send anything to your caterer or venue
Open the export and check a few numbers before you send it anywhere. Even with a correct export format, it's worth a 30-second sanity check on a file that's about to go to a vendor who'll use it to plan quantities.
Don't manually "clean up" the file in Excel before sending. If a number looks odd and your instinct is to retype it directly in the spreadsheet, be careful — retyping without a leading space or without quoting the cell as text will reintroduce the exact problem you're trying to avoid.
If you need to re-import the file after editing it, check that the format survived your edits. Adding a column, sorting the rows, or fixing a typo in a name shouldn't touch the phone number formatting, but it's worth confirming before you commit an import based on an edited export.
Sending your guest list to your caterer?
The Curated Knot exports phone numbers in a format Excel can't turn into a number — so the file you send is the file they get.
Beyond phone numbers: what a caterer-ready export actually needs
A phone number that survives Excel is one piece of a bigger requirement — the export itself should give your caterer or venue exactly what they need without extra columns to strip out or explain:
- A confirmed count, not a guess. Export the RSVP-confirmed guests specifically, not your whole invited list — the two numbers can differ by a wide margin, and a caterer pricing off your full invite list rather than confirmed attendance is a common source of over-ordering.
- Names alongside numbers, not a bare headcount — a venue coordinator who needs to reach a specific guest about a dietary note or a seating question needs a name to search for, not just a total.
- One filter you actually asked for. If you're exporting per function (mehendi headcount separate from the reception), confirm the export reflects the filter you applied, not your entire guest list regardless of event.
Frequently Asked Questions
Why does my phone number lose the +91 when I open my exported guest list in Excel?
Excel reads a cell containing only a plus sign and digits as a number, not text, and numbers don't keep a leading plus sign or leading zeros. The fix has to happen in how the file is written, not how you open it — a cell written as "+91 9876543210" with a space stays text in every spreadsheet program, because Excel can't interpret text with a space as a number.
Can I fix this myself after exporting, instead of relying on the export to do it right?
Yes, but it's a manual step you'll need to repeat every time: select the phone number column, format it as Text before the file is opened for the first time (or reimport as text-formatted), then re-enter or re-paste the numbers as values rather than letting Excel auto-convert them. It's easier for the export to just do this correctly the first time.
If I fix the formatting and then re-import that same file, will it work?
It should, if the export and import use the same phone format. A number exported as "+91 9876543210" should be recognized as unchanged if you re-import that same file without editing it — check this specifically if you plan to export, tweak a few rows, and bring the file back in.
Does this affect Google Sheets too, or just Excel?
Google Sheets has the same underlying behavior — a cell with only a plus sign and digits gets treated as a number and loses the leading characters. The space-after-the-code fix works there as well.
What should I send my caterer — the full guest list or just a headcount?
A confirmed headcount is what they need for pricing and quantities, but keeping names and phone numbers on the export (rather than a bare number) lets you or the venue reach a guest directly if there's a dietary question or a last-minute change, without going back to your main guest list to look someone up.
Related read
How RSVP Count Affects Catering Costs at Indian Weddings
Accurate RSVPs save Rs 2-5 lakhs on catering. The per-event, per-plate math for Indian weddings.
Related read
How to Import Your Wedding Guest List From Excel
Bring an existing spreadsheet into your wedding website safely — preview first, nothing overwritten by accident.
The Curated Knot exports your guest list with phone numbers Excel can't mangle, confirmed counts, and the filter you actually applied. Try it free →