- 1). Add a row above the top row of your Excel spreadsheet. Type headers for each of the columns based on the type of data your Excel spreadsheet contains. Refer to Quickbooks' four import types (see "Resources") to correctly organize your data. The four types are "Customer," "Vendor," "Account" and "Item."
- 2). Save your Excel spreadsheet.
- 3). Launch Quickbooks. Click "File" in the main menu. Choose "Import" and then select "Excel Files."
- 4). Click the "Set up Import" tab. Browse for the Excel file you saved in Step 2.
- 5). Select the sheet you want to import in the dropdown menu below "Choose a sheet in this Excel workbook." Put a check mark in the box next to "This data file has header rows" if that is the case.
- 6). Click the mapping dropdown to select an existing mapping format. This matches your data with the Quickbooks software.
- 7). Click the import type dropdown menu in the window that appears that corresponds with how you set up your data in Step 1. Click a data type in the left column. A dropdown menu will appear with the headers that you created in Step 1. Choose the header that matches the Quickbooks data type. Click the "Save" button.
- 8). Click the "Import" button.