cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

How to upload excel data file or csv file into QuickBooks? I would like to avoid manual input entry into QuickBooks Pro due to many transaction volume. Is it possible by QuickBooks program or have to use third party program? Thank you.

Solved
Best answer 09-26-2019

Best Answers
Highlighted
Moderator

How to upload excel data file or csv file into QuickBooks Pro ?

You can import Excel or CSV file data to your QuickBooks Desktop Pro, sukitw.

Before you can start to import your file, you'll need to install the QuickBooks Import Excel and CSV toolkit. Here's how:

  1. Open the file download window for the toolkit.
  2. Click Save.
  3. Double-click QuickBooks_Import_Excel_and_CSV.exe on your Windows desktop to open the WinZip Self-Extractor window.
  4. Select Browse.
  5. Choose the folder where you want to install the toolkit, then OK.
  6. Select Unzip to extract the contents, and then click Close to close the WinZip Self-Extractor window.
  7. Open the QuickBooks Import Excel and CSV folder from the location you selected in step 4.

These articles contain detailed steps on how you can import the data successfully: https://quickbooks.intuit.com/community/Getting-Started/Import-export-CSV-files/m-p/201366 and https://quickbooks.intuit.com/community/Getting-Started/Import-export-overview/m-p/203723.

Please let me know if you have additional questions, I'll here to help you.

View solution in original post

43 Comments
Highlighted
Moderator

How to upload excel data file or csv file into QuickBooks Pro ?

You can import Excel or CSV file data to your QuickBooks Desktop Pro, sukitw.

Before you can start to import your file, you'll need to install the QuickBooks Import Excel and CSV toolkit. Here's how:

  1. Open the file download window for the toolkit.
  2. Click Save.
  3. Double-click QuickBooks_Import_Excel_and_CSV.exe on your Windows desktop to open the WinZip Self-Extractor window.
  4. Select Browse.
  5. Choose the folder where you want to install the toolkit, then OK.
  6. Select Unzip to extract the contents, and then click Close to close the WinZip Self-Extractor window.
  7. Open the QuickBooks Import Excel and CSV folder from the location you selected in step 4.

These articles contain detailed steps on how you can import the data successfully: https://quickbooks.intuit.com/community/Getting-Started/Import-export-CSV-files/m-p/201366 and https://quickbooks.intuit.com/community/Getting-Started/Import-export-overview/m-p/203723.

Please let me know if you have additional questions, I'll here to help you.

View solution in original post

Highlighted
Anonymous
Not applicable

How to upload excel data file or csv file into QuickBooks Pro ?

hi @Sukitw ,

Another option, you may utilize the trial period of the 3rd party tools to import your transaction.

https://transactionpro.grsm.io/fl-qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

Highlighted
Level 3

How to upload excel data file or csv file into QuickBooks Pro ?

Do you happen to know if there is a MAC toolkit?

Highlighted
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Hi Tiffiny Taylor Krugh,

 

At this time, the Mac toolkit is still unavailable in QuickBooks Desktop. As a workaround, you can go to Utilities and select the .IIF option to import the file. Let me guide you how.

  1. Click File on the upper-part.
  2. Select Utilities.
  3. Choose .IIF files.

Here's an article for more information: Export To QuickBooks For Windows Or Mac (IIF).

 

Please let me know if you need anything else. I'll be right here to help.

Highlighted
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Can payroll hours be imported from an csv formatted file , for payroll processing ???

Highlighted
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Hello there, @curtpacpa52.

 

You can manually enter the payroll hours using the weekly timesheet since the option to import payroll hours is not available. Let me show you how.

 

In your QBDT account:

  1. Go to the Employees menu, then select Enter Time.
  2. Choose Use Weekly Timesheet.
  3. Select the name of the employee from the Name drop-down arrow.
  4. Fill in the needed information.
  5. Once done, click Save & Close.

I've got you this article for more details: Create and Print Timesheets.

 

Also, I'm adding this helpful article that can help guide you in case you want to create paychecks based on timesheet hours: Create Paychecks Based on Timesheet Hours

 

Should you need further assistant, feel free to leave a comment below. I'll be around to help.

Highlighted
Anonymous
Not applicable

How to upload excel data file or csv file into QuickBooks Pro ?

@curtpacpa52 ,

Utilize the trial period of 3rd party data importing tool as I have mentioned earlier. You can import Time Tracking data into QuickBooks Desktop or Time Activities data into QuickBooks Online.

