Outlook - Export contacts from Outlook Tutorial

In this video, you will learn how to export contacts from Outlook.
The video covers the process of saving your contacts in a CSV file, which can then be imported into a different email account.
To export your contacts, go to the File tab, select Open and Export, and click on Import/Export.
Choose the option to export to a file in comma-separated values format.
Select the contacts folder under your account and choose the location to save the file.
Once the export is complete, open the file in Excel to verify that your contacts are present.
This tutorial will help you efficiently export your Outlook contacts and update their information using Excel.

1:09
2993 views

Available in Microsoft365

Objectifs :

This guide aims to provide a step-by-step process for exporting contacts from Outlook to a CSV file, which can then be used to import contacts into a different email account. It will also cover how to verify and update the exported contacts using Excel.

Chapitres :

Introduction to Exporting Contacts from Outlook
Exporting contacts from Outlook is a straightforward process that allows users to save their contact information in a CSV file format. This file can be utilized to import contacts into other email accounts, ensuring that important contact information is not lost during transitions between platforms.
Step-by-Step Process to Export Contacts
Follow these steps to export your contacts from Outlook: 1. **Open Outlook**: Launch the Outlook application on your computer. 2. **File Tab**: Click on the 'File' tab located in the upper left corner of the window. 3. **Open and Export**: Select 'Open & Export' from the menu options. 4. **Import/Export Wizard**: Click on 'Import/Export' to open the wizard. 5. **Export to a File**: In the wizard, choose 'Export to a file' and select 'Comma Separated Values (CSV)'. 6. **Select Folder**: Choose the folder you want to export from, typically the 'Contacts' folder under your account. 7. **Save Location**: Specify the location where you want to save the CSV file and give it a name. 8. **Finish Exporting**: Click 'Next' and then 'Finish' to start the export process.
Completing the Export Process
Once you have completed the export process, a progress dialog box will appear, indicating that your contacts are being exported. After the process is finished, this dialog box will disappear, confirming that your contacts have been successfully saved in the specified location.
Verifying and Updating Contacts in Excel
To ensure that your contacts have been exported correctly, follow these steps: 1. **Open the CSV File**: Navigate to the location where you saved the CSV file and open it using Microsoft Excel. 2. **Check Contacts**: Review the contents of the file to confirm that all your contacts are present. 3. **Update Information**: You can use Excel to update any information in your CSV file as needed before importing it into another email account.
Conclusion
Exporting contacts from Outlook to a CSV file is a valuable skill that facilitates the transfer of important contact information between different email accounts. By following the outlined steps, users can ensure a smooth transition and maintain their contact lists effectively.

FAQ :

How do I export my contacts from Outlook?

To export your contacts from Outlook, go to the File tab, select 'Open and Export', then click on 'Import/Export'. Choose 'Export to a file', select 'Comma Separated Values', and follow the prompts to select the contacts folder and save the file.

What is a CSV file and why is it used for contacts?

A CSV file is a simple text file that uses commas to separate values. It is commonly used for exporting and importing data because it is compatible with many applications, making it easy to transfer contact information between different email accounts.

Can I edit my contacts in Excel after exporting them?

Yes, after exporting your contacts to a CSV file, you can open the file in Excel to update or modify the information as needed.

What should I do if my contacts do not appear in the exported CSV file?

If your contacts do not appear in the exported CSV file, ensure that you selected the correct contacts folder during the export process. You may also want to check if there are any filters applied that could be hiding your contacts.

Is it possible to import contacts from a CSV file back into Outlook?

Yes, you can import contacts from a CSV file back into Outlook by using the Import/Export Wizard. Select 'Import from another program or file', choose 'Comma Separated Values', and follow the prompts to import your contacts.

Quelques cas d'usages :

Migrating Contacts to a New Email Account

When switching to a new email provider, users can export their contacts from Outlook as a CSV file and then import them into the new email account. This process ensures that all important contact information is retained and easily accessible in the new account.

Updating Contact Information in Bulk

Users can export their contacts to a CSV file, make bulk updates in Excel (such as correcting phone numbers or adding new email addresses), and then re-import the updated CSV file back into Outlook. This method saves time compared to updating each contact individually.

Creating a Backup of Contacts

