cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
daveslc
Level 1

Importing a CSV file, it maps headings correctly and shows all of the data to be imported okay, but when it actually tries to import it just spins never finishing, help?

Importing vendor data from a QB-exported spreadsheet from years ago...but it all matches up after some massaging of column names, etc. but will not import. I've reduced the number to 10 lines and still the same.
1 Comment 1
RogelioL
QuickBooks Team

Importing a CSV file, it maps headings correctly and shows all of the data to be imported okay, but when it actually tries to import it just spins never finishing, help?

I appreciate you sharing details of your concern, Dave. It's important that your CSV file imports smoothly, especially when dealing with vendor data from older exports. Allow me to guide you through resolving this issue.

 

The spinning issue you're experiencing often occurs when there's a mismatch or formatting problem in the CSV file.

 

To rectify this, let's first check the file for formatting issues. When importing contacts from a spreadsheet, ensure the following:

 

  • Column headers are placed in the first row.
  • All contacts are located on Sheet 1 of the spreadsheet.
  • The spreadsheet is free from formulas, charts, or blank rows.
  • There are no errors in the spreadsheet, such as #REF!, #NAME?, #N/A, or #VALUE!
  • Names in the spreadsheet do not contain colons (:) or quotation marks (").

 

Second, let's review and simplify the data:

 

  1. Even though you’ve reduced the number of lines, ensure the file size doesn't exceed the 2MB limit and that the content is clean and error-free.
  2. Limit the import to one or two lines to test functionality. If successful, gradually increase the number.
  3. For added peace of mind, verify again that the column headers match QuickBooks' accepted field names exactly.

 

After that, let's import the file again:

 

  1. Navigate to the Gear icon, then click Import Data.
  2. In the "What do you want to import?" field, choose Vendors.
  3. Select Upload a file to import data.
  4. Follow the prompts carefully to map your data and proceed with the import.

 

Alternatively, you can perform the importing process using an incognito window or other supported browsers to rule out the possibility of problems induced by cache or related issues. These are the shortcut keys:

 

  • Mozilla Firefox: CTRL + Shift + P
  • Microsoft Edge: CTRL + Shift + N
  • Google Chrome: CTRL + Shift + N
  • Safari: Command + Shift + N

 

For more details about importing data, please refer to these articles:

 

 

However, if the problem continues, I suggest reaching out to our QuickBooks Support Team. They have the resources needed to access your account and help identify the root of your issue.

 

Once your data is successfully imported, you can review your vendor list and verify that all entries are accurate. Additionally, you might consider exporting a backup of the updated vendor list for safekeeping.

 

You might also want to take a look at this article to discover how to generate a report that includes totals for each vendor: Run a report with vendor totals in QuickBooks Online.

 

Moreover, did you know that we offer QuickBooks Live Expert Assistance? Our experts are ready to review your vendor data and provide hands-on support, ensuring everything is set up correctly in QuickBooks. It's an excellent way to streamline your workflow and focus on your business priorities.

 

If there's anything else you'd like to clarify about importing data or vendor management, I'm here to assist. I wish you success in organizing your records.

Log in today
Get expert help and peer support to tackle all your QuickBooks questions effortlessly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up