››

How to Import CSV Formatted Data to Excel

If you're having trouble importing Qualaroo CSV data into Excel, this step-by-step guide will help you resolve the issue.

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

Step 4: Browse the CSV file you want to open and 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 column as "Text." Initially, the first column will be highlighted.

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.

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.

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.