Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Transfer of a phone data list from Outlook Express to Excel

Sep 25, 2011 2:54AM PDT

By "one click" I have succeeded in transferring the details of my contacts (about 200 people) from my simple LG GU280f mobile phone to Outlook Express in my PC (OS is Windows XP). Transfer was achieved by synchronizing phone and PC, utilizing LG-distributed software. Contact data include name, phone no. and optional additional data, e.g. more phone no.s, e-mail addresses etc. Outlook displays only the names, in a single column, alphabetically ordered.. I must click on each name to get the other details of the contact, they then appear in a popping-up window. Copying and pasting, even of the data set of a single contact is not accepted by Excel.
Has anyone an idea of how to transfer the entire list to Excel while converting it into a multiple-column table, to allow easy inspection, editing and varying office uses of the data? Thanks in advance.

Discussion is locked

- Collapse -
Answer
Did you try google?
Sep 25, 2011 3:25AM PDT
- Collapse -
Answer
CSV file
Sep 25, 2011 3:25AM PDT

See if OE will export the contacts to a CSV file, .csv

If so, then open Excel then File > Open, navigate to the file and select it.

If I remember correctly Excel will offer options to import the file in columns relating to the different fields.

Mark