The following is a step-by-step guide to importing a CSV (comma separated value) file into a blank worksheet using Microsoft Excel 2007.
1. Create a new workbook (Ctrl + N)
2. Click the Data tab on the ribbon and select 'From Text' under 'Get External Data'.
3. Select 'delimited' if your data is separated with a specific character (you'll have to specify the delimiting character on the next step).
4. If you have a header row, enter a value for 'Start Import at row...'
5. Click 'Next' and select your delimiting character. In the example here, it's a semi-colon ';'
6. If you wish to have control over how Excel renders your data, you can specify field types here. For example, I need the 'Barcode' field to be rendered as Text because it may contain leading zeros or be summarised by Excel if it's treated as a number.
7. Finally, select your existing worksheet and click 'OK' to import your data.
