Data is regularly exported from databases in comma separated values (CSV) files. These can be opened by Microsoft Excel, however formatting of data in the document can be affected. For example, leading zeroes are dropped and long strings of numbers are automatically formatted to exponential number formats. To prevent these errors, a CSV file should be imported into Excel.
Open a blank workbook in Microsoft Excel. Click into cell A1. Go to the "Data" tab in excel. Click "From Text"
Select the CSV file to import and click "Import"
The Text Import Wizard appears. Select "Delimited" as the file type and start import at row: 1. Click "Next"
In step 2 of the wizard you select a delimiter. Choose "Tab", which specifies the rows, and "Comma" which specifies the columns. Confirm the data looks correct in the "Data Preview". Click "Next"
Specify the "Column data format" for each column. This allows you to select what formatting each column should have, rather than letting excel try to determine it for you.
For example you can specify that the Phone column is "Text" to prevent excel dropping the leading zeroes from the phone number.
When you are happy with formatting, click "Finish"
Specify the destination for the imported data, either in an existing worksheet, or on a new worksheet. Click "Okay"
Your data now appears correctly formatted. You can continue to modify and edit your document.