--- title: How Do I Import an Excel File into an AQ Project? description: Copy Excel spreadsheet rows into an AQ project, map the spreadsheet columns to AQ project columns, and match the manufacturer names. --- [Skip to content](https://train.singerequipment.com/knowledge-base/how-do-i-import-an-excel-file-into-an-aq-project#main-content) English Show submenu for translations [![SINGER](https://train.singerequipment.com/hubfs/images/logos/singer-logo.svg)](https://train.singerequipment.com/knowledge-base?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations How can we help you? - There are no suggestions because the search field is empty. 1. [Singer Equipment Knowledge Base](https://train.singerequipment.com/knowledge-base?hsLang=en) 2. [Auto Quotes](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en) 3. [Projects & Spreadsheets](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#projects-spreadsheets) July 16, 2026 # How Do I Import an Excel File into an AQ Project? ## Copy spreadsheet rows into an AQ project, map the Excel columns to AQ project columns, and match the manufacturer names.  **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. ![IMAGE\_1\_AQ\_Project\_Search\_Bar\_Paste](https://train.singerequipment.com/hs-fs/hubfs/IMAGE_1_AQ_Project_Search_Bar_Paste.png?width=670&height=141&name=IMAGE_1_AQ_Project_Search_Bar_Paste.png) ### 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. ![IMAGE\_2\_AQ\_Import\_Mapping\_Columns](https://train.singerequipment.com/hs-fs/hubfs/IMAGE_2_AQ_Import_Mapping_Columns.png?width=668&height=417&name=IMAGE_2_AQ_Import_Mapping_Columns.png) 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. ![IMAGE\_3\_AQ\_Set\_Custom\_Column\_Header](https://train.singerequipment.com/hs-fs/hubfs/IMAGE_3_AQ_Set_Custom_Column_Header.png?width=495&height=170&name=IMAGE_3_AQ_Set_Custom_Column_Header.png) 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**. ![IMAGE\_4\_AQ\_Match\_Manufacturers](https://train.singerequipment.com/hs-fs/hubfs/IMAGE_4_AQ_Match_Manufacturers.png?width=646&height=550&name=IMAGE_4_AQ_Match_Manufacturers.png) - [Hubspot](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#main-content) - [Getting Started and Profile](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#getting-started-and-profile) - [Help Desk](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#help-desk) - [Companies and Accounts](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#companies-and-accounts) - [Contacts](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#contacts) - [Activities](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#activities) - [Views and Filters](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#views-and-filters) - [Assemble & Hold](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#assemble-hold) - [Outlook Integration](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#outlook-integration) - [Deals](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#deals) - [Leads](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#leads) - [Tickets](https://train.singerequipment.com/knowledge-base/hubspot?hsLang=en#tickets) - [Prelude](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#main-content) - [Prelude Basics](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#prelude-basics) - [Sales Order Entry](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#sales-order-entry) - [Sales Order Inquiry](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#sales-order-inquiry) - [Sales Order History Inquiry](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#sales-order-history-inquiry) - [Customer, Vendor, and Inventory Inquiry](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#customer-vendor-and-inventory-inquiry) - [Order Tracking and Expediting](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#order-tracking-and-expediting) - [Order Acknowledgements](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#order-acknowledgements) - [Returns](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#returns) - [Star Commands](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#star-commands) - [Quotes and Pricing](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#quotes-and-pricing) - [Credit Memos](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#credit-memos) - [Customer Setup and Payment](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#customer-setup-and-payment) - [Sales and Customer Service Resources](https://train.singerequipment.com/knowledge-base/prelude?hsLang=en#sales-and-customer-service-resources) - [Setvi](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#main-content) - [Account Settings and Support](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#account-settings-and-support) - [Contacts and Groups](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#contacts-and-groups) - [Orders, Order Health, and Invoices](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#orders-order-health-and-invoices) - [Retention Intelligence](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#retention-intelligence) - [Resources and Files](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#resources-and-files) - [Presentations](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#presentations) - [Quoting](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#quoting) - [Sharing Content and Tracking Engagement](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#sharing-content-and-tracking-engagement) - [Setvi Administration](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#setvi-administration) - [Campaigns](https://train.singerequipment.com/knowledge-base/setvi?hsLang=en#campaigns) - [Auto Quotes](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#main-content) - [Getting Started](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#getting-started) - [Catalog Setup](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#catalog-setup) - [Quoting Basics](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#quoting-basics) - [Project Management](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#project-management) - [Projects & Spreadsheets](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#projects-spreadsheets) - [Freight & Order Tracking](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#freight-order-tracking) - [Reporting & Analytics](https://train.singerequipment.com/knowledge-base/auto-quotes?hsLang=en#reporting-analytics) - [Drive Communication Questions](https://train.singerequipment.com/knowledge-base/drive-communication-questions?hsLang=en#main-content) - [Deliveries](https://train.singerequipment.com/knowledge-base/drive-communication-questions?hsLang=en#deliveries) - [Sales Support](https://train.singerequipment.com/knowledge-base/sales-support?hsLang=en#main-content) - [Shipping](https://train.singerequipment.com/knowledge-base/sales-support?hsLang=en#shipping) - [Internal protocols](https://train.singerequipment.com/knowledge-base/sales-support?hsLang=en#internal-protocols) [![SINGER](https://train.singerequipment.com/hubfs/images/logos/singer-logo.svg "SINGER")](https://train.singerequipment.com/knowledge-base?hsLang=en) Copyright © 2026, Singer Equipment Co