How do I remove extra spaces and characters from my guest list import?

To prepare your guest list import, be sure to remove all extra spaces and characters from the email address column. Otherwise, your guests could be marked as invalid and not imported.

Spreadsheet applications often have multiple features that remove additional characters:

  • Text to Columns - splits data into multiple columns based on a character type
  • Trim Function - uses the function "=TRIM(A1)" to remove extra spaces before and after text 

Below, we we walk through how to use the Text to Columns option to remove those additional characters in multiple spreadsheet applications. 

How to: Google Sheets

How to: Microsoft Excel 


Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.