How Do I Import an Excel File into an AQ Project?
Step 1 — Copy the contents of the Excel spreadsheet.
Do not include the column headers.
Highlight all of the spreadsheet rows except the column headers, if there are any, and then press Ctrl+C to copy.
Step 2 — Paste the contents into the AQ project.
Go to your AQ project.
Click the search bar and press Ctrl+V to paste.
Step 3 — Map the spreadsheet columns.
You will get an Excel spreadsheet mapping dialog.
This allows you to map the columns from your spreadsheet to the proper AQ project columns.
If you have a column in your Excel spreadsheet that does not have a corresponding AQ field or column, but you want the content of that column to appear in the AQ spreadsheet, select one of the CustomColumns.
You can rename that column in the column header of the AQ project after the import.
Once you have selected all the appropriate column headers, click OK.
Step 4 — Match the manufacturer names.
Next, you will get a Match Mfrs dialog.
The manufacturers’ names from the spreadsheet you are importing from will be on the left, and the suggested matching manufacturers from AQ will be on the right.
You must make sure the proper AQ manufacturer name is there.
If not, re-type the name in the right column and select from the AQ manufacturer names you see.
Click OK.
