{"id":"5910b7ff2c7d3a057f88e6ee","number":341,"collectionId":"590c96772c7d3a057f88d6ef","slug":"uploading-a-file-of-contacts","status":"published","hasDraft":false,"name":"Upload a File to Contacts","text":"<script type=\"application/ld+json\">\n{\n  \"@context\": \"https://schema.org\",\n  \"@type\": \"HowTo\",\n  \"name\": \"Upload a File to Contacts in Text-Em-All\",\n  \"description\": \"Complete guide to uploading contact files (.csv, .xlsx, .xls) to Text-Em-All, including multi-group uploads and troubleshooting.\",\n  \"step\": [\n    {\n      \"@type\": \"HowToStep\",\n      \"name\": \"Navigate to Contacts page\",\n      \"text\": \"Go to your Contacts page and click the Upload a File button\"\n    },\n    {\n      \"@type\": \"HowToStep\", \n      \"name\": \"Select your file\",\n      \"text\": \"Drag and drop your file or click Choose a File to browse for your .csv, .xlsx, or .xls file\"\n    },\n    {\n      \"@type\": \"HowToStep\",\n      \"name\": \"Review column mapping\",\n      \"text\": \"Check the preview of detected information and click Modify if any columns need adjustment\"\n    },\n    {\n      \"@type\": \"HowToStep\",\n      \"name\": \"Import contacts\",\n      \"text\": \"Click Import to add the contacts to your account\"\n    }\n  ],\n  \"tool\": [\n    {\n      \"@type\": \"SoftwareApplication\",\n      \"name\": \"Text-Em-All\",\n      \"applicationCategory\": \"Communication Software\"\n    }\n  ]\n}\n</script>\n<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 repeated contacts</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>","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":21072,"createdBy":87166,"updatedBy":588674,"createdAt":1494267903000,"updatedAt":"April 1, 2026","lastPublishedAt":1775057676000,"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-04-01"}