How to Import CSV Formatted Data to Excel


If you're encountering issues with importing Qualaroo CSV data into Excel, this step-by-step guide will help you resolve them.


How to Import CSV Formatted Data Into Excel


NOtE: 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" from the header menu. Go to "Get External Data" and select "From Text" in the menu. (If the menu options are greyed out, this could be because you do not have a workbook open).


Disallowed Key Characters.



Step 4: Browse the CSV file you want to open and click "Import."


Select File to Import


Step 5: The Text Import Wizard will pop up. Ensure the "Delimited" option is selected. Click Next.


Select Delimited


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


Select Comma


Step 7: Mark every column as "Text." Initially, the first column will be highlighted.


Select every column


Step 8:

  • Scroll horizontally to the last column.
  • Hold shift.
  • Click on the heading to select every column.


Every column is highlighted. Click the "Text" data format. It will now say "Text" in the header of every column. Click Finish.


Mark every column as Text


Step 9: It may ask you, "Where do you want to put the data?" It will allow you to select any cell on the blank worksheet to determine where the data should go. Click "OK" to proceed.


Select  the cell


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.


That is all about importing CSV formatted data into Excel. If you encounter any issues or have any questions, feel free to contact our support team.

© 2005 - 2024 ProProfs