Item List Import From Excel

Hi, @Ty00. 

Thanks for reaching out to us. I'm here to share some details about importing list from Excel to QuickBooks Desktop (QBDT) 2016.

You should be able to export the report since QBDT 2016 is compatible with Office 365. Since you've encountered an error while importing the list,  it can be due to the following:
 

• Excel is not installed on your computer.
• It's installed across a network.
• The local Excel installation is damaged.
• QuickBooks is an outdated version.

If Excel is installed on your computer and there are no issues. You can also check the format when importing list. If the issue persists, we could have tried to update QuickBooks to the latest release.  However, 2016 QuickBooks is an outdated one, and it won't receive any updates. 

If you'd like to upgrade your QuickBooks Desktop to the latest version and continue to enjoy online services and importing data, you can check this article for more details: Upgrade your QuickBooks Desktop subscription.

Also, read these guides to learn more about import or export information with QuickBooks Desktop:

• Import and export data in QuickBooks Desktop
• Fix export to Excel issue in QuickBooks Desktop
• Import/export CSV files

Helping you is our top priority. Just hit the Reply button if you have other concerns with importing or with QuickBooks. The Community is always available for you. Stay safe.

Hello i will give it a try, thanks

Another question, Can I import Custom fields from excel to QuickBooks item list?

@Ty00 

There is no custom field feature in the Item List

Hello Ty00.

I agree with Fiat Lux -ASIA. As of now, the option to import a custom field is unavailable in QuickBooks Desktop. I'm here to expand more about it.

Aside from transactions, below are some of the lists of data that we can import into your QuickBooks file:

• Chart of Accounts
• Employees
• Vendor types
• Items
• Shipping methods
• To dos
• Notes
• Sales tax codes
• Sales tax codes
• Other names

With that, I suggest sending feedback to our developer's team. They'll collate ideas from other customers about the functionality of the feature you shared. Here's how to send one:

1. From the Help menu, select Send Feedback Online.
2. Select Product Suggestion.
3. Type in a few words about the feature.
4. Click Send Feedback.

Furthermore, you can check these articles to know the things to keep in mind when importing:

• Things to keep in mind when you import and export data
• Import or export MS Excel files

I'm always around whenever you have concerns about importing data.

Hello,

In my Quickbooks 2016, when you create a new item list on the right side of the pop-out window there is a section where you can enter 4 customs fields and link them to be shown in the actual "quote" window. However I cannot map any custom fields in the Excel item import, just the standard fields.

Hi @Ty00 

I have a solution for you if you are looking to import Custom Fields into a QuickBooks Item list.  We have a data import utility called Zed Axis that you can find in the Apps for QuickBooks Desktop center that does support importing Custom Field data into the Item list in batch, you can see a pre-recorded demonstration of that here as well as detailed instructions on how to do that here.

I hope that provides you a quicker way to batch import custom field data.

Zed