How can I copy the address book or contacts into Excel?

Ad
6

I have another question:

Whether Windows change, PC change, change from PC to laptop or other copies from PC to PC - the address book or contacts etc?

Everyone knows the problem. It would be so nice to create a simple table with Excel in TXT format separated by commas when changing or backing up the e-mail addresses in old systems and later to put these texts in Excel neatly on simple text fields and then from there to "import", but no program can until today. It is not even possible to copy from Outlook to Excel in Microsoft's Office - What are these software species?

Has anyone of you found a solution for this and perhaps even solved the number of system levels since the "DOS days" with it? With every system change I also bought the software except for this problem and each time I retyped the address book.

I think it would be great to find a solution here. Possibly. A great start for 2021.

de

If the respective software allows data export in csv format, it works.
Excel can open csv files directly. Unfortunately not all programs support csv or you can't format the output file beforehand. With some programs this means that everything is in one line when the csv is opened. Other programs separate the data into columns.

How to export Outlook contacts is described here:

https://support.microsoft.com/...3714eca73f

Br

Your statement is not correct. I can easily export the contacts to a csv file and import them again on the new computer.

Ad

Thank you first. I have seen and tried exporting in CSV often and in many programs. Yes, and appendices changed from csv to txt. But none of Excel can import; from .txt or table with individual fields per address line, regardless of their name.

Three nights of tip work for contacts in a new Outlook instead of a Thunderbird address book are an impertinence. This is so annoying…

Ad

Thanks first of all. I've had CSV for years; Microsoft also writes about this, but Excel formats are not possible. Since today I know from reading that .csv must never be changed, then input is also possible, but not with all manufacturers.

In tables with cells per field, I can sort and rearrange cleanly, but not divided up with commas for text-like whole sentences.

Ok, I have to try it first, copy two Excel tables side by side and from txt to csv and then import csv again (only with Outlook! This is how it was described.

I don't understand that Office programmers have not been able to find a solution to the connection between Outlook and Excel, and have not done so for years.

Br

You can easily import a CSV file into Excel and then save it as an Excel file. You have exactly the same information inside as if you had exported it directly to Excel. Therefore, I find the function simply superfluous, because there's practically no advantage with it, except that you save the one-time conversion. If necessary, you can do this with PowerShell, then it is even automated.

de

"I don't understand that Office programmers can't come up with a solution for the connection between Outlook and Excel, and haven't done so for years."

You don't have to understand that either. It's Microsoft - that explains everything.