Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Rubielyn_J
QuickBooks Team

Reply to message

Let me provide some insights about importing Excel data in QuickBooks, @Anonymous.

 

There are several options available when importing Excel files from QuickBooks. If you wish to utilize the Standard import, here's what you need to do:

 

  1. Proceed to the File menu and select Utilities.
  2. Select Import and then choose Excel Files.
  3. If you get the Add/Edit Multiple List Entries window, click No.
  4. Follow the wizard in importing files.
    • Select the type of data.
    • QuickBooks opens a formatted excel spreadsheet. Once you have entered your information, saved the file, and closed it, you will be given the option to Add My Data Now.
    • Review results and view Data in QuickBooks.
    • Select Close when done.

 

For detailed info, please check out this article: Import or export MS Excel files. It also contains steps for other option in importing Excel file. 

 

You can also use CSV file or a third party application in importing your file in QuickBooks. 

 

Additionally, let me share this link to help mport or export info with QuickBooks Desktop: Import and export data in QuickBooks Desktop.

 

Feel free to leave a comment below if you have further concerns with importing invoices using Excel file. I'll be happy to help. Keep safe!

Need to get in touch?

Contact us