Importing CSV Formatted Data to Excel

Is your Qualaroo data showing up incorrectly within your Excel file?

Look no further, we have a step by step guide to help you through this process. By highlighting the settings required you will be able to import Qualaroo CSV data into Excel in just amount of short time.

Steps to Import

To import CSV data into Excel, use Excel's Text Import Wizard to ensure data in CSV is correctly imported into Excel and leading zeros are not dropped. 

Step 1. Download and save your CSV file to your chosen location.

Step 2. Start excel with a blank workbook open.

Step 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).

Step 4. Browse for the CSV file you want to open, click 'import'.

Step 5. The Text import wizard will pop up. Ensure the 'Delimited' option is selected. Click Next.

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

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

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

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

We hope this article has been helpful! If you have any questions or need anything else, please feel free to reach out to us at support@qualaroo.com.