Importing data from CSV format file

Importing CSV format file

For reports which are generated in CSV (comma separated) format, it is easy to import the report into Microsoft Excel. By using Excel’s text import wizard as follows you can ensure that the data is imported correctly and leading zeros are not dropped.

Note: In the CSV file, where an item of data itself contains a comma,the whole item will be enclosed in double quotes. This is then recognised by Excel as being a single field.

For an example, I imported a csv format file named sales database in a new worksheet. For importing csv format file, do the following.

1. From Data Tab, select Import Text File under Get External Data group. Browse for the file you have saved. Having selected your file click ‘Import’.

import button

2. It will start the Text Import wizard at step 1 of 3. Ensure that the ‘Delimited’ option is selected. Click Next.

Import wizard

3. In the delimiters section tick ‘Comma’. The text qualifier box should show the double-quote symbol. Click Next.

select comma

4. Step 3 of 3. You now need to set every column to be data format General, Text, Date. If you do not want to import a specific column, then select Do not import column (skip) option. you can leave every column as General.

text format

5. Click Finish.

finish status

6. It may ask you ‘Where do you want to put the data?’. It will allow you to click into any cell on the blank worksheet to determine where the data should go. Click ‘OK’ to proceed.

7. The data should now appear in the spreadsheet. Where column headings are included these will appear in the top row. Check that fields have not lost leading zeros where applicable.

result

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment