Posts Tagged 'CSV'

How to export and import contacts between Outlook and Google Gmail

Switching between Microsoft Outlook and Google Gmail is a very common trend these days. Some people are migrating from a desktop-oriented Outlook app to a cloud-based Gmail while others are using different email clients for their personal and business communication. Luckily, both Outlook and Gmail make it possible to transfer all your contacts in one go. Continue reading

How to import contacts into Outlook from CSV and PST file

There may be different reasons why you may want to transfer contacts into your Outlook address book. For example, you inherited a list of contacts in an external database, or you are migrating from another mail server, or perhaps you are setting up a new account. Continue reading

How to export contacts from Outlook

Whether you are migrating to another email service or making a regular backup of your data, it is crucial to transfer all contact details without any fail. This tutorial will teach you a few easy ways to export Outlook contacts into a .csv or .pst file, so that you could later import them anywhere you need. Continue reading

How to import contacts to Outlook from Excel in 3 steps

In this article, I’ll show you how to import contacts from Excel to Outlook 2010-2013. You’ll find three easy steps for getting your contacts exported. Convert your data to .csv format, import them to Outlook with a special wizard and match Excel headers to the corresponding fields. Continue reading

Convert CSV to Excel: how to import CSV files into Excel spreadsheets

In this article you will find 3 quick ways to convert CSV to Excel. You will also learn how to import multiple CSV files in a single workbook and how to handle the cases when some data from a CSV file isn't correctly displayed in an Excel sheet. Continue reading

How to convert Excel to CSV and export Excel files to CSV UTF-8 format

In this article we will investigate quick and efficient ways to export an Excel file to CSV and convert Excel spreadsheets to CSV UTF-8 format, keeping all special characters and foreign symbols intact. Continue reading

How to remove carriage returns (line breaks) from cells in Excel

In this tip you'll find 3 ways to remove carriage returns from Excel cells. You'll also learn how to replace line breaks with other symbols. All solutions work for Excel 2013, 2010 – 2003 Continue reading

How to avoid automatic data formatting in Excel

Excel is a helpful program when you have standard tasks and standard data. Once you want to go your non-standard-Excel way, some frustration is involved. Especially when we have large data sets. I came across one of such formatting issues when I dealt with our customers' tasks in Excel. Continue reading