Exporting contacts from Outlook to a CSV file serves as a backup. Users can store this file securely and restore their contacts if needed, ensuring that important information is not lost.

Sharing Contacts with Team Members

A CSV file containing exported contacts can be shared with team members or colleagues, allowing them to import the same contacts into their email accounts. This is useful for maintaining consistent contact information across a team.

Integrating Contacts with Other Applications

Exporting contacts to a CSV file allows users to integrate their contact information with other applications, such as CRM systems or marketing tools, enhancing their ability to manage and utilize contact data effectively.

Glossaire :

CSV

CSV stands for Comma-Separated Values. It is a file format used to store tabular data, such as a spreadsheet or database, in plain text. Each line in a CSV file corresponds to a row in the table, and each value in that row is separated by a comma.

Outlook

Outlook is a personal information manager developed by Microsoft, primarily used as an email application. It also includes calendar, task manager, contact manager, note-taking, journal, and web browsing features.

Import/Export Wizard

The Import/Export Wizard in Outlook is a tool that helps users transfer data between different file formats and applications. It guides users through the process of importing or exporting data, such as contacts or emails.

Excel

Excel is a spreadsheet program developed by Microsoft that allows users to organize, format, and calculate data with formulas using a system of rows and columns.

Contacts Folder

The Contacts Folder in Outlook is a designated area where all contact information is stored. Users can create, edit, and manage their contacts within this folder.

00:00:05

a copy of your contacts is saved in a CSV file,

00:00:09

or another type.

00:00:11

You can then use this file to import your contacts

00:00:13

in a different email account.

00:00:16

To do this, in the file tab, select open and export.

00:00:21

Then click on import export.

00:00:24

The wizard opens, select export to a file,

00:00:30

comma separated values.

00:00:33

Then select the folder to export.

00:00:36

Navigate to the contacts folder under your account.

00:00:40

Choose the location where you want to save the file

00:00:43

and name it.

00:00:46

Click next and finally finish to start to export

00:00:49

your contacts immediately.

00:00:51

Once the process is complete,

00:00:53

the progress dialog box disappears.

00:00:57

Then open your new file in your computer with Excel

00:01:00

to check that your contacts are present.

00:01:03

You can now use Excel to update the information

00:01:06

in your CSV file.

00:00:03

Wanneer je je contactpersonen uit Outlook exporteert,...

00:00:05

wordt een kopie opgeslagen als CSV-bestand...

00:00:09

of ander type bestand.

00:00:11

Je kunt dit bestand dan gebruiken om je contactpersonen...

00:00:13

te importeren in een ander e-mailaccount.

00:00:16

Klik op het tabblad Bestand, Openen en Exporteren.

00:00:21

Klik dan op Importeren/Exporteren.

00:00:24

De wizard verschijnt. Selecteer Exporteren naar bestand,...

00:00:30

door komma's gescheiden waarden.

00:00:34

Selecteer dan de map die je wilt exporteren.

00:00:36

Navigeer naar de contactpersonen onder je account.

00:00:40

Kies de locatie waar je het bestand wilt opslaan...

00:00:43

en geef het bestand een naam.

00:00:46

Klik op Volgende en Voltooien om je contactpersonen...

00:00:49

direct te exporteren.

00:00:51

Wanneer het proces is voltooid...

00:00:53

verdwijnt het dialoogvenster.

00:00:57

Open dan het nieuwe bestand met Excel...

00:01:00

en controleer of het je contactpersonen bevat.

00:01:03

Je kunt nu Excel gebruiken om de informatie...

00:01:06

in je CSV-bestand bij te werken.

00:00:03

Wenn Sie Ihre Kontakte aus Outlook exportieren,

00:00:05

wird eine Kopie Ihrer Kontakte in einer CSV-Datei oder

00:00:09

einem anderen Dateityp gespeichert.

00:00:11

Sie können dann diese Datei verwenden, um Ihre Kontakte in ein anderes

00:00:13

E-Mail-Konto zu importieren.

00:00:16

Öffnen Sie dafür in der Datei-Registerkarte „Speichern und Exportieren”.

00:00:21

Klicken Sie dann auf „Import/Export”.

00:00:24

Der Assistent wird geöffnet: Wählen Sie „In Datei exportieren”

00:00:30

und CSV als Dateiformat.

