How to Import Email Accounts and Forwarders into cPanel

    In this article, we will explain how you can import a list of email addresses and email forwarders into a cPanel account.       This can be incredibly useful for beginners and advanced users migrating content from one cPanel to another.        Or, if you want to create a massive list of users in a spreadsheet instead of through cPanel directly.          You can then import your spreadsheet with the method described below.       For users managing multiple email accounts, keeping all email addresses and passwords in a spreadsheet may prove helpful.   </p> <h2>   Using a Simple .CSV File Instead of Excel Spreadsheet </h2> <p>     You can use an Excel Spreadsheet for your email content, but cPanel gives non-Excel users a simpler method for creating a sheet with any basic text editor.     Below are some examples you can follow.     Make sure to save these files with a <code>.csv</code> extension. </p> <p>For importing email addresses:</p> <code> Email,Password,Quota
[email protected],1234,10
[email protected],4567,8
[email protected],8910,10
</code> <p>For importing email forwarders:</p> <code> Source,Target
[email protected],[email protected]
[email protected],[email protected]
[email protected],[email protected]
</code> <h2>How to Import your CSV or Excel Spreadsheet into cPanel</h2> <p> Once you have your spreadsheet or CSV file ready to import, follow along with the steps below: </p> <ol class="article_list"> <li><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_18.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_18.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div><a href="/support/edu/cpanel/how-to-log-into-cpanel/">Log into cPanel.</a><div style="clear:both;"></div></li> <li><!-- christopherm_cpanel_EmailImport_Selection_01.png --><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_57.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_57.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>Under the <em>Email</em> section click <strong>Address Importer</strong>.<div style="clear:both;"></div></li> <li><!-- christopherm_cpanel_EmailImport_Selection_03.png --><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_58.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_58.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>If you need help creating your spreadsheet file, click the link in the blue alert box.<div style="clear:both;"></div></li> <li><!-- christopherm_cpanel_EmailImport_Selection_04.png --><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_59.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_59.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>Select the kind of spreadsheet you are importing, <strong>E-mail Accounts</strong> or <strong>Forwarders</strong>.<div style="clear:both;"></div></li> <li><!-- christopherm_cpanel_EmailImport_Selection_05.png --><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_60.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_60.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>Click <strong>Choose File</strong> to upload the spreadsheet file from your computer.<div style="clear:both;"></div></li> <li><!-- christopherm_cpanel_EmailImport_Selection_06.png --><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_61.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_61.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>Select your delimiter and header preference. (In this example, we used commas in a .csv file. Make sure to leave the box checked for "Treat first row as column headers" if the first row of your spreadsheets contains headers for your columns.)<div style="clear:both;"></div></li> <li><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_62.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_62.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>Click <strong>Next</strong><div style="clear:both;"></div></li> <li><!-- christopherm_cpanel_EmailImport_Selection_07.png --><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_63.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_63.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>Confirm the imported content and click <strong>Next</strong> again<div style="clear:both;"></div></li> <li><a href="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_64.png" rel="lightbox-0"><img class="std_ss" src="/support/images/stories/cpanel/lanternUpdatesMay17/cmPape_64.png" style="float:right;margin:0px 15px 15px 15px;width:200px;"/></a><div style="clear:both;"></div>Click Finish<div style="clear:both;"></div></li> </ol> <p>You will see a notice of successful import. From here, you can <strong>Import More</strong>, or go back to your cPanel home page.</p> <p>Well done on completing this tutorial. You can no import email addresses and forwarders in cPanel.
CM
Christopher Maiorana Content Writer II

Christopher Maiorana joined the InMotion community team in 2015 and regularly dispenses tips and tricks in the Support Center, Community Q&A, and the InMotion Hosting Blog.

More Articles by Christopher

Was this article helpful? Let us know!