Be sure you added your data to the specially formatted spreadsheet and saved it before you start this task.
Note: We recommend that you print this topic before you start.
Follow these steps to resume working on a spreadsheet you previously added data to, and to add data from the spreadsheet to QuickBooks.
To do this task
If the Add Your Excel Data to QuickBooks window is not open, go to the File menu and select Utilities.
Select Import and then click Excel Files. The Add Your Excel Data to QuickBooks window opens.
To tell QuickBooks where you saved the spreadsheet that contains your data, click Browse or Find It Now. (The button you see depends on when you added your data to the spreadsheet.)
Find the spreadsheet you pasted your data into and select the file so the name shows in the Browse field.
(Optional) To open the spreadsheet and continue working on it, click Edit My Saved Spreadsheet. Make changes and save the spreadsheet. You can save and close the spreadsheet and return to it again to add and change data.
After you've located and selected the spreadsheet, click Add My Data Now. When the add process is finished, you'll see a summary of the results.
Note: Checkmarks show the steps you've completed.
Next, you'll review the results of the data you added. If there were errors, you can fix them.
What to expect when using a formatted spreadsheet
Select the type of data to add
Review the results of data you added
What to do if you can't find your saved spreadsheet
Add data from sources other than Excel
Use the Advanced Import feature
Copy and paste your data from Excel directly into QuickBooks