Get user profiles from SharePoint 2010 and put in Excel

is this a ps1 script?

this script errors out for me..

PS C:\Powershell> .\allusers2
New-Object : Exception calling ".ctor" with "1" argument(s): "Object reference
not set to an instance of an object."
At C:\Powershell\allusers2.ps1:7 char:29
+ $profileManager = New-Object <<<<  Microsoft.Office.Server.UserProfiles.UserP
rofileManager($serviceContext);
    + CategoryInfo          : InvalidOperation: (:) [New-Object], MethodInvoca
   tionException
    + FullyQualifiedErrorId : ConstructorInvokedThrowException,Microsoft.Power
   Shell.Commands.NewObjectCommand

You cannot call a method on a null-valued expression.
At C:\Powershell\allusers2.ps1:8 char:42
+ $profiles = $profileManager.GetEnumerator <<<< ()
    + CategoryInfo          : InvalidOperation: (GetEnumerator:String) [], Run
   timeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

Exporting profiles
Cannot index into a null array.
At C:\Powershell\allusers2.ps1:16 char:40
+    $profileData.AccountName = $profile[ <<<< "AccountName"].Value
    + CategoryInfo          : InvalidOperation: (AccountName:String) [], Runti
   meException
    + FullyQualifiedErrorId : NullArray

Cannot index into a null array.
At C:\Powershell\allusers2.ps1:17 char:38
+    $profileData.FirstName = $profile[ <<<< "FirstName"].Value
    + CategoryInfo          : InvalidOperation: (FirstName:String) [], Runtime
   Exception
    + FullyQualifiedErrorId : NullArray

Cannot index into a null array.
At C:\Powershell\allusers2.ps1:18 char:37
+    $profileData.LastName = $profile[ <<<< "LastName"].Value
    + CategoryInfo          : InvalidOperation: (LastName:String) [], RuntimeE
   xception
    + FullyQualifiedErrorId : NullArray

Cannot index into a null array.
At C:\Powershell\allusers2.ps1:19 char:42
+    $profileData.PreferredName = $profile[ <<<< "PreferredName"].Value
    + CategoryInfo          : InvalidOperation: (PreferredName:String) [], Run
   timeException
    + FullyQualifiedErrorId : NullArray

Cannot index into a null array.
At C:\Powershell\allusers2.ps1:20 char:38
+    $profileData.WorkPhone = $profile[ <<<< "WorkPhone"].Value
    + CategoryInfo          : InvalidOperation: (WorkPhone:String) [], Runtime
   Exception
    + FullyQualifiedErrorId : NullArray

PS C:\Powershell>

I also need to get the user's Title, please.

Thank you for your efforts.

Any suggestions, Layaraja?

yes this is a powershell script .
quick check on the script.....
1. did you run under admin account (farm admin)?
2.Did you change the site collection url ?
and for the ctor error refer here http://blogs.catapultsystems.com/rhutton/archive/2012/10/11/updating-a-user-profile-picture-using-powershell-exception-calling-quote-ctor-quote-with-quote-1-quote-argument.aspx

for title..change it to
  $profileData = "" | select "AccountName","FirstName", "LastName","PreferredName","WorkPhone","Title"
and add one more line
   $profileData.Title= $profile["Title"].Value