Nick Kewney

Software Architect & Product Builder

Importing CSV to Excel

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’. Test
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…’ Step 2
Click ‘Next’ and select your delimiting character. In this case, it’s a semi-colon ’;’ Delimiting character
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.
Finish the process

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on whatsapp
WhatsApp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.