Skip to main content
A
AccountantLex
October 17, 2022
Solved

Cannot paste multiple entries into Quickbooks from Excel in the Add/Edit Mu;tiple List Entries window

  • October 17, 2022
  • 1 reply
  • 0 views

Hi guys, I am trying to bulk add service items from Excel into the Add/Edit Multiple List Entries window. From all the videos ive watched, people are able to copy a large amount of data in Excel and simple paste it into this window. However when I copy a couple of lines in Excel, it only pastes the first cell into the Add/Edit Multiple List Entries window?? All the other copied cells just vanish.

Any ideas?

 

Thanks!

Best answer by AccountantLex

Hi, @AccountantLex. I appreciate you for getting back. Let me share additional insights about the troubleshooting steps provided.

 

I appreciate you for performing the verify and rebuild tool to isolate the issue. Running it fixes the commonly known data issues within your company file that may cause the behavior you're getting when copying and pasting multiple entries into QuickBooks from Excel.

 

Since you don't see any errors in your file after the process, I'd recommend opening your QuickBooks Desktop (QBDT) file as a master admin to avoid user restrictions. Once opened, try to paste your entries again. I'm adding this article as your reference: Add and edit multiple customers, vendors, and items.

 

If you're getting the same result, you can proceed with the succeeding solutions provided by JamaicaA above. You can also repair QuickBooks if needed.

 

Let me know if you have other questions while adding multiple list entries in QBDT. I'm always here to help. Keep safe!


Thank you for the help Angelyn_T.

I think I found the issue!

Its quite silly, but I was copying from an Excel file located on my local machine onto the QB file which is located on a remote desktop. I have no clue why it would only copy one cell but there it is.

I saved the Excel file onto the remote desktop as well (I couldn't do that previously as I wasn't admin and had to ask for the permissions first) and copied and pasted and voila :-)

1 reply

J
JamaicaA
October 17, 2022

I appreciate the steps you've performed to add your items into the program, @AccountantLex. I’m here to provide additional information that will help clear things up.

 

Yes, we can copy and paste list information from Excel directly into QBDT using the Add/Edit Multiple List entries window. Since you’re experiencing issues with the succeeding cells, perform some troubleshooting steps. Let’s start with verifying and rebuilding your data. This process scans your company files for errors or data damage.

 

Here’s how:

 

  1. Go to the File then Utilities. Select Verify Data.
  2. Wait for it to load.
  3. Click File again, Utilities, then Rebuild Data.
  4. Press OK when you get the message Rebuild has completed.

 

For other damage troubleshooting steps for Windows, feel free to check out this article: Verify and Rebuild Data in QuickBooks Desktop

 

If you get the same result after running those troubleshooting steps, I suggest using QuickBooks File Doctor. To begin, download and install the most recent version (1.4.0.0) of QuickBooks Tool Hub. Then let’s install the program by opening the downloaded file (QuickBooksToolHub.exe) and follow the on-screen instructions.

 

To open the tool hub, double-click the icon on your Windows desktop. We recommend running QuickBooks File Doctor on Windows 10, 64-bit. Then, run the Quick Fix my File utility by following these steps:

 

  1. Select the Company File Issues tab from the tool hub.
  2. Click Quick Fix my File from the drop-down menu.
  3. Tap OK to launch QuickBooks.

 

If the issue persists, you’ll want to proceed to Step 3 to fix your company file and network issues.

 

You’ll want to consider importing the items using an IIF file. I’ll show you how:

 

  1. Go to the File menu then Utilities.
  2. Pick Import then IIF Files.
  3. Use the Import it for me. I'll fix it later link at the bottom.
    https://lithium-response-prod.s3.us-west-2.amazonaws.com/intuit.response.lithium.com/RESPONSEIMAGE/23cfe946-b8e3-42b4-9184-2320bcb3ed2e.default.PNG
  4. Once done, press Import IIF.

 

For the complete process of the Advance Import, see this link: Import or export MS Excel files

 

I also recommend visiting our website for more tips and resources you can use in the future: QBDT self-help articles.

 

Let me know if you have other importing or copying and pasting items concerns or questions about managing your business's growth and transactions in QBDT. I'll gladly help. Take care.

    A
    AccountantLexAuthor
    October 18, 2022
    Original commenter did not share additional details
    Terms & ConditionsAccessibility statement