Need to export data off PST to Excel ?

kidloco · 6 Feb 2007 at 15:19

Hi,

I need a program that will let me export all the data off a clients PST file, including all custom fields etc and export them into a Excel or just a CSV.

Anyone know of such a util

cheers

Fr0dders · 6 Feb 2007 at 15:50

.pst is an outlook file for containing e-mails ??

what are you wanting to do, put the contents of the e-mails into a spreadsheet ?

Mr.Clark · 6 Feb 2007 at 15:58

Actually, you can back up your Oulook Contacts to a .pst file, should you so desire.

Can you not import the PST file to a separate contacts list, then export it as a CSV or XLS file?

kidloco · 6 Feb 2007 at 17:06

The PST is a file created by a client, he exorted his Outlook contacts which include quite a few custom fields.

I need to export all this info contained in the PST file into excel so that I can cleanse the data ready for it being imported into a system I am building for them

Mr.Clark · 6 Feb 2007 at 17:14

Ok, here's what to do:

Open up your copy of Outlook (if you don't have one, we could have a problem here)

Create a new folder, of type: Contacts. Call it ClientContacts or something.

Click into it.

Click File, Import and Export, Import from another program or file, Personal folder File (.pst).

Locate the PST file.

Select the Contacts list in the menu and check the "Import items into current folder" button.

Then click Finish..

Then Export the ClientContacts folder as an excel spreadsheet or CSV file.

Et voila!

kidloco · 6 Feb 2007 at 18:07

Thanks for the little guide mate, that works great but it doesnt seem to export the custom fields

stoobar · 6 Feb 2007 at 19:20

im sure you can just export your contacts to excel, then sort then in the spreadsheet and then import the spreadsheet back into outlook

kidloco · 7 Feb 2007 at 09:30

you can do that your right, but if you have added any custom fields on the contact then it doesent bring them across this way, oh well, guess ill have to keep looking for some software