00:00:33

Dann wählen Sie den Exportordner.

00:00:36

Gehen Sie zum Kontaktordner Ihres Kontos.

00:00:40

Wählen Sie den Speicherort für Ihre Datei und

00:00:43

benennen Sie sie.

00:00:46

Klicken Sie auf „Weiter” und schließlich auf „Fertig”, um den Export Ihrer Kontakte

00:00:49

unmittelbar zu starten.

00:00:51

Wenn der Vorgang abgeschlossen ist,

00:00:53

verschwindet das Dialogfenster mit der Fortschrittsanzeige.

00:00:57

Öffnen Sie anschließend Ihre neue Datei mit Excel auf Ihrem Computer, um

00:01:00

die Vollständigkeit aller Kontakte zu überprüfen.

00:01:03

Jetzt können Sie Excel auch dafür verwenden, um die Informationen in Ihrer

00:01:06

CSV-Datei zu aktualisieren.

00:00:03

Cuando exporta sus contactos desde Outlook,

00:00:05

se guarda una copia de los mismos en un archivo CSV

00:00:09

o de otro tipo.

00:00:11

Luego puede utilizar este archivo para importar sus contactos

00:00:13

a una cuenta de correo diferente.

00:00:16

Para ello, en la pestaña Archivo, seleccione Abrir y exportar.

00:00:21

Haga clic en Importar o exportar.

00:00:24

En el asistente, seleccione Exportar a un archivo

00:00:30

y Valores separados por comas.

00:00:33

Elija la carpeta que desea exportar.

00:00:36

Busque la carpeta de contactos en su cuenta.

00:00:40

Elija la ubicación donde desea guardar el archivo

00:00:43

y dele un nombre.

00:00:46

Haga clic en Siguiente y, por último, en Finalizar para empezar a exportar

00:00:49

sus contactos inmediatamente.

00:00:51

Una vez terminado el proceso,

00:00:53

la ventana de progreso desaparece.

00:00:57

A continuación, utilice Excel para abrir el nuevo archivo en su ordenador

00:01:00

para comprobar que sus contactos estén ahí.

00:01:03

Ahora ya sabe cómo utilizar Excel para actualizar la información

00:01:06

de su archivo CSV.

00:00:03

Quando você exporta seus contatos a partir do Outlook,

00:00:05

uma cópia deles é salva em um arquivo CSV,

00:00:09

ou outro tipo.

00:00:11

Você pode usar este arquivo para importar seus contatos

00:00:13

em uma conta de e-mail diferente.

00:00:16

Para isso, na aba Arquivo, selecione Abrir e exportar.

00:00:21

Então clique em Importar/Exportar.

00:00:24

A janela se abre, selecione Exportar para um arquivo,

00:00:30

e então Valores separados por vírgula.

00:00:33

Selecione a pasta para exportação.

00:00:36

Navegue para a pasta de contatos sob sua conta.

00:00:40

Escolha o local onde deseja salvar o arquivo

00:00:43

e escolha um nome para ele.

00:00:46

Clique em Próximo e, finalmente em Concluir para iniciar a exportação

00:00:49

imediata de seus contatos.

00:00:51

Uma vez completo o processo,

00:00:53

a caixa de diálogo de progresso desaparece.

00:00:57

Abra o novo arquivo no seu computador com o Excel

00:01:00

para verificar que os seus contatos estão presentes.

00:01:03

Agora você pode usar o Excel para atualizar as informações

00:01:06

no seu arquivo CSV.

00:00:03

Quando si esporta i tuoi contatti da Outlook.

00:00:05

una copia dei contatti viene salvato in un file CSV,.

00:00:09

o un altro tipo.

00:00:11

È quindi possibile utilizzare questo file per importare i contatti.

00:00:13

in un altro account e-mail.

00:00:16

A tale scopo, nel file , selezionare Apri ed esporta..

00:00:21

Quindi fare clic su Import export.

00:00:24

Viene visualizzata la procedura guidata, selezionare Esporta in un file,

00:00:30

valori separati da virgola.

00:00:33

Quindi selezionare la cartella da esportare.

00:00:36

Passare ai contatti cartella sotto il tuo account..

00:00:40

Scegliere la posizione in cui si desidera salvare il file.

