{"id":"5910b7ff2c7d3a057f88e6ee","number":341,"collectionId":"590c96772c7d3a057f88d6ef","slug":"uploading-a-file-of-contacts","status":"published","hasDraft":false,"name":"Upload a File to Contacts","text":"<h2 id=\"What-file-formats-can-I-upload-to-Text-Em-All-contacts-LTSQe\">What file formats can I upload to Text-Em-All contacts?</h2>\n<p>Text-Em-All accepts contact files in .csv, .xlsx, or .xls formats with up to 1000 columns. Each contact can include first name, last name, up to 3 phone numbers, and notes. The platform automatically detects and maps your column information during the upload process.</p>\n<p>All uploaded files must contain at least one valid 10-digit phone number per contact to import successfully.</p>\n<h3 id=\"File-upload-requirements-bN-hA\">File upload requirements</h3>\n<p>Before uploading, ensure your file meets these requirements:</p>\n<ul>\n <li>File format must be .csv, .xlsx, or .xls</li>\n <li>Contains fewer than 1000 columns</li>\n <li>Includes at least one 10-digit phone number per contact</li>\n <li>Phone numbers can be formatted as XXX-XXX-XXXX, XXX.XXX.XXXX, XXXXXXXXXX, or (XXX) XXX-XXXX</li>\n <li>File must not be open in another program during upload</li>\n</ul>\n<h2 id=\"How-do-I-upload-a-contact-file-hm2yZ\">How do I upload a contact file?</h2>\n<p>The upload process automatically detects your column information and provides a preview before importing. You can modify column assignments if the automatic detection needs adjustment.</p>\n<ol>\n <li>Navigate to your <a href=\"https://app.text-em-all.com/contacts/group/everyone\">Contacts page</a></li>\n <li>Click the <strong>Upload a File</strong> button</li>\n <li>Drag and drop your file into the dialog or click <strong>Choose a File</strong> to browse</li>\n <li>Review the preview of detected information. If anything looks incorrect, click <strong>Modify</strong> to adjust column assignments</li>\n <li>Click <strong>Import</strong> to add the contacts to your account</li>\n</ol>\n<figure style=\"max-width: 100%; \" class=\"\">\n <img src=\"//d33v4339jhl8k0.cloudfront.net/docs/assets/58581d9fc697912ffd6c2c81/images/644bf445f3d5b34208a7f450/file-QB6OHEFD1B.png\" alt=\"Upload a File button location on the Contacts page interface\">\n <figcaption>The Upload a File button is located at the top of your Contacts page</figcaption>\n</figure>\n<h2 id=\"How-do-I-upload-contacts-to-multiple-groups-at-once-sW0oZ\">How do I upload contacts to multiple groups at once?</h2>\n<p>You can assign contacts to multiple groups during upload by including a \"Groups\" column in your file. This feature requires specific setup and must be done from the Everyone folder.</p>\n<h3 id=\"Before-you-begin-Rm5mT\">Before you begin</h3>\n<ul>\n <li><strong>Create your groups first</strong> — All groups must already exist in your account before uploading</li>\n <li><strong>Use exact group names</strong> — Group names in your file must match your account exactly</li>\n <li><strong>Format the Groups column correctly</strong> — Separate multiple groups with commas (ex: Day Shift, Night Shift, Management)</li>\n <li><strong>Upload from Everyone folder</strong> — Multi-group uploads only work from the main Everyone contacts view</li>\n <li><strong>Name your column \"Groups\"</strong> — The system won't auto-detect this column, so it must be labeled \"Groups\"</li>\n</ul>\n<h3 id=\"Upload-steps-for-multiple-groups-9Nr_n\">Upload steps for multiple groups</h3>\n<ol>\n <li>Navigate to your <a href=\"https://app.text-em-all.com/contacts/group/everyone\">Contacts page</a> and confirm you're in the Everyone folder</li>\n <li>Click the <strong>Upload a File</strong> button</li>\n <li>Upload your file with the properly formatted Groups column</li>\n <li>If groups don't exist, those contacts will be marked as <strong>Bad Records</strong>. Click <strong>View</strong> then <strong>Bad Records</strong> to see excluded contacts</li>\n <li>Click <strong>Import</strong> to complete the upload</li>\n</ol>\n<figure style=\"max-width: 100%; \" class=\"\">\n <img src=\"//d33v4339jhl8k0.cloudfront.net/docs/assets/58581d9fc697912ffd6c2c81/images/644bfae4f3d5b34208a7f454/file-srQzuzsObS.png\" alt=\"Upload preview screen showing View option to check Bad Records and upload details\">\n <figcaption>Click View to see upload details including any Bad Records that were excluded</figcaption>\n</figure>\n<h2 id=\"What-should-my-contact-file-look-like-LAeO3\">What should my contact file look like?</h2>\n<p>Use these sample formats as templates for your contact files. The platform accepts various column arrangements and will automatically detect most standard contact information.</p>\n<h3 id=\"Basic-contact-upload-format-1yuM7\">Basic contact upload format</h3>\n<figure style=\"width: 74.73%; \" class=\"\">\n <img src=\"//d33v4339jhl8k0.cloudfront.net/docs/assets/58581d9fc697912ffd6c2c81/images/62599cd25d0b9565e1734389/file-fiJcR673YG.png\" alt=\"Sample spreadsheet showing columns for First Name, Last Name, Phone 1, Phone 2, Phone 3, and Notes\">\n <figcaption>Basic contact file with standard columns for names, phone numbers, and notes</figcaption>\n</figure>\n<div style=\"background-color:#e3f2fd;border:1px solid #1976d2;border-radius:4px;padding:12px;margin:16px 0;\">\n <p><strong>Note:</strong> Valid 10-digit phone numbers can be formatted as XXX-XXX-XXXX, XXX.XXX.XXXX, XXXXXXXXXX, or (XXX) XXX-XXXX</p>\n</div>\n<h3 id=\"Multi-group-upload-format-JEv0q\">Multi-group upload format</h3>\n<figure style=\"width: 74.73%; \" class=\"\">\n <img src=\"//d33v4339jhl8k0.cloudfront.net/docs/assets/58581d9fc697912ffd6c2c81/images/644bfc5b40ac037159fb1c3a/file-TpCwwJQYDF.png\" alt=\"Sample spreadsheet with Groups column showing comma-separated group names for each contact\">\n <figcaption>Multi-group upload file showing the Groups column with comma-separated group assignments</figcaption>\n</figure>\n<h2 id=\"How-do-I-fix-file-upload-problems-EuQKT\">How do I fix file upload problems?</h2>\n<p>Most upload issues stem from file format problems, missing phone numbers, or column detection errors. Follow these troubleshooting steps to resolve common problems.</p>\n<h3 id=\"Troubleshooting-steps-C7KF9\">Troubleshooting steps</h3>\n<ol>\n <li><strong>Verify phone numbers</strong> — Ensure at least one valid 10-digit phone number exists per contact</li>\n <li><strong>Close the file</strong> — Make sure your file isn't open in Excel or other programs</li>\n <li><strong>Check column mapping</strong> — Click <strong>Modify</strong> during upload to adjust how columns are detected</li>\n <li><strong>Review bad records</strong> — Click <strong>View</strong> then <strong>Bad Records</strong> to see which contacts were excluded and why</li>\n <li><strong>Check for duplicates — </strong>Click<strong> View </strong>then <strong>Duplicate Records</strong> to see numbers that appeared more than once within the file you uploaded. This is separate from contacts already saved in your account.</li>\n</ol>\n<h3 id=\"Column-limitations-E1I5F\">Column limitations</h3>\n<p>The system only imports these specific column types:</p>\n<ul>\n <li>First Name</li>\n <li>Last Name</li>\n <li>Phone 1, Phone 2, Phone 3</li>\n <li>Notes</li>\n <li>Groups</li>\n</ul>\n<p>Additional columns will be ignored during standard contact uploads. However, when uploading during broadcast creation, extra columns can be used for <a href=\"//support.text-em-all.com/article/501-creating-personalized-text-messages-with-custom-fields\">message personalization</a>.</p>\n<h2 id=\"What-happens-after-I-upload-my-file-8X5i5\">What happens after I upload my file?</h2>\n<p>After clicking Import, your contacts are added to your account and available immediately for messaging. The system provides a summary of successful imports, bad records, and duplicates found during the process.</p>\n<p>Successfully imported contacts will appear in your selected group (or Everyone folder for multi-group uploads). You can then create broadcasts, send individual messages, or organize them into additional groups as needed.</p>\n<p>If more than one person on your account uploads contacts, you may see the same phone number listed more than once. An upload only checks against the contacts you've added yourself, so a number someone else already uploaded gets added again. This happens even when you're both uploading to the same group. To clean this up, sort your contact list by phone number so matching entries group together, then delete the ones you don't need.</p>","categories":["590c97c72c7d3a057f88d7bc"],"related":["59146a4c0428634b4a3309f3","5912204e0428634b4a32fcce","590c96960428634b4a32e3e1","590c96900428634b4a32e3d9","59122b4b2c7d3a057f88f0a2","598dcb19042863033a1be899","5ee911052c7d3a10cba9028f","5910b1510428634b4a32f327"],"keywords":["upload contacts file","import contacts csv","bulk upload contacts","contact file format","upload multiple groups","csv file upload","contact import troubleshooting","file upload requirements","contact management","bulk contact import"],"publicUrl":"https://support.text-em-all.com/article/341-uploading-a-file-of-contacts","popularity":0.6,"viewCount":22256,"createdBy":87166,"updatedBy":573954,"createdAt":1494267903000,"updatedAt":"August 6, 2026","lastPublishedAt":1786046482000,"previewText":"What file formats can I upload to Text-Em-All contacts? Text-Em-All accepts contact files in .csv, .xlsx, or .xls formats with up to 1000 columns. Each contact ","updatedDate":"2026-08-06"}