Export Account List to Spreadsheet

From Lunarpages Web Hosting Wiki

To import a list of your accounts into a program such Excel, first log into WHM, then click on Account Functions, then on List Accounts.

Reseller export accounts.jpg

Scroll to the right. Just above the Quick Domain Search box is a link Fetch CSV. Click the link and a page will come up with the data separated by commas.

Select all the text, then open a text editor (such as Notepad) and paste the data. In the text editor do a File > Save As, and type something such as accounts.csv. Note: the file extension must be .csv.

Now in your spread sheet program you can open the CSV file and you will see the following columns of information:

  • Domain
  • cPanel
  • IP
  • Username
  • Contact Email
  • Setup Date
  • Partition
  • Quota
  • Disk Used
  • Package
  • Theme
  • Owner