00:00:43

e nominarlo.

00:00:46

Fare clic su Avanti e infine fine per iniziare a esportare.

00:00:49

contatti immediatamente.

00:00:51

Una volta completato il processo,

00:00:53

la finestra di dialogo di avanzamento scompare.

00:00:57

Quindi aprire il nuovo file in il tuo computer con Excel.

00:01:00

per verificare che i contatti siano presenti.

00:01:03

È ora possibile utilizzare Excel per aggiornare le informazioni.

00:01:06

nel file CSV.

00:00:03

匯出時您的連絡人從 Outlook.

00:00:05

連絡人的副本保存在 CSV 檔中，.

00:00:09

或其他類型。

00:00:11

然後，您可以使用此檔導入您的連絡人.

00:00:13

在不同的電子郵件帳戶中。

00:00:16

為此，在檔中選項卡，選擇"打開"和"匯出"。.

00:00:21

然後按一下導入匯出。

00:00:24

嚮導將打開，選擇匯出到檔，

00:00:30

逗號分隔值。

00:00:33

然後選擇要匯出的資料夾。

00:00:36

導航到連絡人資料夾。.

00:00:40

選擇位置要保存檔.

00:00:43

並命名它。

00:00:46

按一下"下一步"，最後按一下完成開始匯出.

00:00:49

您的連絡人立即。

00:00:51

該過程完成後，

00:00:53

進度對話方塊消失。

00:00:57

然後在使用 Excel 的電腦.

00:01:00

檢查您的連絡人是否存在。

00:01:03

您現在可以使用 Excel 更新資訊.

00:01:06

在 CSV 檔中。

00:00:03

エクスポート時 Outlook からの連絡先.

00:00:05

連絡先のコピーは CSV ファイルに保存され、.

00:00:09

または別の型。

00:00:11

その後、このファイルを使用できます。連絡先をインポートするには.

00:00:13

別の電子メールアカウントで。

00:00:16

これを行うには、ファイル内タブを選択し、[開いてエクスポート] を選択します。.

00:00:21

次に、インポートエクスポートをクリックします。

00:00:24

ウィザードが開き、[ファイルへのエクスポート] を選択し、

00:00:30

コンマ区切り値。

00:00:33

次に、エクスポートするフォルダを選択します。

00:00:36

連絡先に移動するアカウントの下のフォルダ。.

00:00:40

場所を選択します。ファイルを保存する.

00:00:43

と名前を付けます。

00:00:46

[次へ] をクリックし、最後にエクスポートを開始する仕上げ.

00:00:49

すぐにあなたの連絡先。

00:00:51

プロセスが完了したら、

00:00:53

[進行状況] ダイアログボックスが表示されなくなります。

00:00:57

次に、新しいファイルを開きます。 Excel を使用したコンピュータ.

00:01:00

を使用して、連絡先が存在することを確認します。

00:01:03

Excel を使用して、情報を更新する.

00:01:06

CSV ファイルに含まれます。

00:00:03

Khi bạn xuất danh bạ của bạn từ Outlook.

00:00:05

bản sao danh bạ của bạn được lưu trong tệp CSV,.

00:00:09

hoặc một loại khác.

00:00:11

Sau đó, bạn có thể sử dụng tệp này để nhập danh bạ của bạn.

00:00:13

trong một tài khoản email khác.

00:00:16

Để thực hiện việc này, trong tập tin tab, chọn mở và xuất..

00:00:21

Sau đó bấm vào xuất nhập khẩu.

00:00:24

Thuật sĩ mở ra, chọn xuất sang một tập tin,

00:00:30

giá trị phân tách bằng dấu phẩy.

00:00:33

Sau đó chọn thư mục để xuất.

00:00:36

Điều hướng đến các số liên lạc thư mục trong tài khoản của bạn..

00:00:40

Chọn vị trí nơi bạn muốn lưu tệp.

00:00:43

và tên nó.

00:00:46

Nhấp vào tiếp theo và cuối cùng kết thúc để bắt đầu xuất khẩu.

00:00:49

danh bạ của bạn ngay lập tức.

00:00:51

Một khi quá trình hoàn tất,

00:00:53

hộp thoại tiến trình biến mất.

00:00:57

