Importing CSV data into Excel

By using Excel's text import wizard, you can ensure data in *.csv is correctly imported into Excel.

  1. 1. Download and save your *.csv file to your chosen location.

  2. 2. Start Excel with a blank workbook open.

  3. 3. Select 'Data' on the ribbon, and then 'From Text'. (If the menu options are greyed out this could be because you do not have a workbook open).

    Importing CSV to Excel

  4. 4. Browse for the *.csv file you want to open, and click 'Import'.

  5. 5. In the Text import wizard, ensure the 'Delimited' option is selected. Click Next.

    Importing CSV to Excel

  6. 6. In the delimiters section, tick 'Comma'. The text qualifier box should show the double-quote symbol. Click Next.

    Importing CSV to Excel

  7. 7. Mark every columns as 'Text'. The first column only will initially be highlighted. Move the horizontal cursor as far as it will go to the right; then, holding the shift key down, click the very last column heading. You should now have every column highlighted. Click the 'Text' data format. It will now say 'Text' in the header of every column. Click Finish.

    Importing CSV to Excel

  8. 8. 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.

  9. 9. 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.

Last updated on Jun 26, 2017
Schedule it Ltd

Subscribe to our newsletter and receive our free scheduling tips and articles to help you improve the planning in your business. Unsubscribe anytime.

Login Support and Help
Register Blog
Features Privacy Policy
Online Pricing Terms and Conditions
On-Prem Pricing Industry Sectors
Latest Version Reviews and Feedback
Live Webinar Status
Web App Team Scheduling
iOS App Employee Planning
Android App Customer Scheduling
Zapier App Engineer Scheduling

Start Your Free Trial Today

Copyright © 2003-2020 Schedule it Ltd. All rights reserved.
Schedule it on LinkedIn   Schedule it on Twitter   Schedule it on YouTube   Schedule it on Facebook
Join Us - Live Webinar