Exporting Raw Data from Intuit Online Payroll

Hey there, calebgroup.

I'm here to help you download all the employee's information into a CSV file. You can Export the employee's information via Excel and convert it into a CSV file.

Here's how:

1. On the Intuit Online Payroll screen, go to the Reports tab.
2. Select the Employee Details.
3. Click View in Excel.
4. Once exported into Excel, you can convert it into a CSV file when saving it

Once done, you can start importing the data into another program using that file. You can go through these articles to know more about what other data you can export in QuickBooks. Also, this will provide you more information on what other services you can add to your Intuit Online Payroll account:

IOP vs QBOP

Export your reports to Excel from QuickBooks Online

Feel free to comment below if you need additional assistance. I'd be more than willing to lend you a hand.

Thank you for your help RoseMarjorie. However, the problem is that the way that IOP allows you to download in Excel has leading spaces, it outputs the data in stacked rows and makes it very difficult to manipulate for being able to use the data in other ways. Could I request that IOP allows me to download the info in text (csv) or excel format that isn't as complicated?

Hello there, @calebgroup. 

Thanks for following up on this thread. 

At this time, IOP doesn't have the option to change how it exports to Excel. I'm going to submit feedback to our Product Development Team to review and consider making this a feature soon. 

For now, once the information is in Excel, you have the ability to edit the information from there. For more information with exporting IOP to Excel in QuickBooks Online, you can check out this article: Setup export of IOP data to QuickBooks Online (QBO). 

If you have any more questions or concerns, I'm always here to help. Have a safe and productive week ahead!