Sau đó, mở tệp mới của bạn trong máy tính của bạn với Excel.

00:01:00

để kiểm tra xem danh bạ của bạn có xuất hiện hay không.

00:01:03

Bây giờ bạn có thể sử dụng Excel để Cập nhật thông tin.

00:01:06

trong tệp CSV của bạn.

00:00:03

Saat Anda mengekspor kontak Anda dari Outlook.

00:00:05

salinan kontak Anda disimpan dalam file CSV,.

00:00:09

atau jenis lain.

00:00:11

Anda kemudian dapat menggunakan file ini untuk mengimpor kontak Anda.

00:00:13

di akun email yang berbeda.

00:00:16

Untuk melakukan ini, dalam file tab, pilih buka dan ekspor..

00:00:21

Kemudian klik pada impor ekspor.

00:00:24

Wizard akan terbuka, pilih ekspor ke file,

00:00:30

nilai yang dipisahkan koma.

00:00:33

Kemudian pilih folder yang akan diekspor.

00:00:36

Menavigasi ke kontak folder di bawah akun Anda..

00:00:40

Pilih lokasi di mana Anda ingin menyimpan file.

00:00:43

dan beri nama.

00:00:46

Klik berikutnya dan akhirnya selesai untuk mulai mengekspor.

00:00:49

kontak Anda segera.

00:00:51

Setelah proses selesai,

00:00:53

kotak dialog progres menghilang.

00:00:57

Kemudian buka file baru Anda di komputer Anda dengan Excel.

00:01:00

untuk memeriksa apakah kontak Anda ada.

00:01:03

Anda sekarang dapat menggunakan Excel untuk memperbarui informasi.

00:01:06

di file CSV.

00:00:03

При экспорте ваши контакты из Outlook.

00:00:05

копия ваших контактов сохраняется в файле CSV,.

00:00:09

или другого типа.

00:00:11

Затем вы можете использовать этот файл импортировать ваши контакты.

00:00:13

в другой учетной записи электронной почты.

00:00:16

Для этого в файле вкладку, выберите открытый и экспорт..

00:00:21

Затем нажмите на экспорт импорта.

00:00:24

Мастер открывается, выберите экспорт в файл,

00:00:30

запятые разделенные значения.

00:00:33

Затем выберите папку для экспорта.

00:00:36

Перейдите к контактам папку под вашей учетной записью..

00:00:40

Выберите место, где Вы хотите сохранить файл.

00:00:43

и назовите его.

00:00:46

Нажмите дальше и, наконец, закончить, чтобы начать экспортировать.

00:00:49

ваши контакты немедленно.

00:00:51

Как только процесс будет завершен,

00:00:53

диалоговое окно прогресса исчезает.

00:00:57

Затем откройте свой новый файл в ваш компьютер с Excel.

00:01:00

чтобы проверить наличие контактов.

00:01:03

Теперь вы можете использовать Excel для обновить информацию.

00:01:06

в вашем файле CSV.

00:00:03

Когато експортирате контактите ви от Outlook.

00:00:05

копие на вашите контакти се записва в CSV файл,.

00:00:09

или друг тип.

00:00:11

След това можете да използвате този файл за импортиране на контактите.

00:00:13

в друг имейл акаунт.

00:00:16

За да направите това, във файла изберете отваряне и експортиране..

00:00:21

След това кликнете върху импортиране на износ.

00:00:24

Съветникът се отваря, изберете експортиране във файл,

00:00:30

стойности, разделени със запетая.

00:00:33

След това изберете папката за експортиране.

00:00:36

Навигиране до контактите папката под вашия акаунт..

00:00:40

Изберете мястото, където искате да запишете файла.

00:00:43

и го наз

00:00:46

Кликнете върху следващия и накрая завърши, за да започнете да експортирате.

00:00:49

контактите си.

00:00:51

След като процесът приключи,

00:00:53

диалоговият прозорец за изпълнение изчезва.

00:00:57

След това отворете новия файл в вашия компютър с Excel.

00:01:00

, за да проверите дали контактите ви са налични.

00:01:03

Сега можете да използвате Excel, за да актуализиране на информацията.

00:01:06

в CSV файла.

00:00:03

Când exportați persoanele de contact din Outlook.

00:00:05