https://transactionpro.grsm.io/fl-qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

Highlighted
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

Moderator 

 

 

Highlighted
Moderator

How to upload excel data file or csv file into QuickBooks Pro ?

Hello Heather,

 

Yes, an Excel CSV file is also available for bank and credit card transactions manually.

 

We have an article with the complete guide on how to import transactions manually. Please check it out: Import bank transactions using Excel CSV files

 

Let us know if you have any questions. We are here to help. 
 

Highlighted
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Can these same steps be used for the same purpose to import an excel spreadsheet for payroll in QuickBooks Online?

Highlighted
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

Hi there, CDBortle. 

 

We're only import Bank, Customers, Vendors, Chart of Accounts and Product and Services data. You'll want to look into our third-party apps to bring your payroll transactions into QBO while the option is unavailable.  

 

You can check out our available app through our Apps Center. Search for a keyword like import payroll. Select the app to review how it works with QuickBooks and how to avail it. 

 

Let me know if you need more help with managing your data. 

Highlighted
Level 11

How to upload excel data file or csv file into QuickBooks Pro ?

@CDBortle 

Utilize the importer tool untuk migrate payroll data as JE into QBO

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

Highlighted
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

I don' t think this is a valid solution for non list entries such as Bank and Credit card transactions.

Highlighted
QuickBooks Team

How to upload excel data file or csv file into QuickBooks Pro ?

I understand that you want to import non bank/credit card transactions, dwkrueger.

 

We also want QuickBooks works to all businesses. The ability to import non bank transactions will be a great feature. I know our engineers would be glad if I'll send feedback about this. 

 

In the meantime, I suggest using a third-party software who has this feature. You can visit our QuickBooks Apps Store as suggested by my colleague.

 

Please reply again if you have other concerns. I'm always available to help you.

Highlighted
Level 11

How to upload excel data file or csv file into QuickBooks Pro ?

@dwkrueger 

Explore the importer tool as I have mentioned above. You may migrate many transaction type into QB.

Highlighted
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

Hi there... I am trying to get data from my app into my customers' QB Desktop instances.  (1) Can you point me to any documentation of how to format an Excel file to import transactions into QuickBooks Desktop -- not an accountant's license, but a business owner's license?  All of the documentation I've seen online says that IIF is deprecated, and then they point to the home page of the SDK, which doesn't really help answer the question.  (2) Is there any way to send data into a Desktop instance thorugh APIs, or is the deprecated IIF format the only way? (3) Where is there documentation of how to format transactions in IIF?  Thanks!

Highlighted
Level 11

How to upload excel data file or csv file into QuickBooks Pro ?

Highlighted
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

This does not answer the question.  This is just an ad for someone selling this software.

Highlighted
Level 11

How to upload excel data file or csv file into QuickBooks Pro ?


@maxcpq wrote:

(2) Is there any way to send data into a Desktop instance thorugh APIs, or is the deprecated IIF format the only way?


I was answering your second question. If you prefer to develop your own migration tool, you should go to the Developer forum.

https://blogs.intuit.com/blog/

 

Highlighted
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

I meant is there any documentation about using a QuickBooks API.  I know there are plenty of 3rd-parties selling software.  Thank you, anyway...

Highlighted
Level 1

How to upload excel data file or csv file into QuickBooks Pro ?

Did you find a solution to this?


@maxcpq wrote:

I meant is there any documentation about using a QuickBooks API.  I know there are plenty of 3rd-parties selling software.  Thank you, anyway...


 

Highlighted
Moderator

How to upload excel data file or csv file into QuickBooks Pro ?

Welcome to the thread, @Liberty99. I want to ensure that you get the best support. 

 

We have a separate online forum called Intuit Developer Community where you can post API questions. Our team of developers can provide more insights specific to QuickBooks Online API concerns. To contact them, see this link: https://developer.intuit.com/app/developer/homepage.

 

If you have any other follow up questions, let me know by commenting below. I'm always here to answer it for you. Have a great day!

Highlighted
Level 2

How to upload excel data file or csv file into QuickBooks Pro ?

NONEOF THIS WORKS, there is no import function!!!!! Why is Quickbooks SO ARCHAIC?????

 

Highlighted
Level 11

How to upload excel data file or csv file into QuickBooks Pro ?

@megrussell 

If you are not familiar with IIF, utilize the trial period of this 3rd party migration tool

https://transactionpro.grsm.io/qbd