This guide covers importing a CSV file into a blank worksheet using Microsoft Excel 2007. Don't open the CSV in Excel, instead create a new workbook, click on the data tab on the ribbon and select 'Get External Data', 'From Text'. 
Select 'delimited' if your data is seperated with a specific character. You'll have to specify the delimiting character on the next step. If you have a header row, enter a value for 'Start Import at row...' 
Click 'Next' and select your delimiting character. In this case, it's a semi-colon ';' 
If you wish to shape your data, you can enter field types here. For example, I want the 'Barcode' field to be rendered as Text as it may contain leading zeros or be summarised by Excel if it's treated as a number. Next, select your existing worksheet and press OK to import your data.
Importing CSV to Excel
Freshness Warning
This post is more than 4 years old. Please bear in mind its age when reading.
about 4 years ago Published in Tutorials by Nick Kewney - Comments (1)
I'm running the 39th BMW Berlin Marathon
on 30th September 2012 for the British Lung Foundation,
who are currently funding research on the prevention of lung damage in COPD and
many other areas related to lung disease.
I'm participating with my sister Claire Kewney and, on behalf of the charity, would appreciate even the smallest donation. My own JustGiving page is here, our team page is here.
if you're in the UK, you can also donate using your mobile phone by texting NKEW82 £5 (or any amount) to 70070. Your donation will be appreciated!
I'm participating with my sister Claire Kewney and, on behalf of the charity, would appreciate even the smallest donation. My own JustGiving page is here, our team page is here.
if you're in the UK, you can also donate using your mobile phone by texting NKEW82 £5 (or any amount) to 70070. Your donation will be appreciated!