o copie a persoanelor de contact este salvat într-un fișier CSV,.

00:00:09

sau alt tip.

00:00:11

Apoi, aveți posibilitatea să utilizați acest fișier pentru a importa persoanele de contact.

00:00:13

într-un alt cont de e-mail.

00:00:16

Pentru a face acest lucru, în fișierul , selectați deschidere și export..

00:00:21

Apoi faceți clic pe import export.

00:00:24

Expertul se deschide, selectați export într-un fișier,

00:00:30

valori separate prin virgulă.

00:00:33

Apoi selectați folderul de exportat.

00:00:36

Navigarea la persoanele de contact folder sub contul dvs..

00:00:40

Alegeți locația în care doriți să salvați fișierul.

00:00:43

și spune-i.

00:00:46

Faceți clic pe următorul și în cele din urmă terminare pentru a începe exportul.

00:00:49

contactele imediat.

00:00:51

Odată ce procesul este finalizat,

00:00:53

caseta de dialog progres dispare.

00:00:57

Apoi deschideți noul fișier în computerul cu Excel.

00:01:00

pentru a verifica prezența persoanelor de contact.

00:01:03

Acum puteți utiliza Excel pentru a actualizare informații.

00:01:06

în fișierul CSV.

00:00:03

Під час експорту контакти з програми Outlook.

00:00:05

копія контактів зберігається у файлі CSV,.

00:00:09

або іншого типу.

00:00:11

Потім ви можете використовувати цей файл , щоб імпортувати контакти.

00:00:13

в іншому обліковому записі електронної пошти.

00:00:16

Для цього у файлі виберіть відкрити та експортувати..

00:00:21

Потім натисніть на імпорт експорту.

00:00:24

Відкриється майстер, виберіть експорт до файлу,

00:00:30

значення, розділені комами.

00:00:33

Потім виберіть папку для експорту.

00:00:36

Перехід до контактів папки під вашим обліковим записом..

00:00:40

Виберіть місце, де , який потрібно зберегти файл.

00:00:43

і назвіть його.

00:00:46

Натисніть кнопку Далі і, нарешті, завершити експорт.

00:00:49

контакти негайно.

00:00:51

Після завершення процесу

00:00:53

діалогового вікна перебігу зникає.

00:00:57

Потім відкрийте новий файл у комп'ютер-зразок за допомогою програми Excel.

00:01:00

щоб перевірити наявність ваших контактів.

00:01:03

Тепер можна використовувати програму Excel, щоб оновити інформацію.

00:01:06

у файлі CSV.

00:00:03

Dışa aktarırken kişileriniz Outlook'tan.

00:00:05

kişilerinizin bir kopyası bir CSV dosyasına kaydedilir,.

00:00:09

veya başka bir tür.

00:00:11

Daha sonra bu dosyayı kullanabilirsiniz kişileri içe almak için.

00:00:13

farklı bir e-posta hesabında.

00:00:16

Bunu yapmak için, dosyada sekmesini seçin ve dışa aktarın..

00:00:21

Sonra ithalat dışa aktarma tıklayın.

00:00:24

Sihirbaz açılır, bir dosyaya dışa aktarma yı seçin,

00:00:30

virgül ayrılmış değerler.

00:00:33

Sonra dışa aktarmak için klasörü seçin.

00:00:36

Kişilere gidin hesabınız altında klasör..

00:00:40

Konumu seçin dosyayı kaydetmek istiyorsanız.

00:00:43

ve adını.

00:00:46

Sonraki ve son olarak tıklatın ihracata başlamak için bitirmek.

00:00:49

kişileriniz hemen.

00:00:51

İşlem tamamlandıktan sonra,

00:00:53

ilerleme iletişim kutusu kaybolur.

00:00:57

Ardından yeni dosyanızı Excel ile bilgisayarınız.

00:01:00

kişilerinizin mevcut olup olmadığını kontrol etmek için.

00:01:03

Artık Excel'i bilgileri güncelleyin.

00:01:06

CSV dosyanızda.

00:00:03

Quando exporta seus contactos do Outlook.

00:00:05

uma cópia dos seus contactos é guardado num ficheiro CSV,.

00:00:09

ou outro tipo.

00:00:11

Em seguida, pode utilizar este ficheiro para importar os seus contactos.

00:00:13

numa conta de e-mail diferente.

00:00:16

Para fazer isto, no arquivo separador, selecione aberto e exportação..

00:00:21

Em seguida, clique na exportação de importação.

00:00:24

O assistente abre, seleciona exportação para um ficheiro,

00:00:30

vírgula valores separados.

00:00:33

Em seguida, selecione a pasta para exportar.

00:00:36

Navegue para os contactos pasta sob a sua conta..

00:00:40

Escolha o local onde quer guardar o ficheiro.

00:00:43

e nomeá-lo.

00:00:46

Clique a seguir e, finalmente, terminar para começar a exportar.

00:00:49

seus contactos imediatamente.

00:00:51

Uma vez concluído o processo,

00:00:53

a caixa de diálogo de progresso desaparece.

00:00:57

Em seguida, abra o seu novo arquivo em seu computador com Excel.

00:01:00

para verificar se os seus contactos estão presentes.

00:01:03

Agora pode usar o Excel para atualizar a informação.

00:01:06

no seu ficheiro CSV.

00:00:03

Kada izvozite kontakti iz programa Outlook.

00:00:05

kopija vaših kontakata je sačuvano u CSV datoteci,.

00:00:09

ili neki drugi tip.

00:00:11

Zatim možete da koristite ovu datoteku uvoz kontakata.

00:00:13

na drugom nalogu e-pošte.

00:00:16

Da biste to uradite, u datoteci izaberite opciju otvori i izvezi..

00:00:21

Zatim kliknite na uvoz izvoza.

00:00:24

Ako se čarobnjak otvori, izaberite izvezite u datoteku,

00:00:30

vrednosti razdvojene zarezima.

00:00:33

Zatim izaberite fasciklu za izvoz.

00:00:36

Kreći se do kontakata fasciklu ispod naloga..

00:00:40

Odaberite lokaciju na kojoj želite da sačuvate datoteku.

00:00:43

I navedi ga.

00:00:46

Kliknite na sledeće i konačno završiti da biste započeli izvoz.

00:00:49

vaše kontakte odmah.

00:00:51

Kada se proces završi,

00:00:53

dijalog tok nestaje.

00:00:57

Zatim otvorite novu datoteku u računar sa programom Excel.

00:01:00

da biste proverili da li su vaši kontakti prisutni.

00:01:03

Sada možete da koristite Excel za ažuriranje informacija.

00:01:06

u CSV datoteci.

00:00:05

نسخة من جهات الاتصال يتم حفظها في ملف CSV،.

00:00:09

أو نوع آخر.

00:00:11

يمكنك بعد ذلك استخدام هذا الملف لاستيراد جهات الاتصال.

00:00:13

في حساب بريد إلكتروني مختلف.

00:00:16

للقيام بذلك، في الملف tab ، حدد فتح وتصدير..

00:00:21

ثم انقر على تصدير الاستيراد.

00:00:24

يفتح المعالج، وحدد التصدير إلى ملف،

00:00:30

قيم مفصولة بفاصلة.

00:00:33

ثم حدد المجلد المطلوب تصديره.

00:00:36

الانتقال إلى جهات الاتصال المجلد تحت حسابك..

00:00:40

اختر الموقع الذي تريد حفظ الملف.

00:00:43

وتسميته.

00:00:46

انقر فوق التالي وأخيرا إنهاء لبدء التصدير.

00:00:49

جهات الاتصال الخاصة بك على الفور.

00:00:51

بمجرد الانتهاء من العملية،

00:00:53

يختفي مربع الحوار التقدم.

00:00:57

ثم افتح الملف الجديد في الكمبيوتر باستخدام Excel.

00:01:00

للتحقق من وجود جهات الاتصال الخاصة بك.

00:01:03

يمكنك الآن استخدام Excel إلى تحديث المعلومات.

00:01:06

في ملف CSV الخاص بك.

00:00:05

연락처 사본 CSV 파일에 저장됩니다..

00:00:09

또는 다른 유형.

00:00:11

그런 다음 이 파일을 사용할 수 있습니다. 연락처가져오기.

00:00:13

다른 이메일 계정에서.

00:00:16

이렇게 하려면 파일에서 열려 있는 것을 선택하고 내보내기합니다..

00:00:21

그런 다음 내보내기 가져오기를 클릭합니다.

00:00:24

마법사가 열리고 파일로 내보내기를 선택하고,

00:00:30

쉼표 분리 값입니다.

00:00:33

그런 다음 내보낼 폴더를 선택합니다.

00:00:36

연락처로 이동 계정 아래의 폴더입니다..

00:00:40

위치 선택 파일을 저장하려는 경우.

00:00:43

이름을 지정합니다.

00:00:46

다음을 클릭하고 마지막으로 수출 시작 완료.

00:00:49

연락처는 즉시 연락할 수 있습니다.

00:00:51

프로세스가 완료되면

00:00:53

진행 상황 대화 상자가 사라집니다.

00:00:57

그런 다음 새 파일을 엽니다. Excel이 있는 컴퓨터.

00:01:00

연락처가 있는지 확인합니다.

00:01:03

이제 Excel을 사용하여 정보 업데이트.

00:01:06

CSV 파일에서.

00:00:05

联系人的副本保存在 CSV 文件中，.

00:00:09

或其他类型。

00:00:11

然后，您可以使用此文件以导入您的联系人.

00:00:13

在其他电子邮件帐户中。

00:00:16

为此，请在文件中选项卡上，选择打开并导出。.

00:00:21

然后单击导入导出。

00:00:24

向导打开，选择导出到文件，

00:00:30

逗号分隔值。

00:00:33

然后选择要导出的文件夹。

00:00:36

导航到联系人文件夹在您的帐户下。.

00:00:40

选择位置您要保存文件.

00:00:43

并命名它。

00:00:46

单击"下一步"，最后单击完成以开始导出.

00:00:49

您的联系人立即。

00:00:51

一旦该过程完成，

00:00:53

进度对话框将消失。

00:00:57

然后在中打开新文件使用 Excel 的计算机.

00:01:00

以检查您的联系人是否存在。

00:01:03

现在，您可以使用 Excel 更新信息.

00:01:06

在 CSV 文件中。

00:00:05

สําเนาของที่ติดต่อของคุณ ถูกบันทึกในไฟล์ CSV.

00:00:09

หรือประเภทอื่น

00:00:11

จากนั้นคุณสามารถใช้แฟ้มนี้ได้ เมื่อต้องการนําเข้าที่ติดต่อของคุณ.

00:00:13

ในบัญชีอีเมลอื่น

00:00:16

เมื่อต้องการทําเช่นนี้ ในแฟ้ม เลือก เปิด และส่งออก.

00:00:21

จากนั้นคลิกที่การส่งออกการนําเข้า

00:00:24

วิซาร์ดจะเปิดขึ้น

00:00:30

ใช้จุลภาคคั่นระหว่างค่า

00:00:33

จากนั้นเลือกโฟลเดอร์ที่จะส่งออก

00:00:36

นําทางไปยังที่ติดต่อ ภายใต้บัญชีของคุณ.

00:00:40

เลือกตําแหน่งที่ตั้งที่ คุณต้องการบันทึกแฟ้ม.

00:00:43

และตั้งชื่อมัน

00:00:46

คลิกถัดไปและสุดท้าย เสร็จสิ้นเพื่อเริ่มส่งออก.

00:00:49

ผู้ติดต่อของคุณทันที

00:00:51

เมื่อกระบวนการเสร็จสมบูรณ์

00:00:53

กล่องโต้ตอบความคืบหน้าจะหายไป

00:00:57

จากนั้นเปิดไฟล์ใหม่ของคุณใน คอมพิวเตอร์ของคุณด้วย Excel.

00:01:00

เพื่อตรวจสอบว่ามีที่ติดต่อของคุณอยู่หรือไม่

00:01:03

ขณะนี้คุณสามารถใช้ Excel เพื่อ ปรับปรุงข้อมูล.

00:01:06

ในไฟล์ CSV ของคุณ

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

2637 Views

Microsoft Outlook Video Training – Intermediate

Through a logical progression of video tutorials, discover the intermediate features of Microsoft Outlook: Sorting & searching your mails, O...

1908 Views

Training Video Business Uses – Assistants

To write a last-minute document, optimize communication or quickly format documents, Office 365 provides a range of features that will meet ...

ALL COURSES