Skip to main content

How to send parsed data to Excel files on OneDrive

Docparser provides the option to automatically send data to an Excel file stored within a OneDrive account with a simple integration that takes only a few minutes to set up.

Getting Started

Once you have your parsing rules set up, click the Export pulldown button in your parser (on the left Menu) and then Integration. You will see the Microsoft Excel option.

The next step will be to connect your OneDrive account with Docparser. To do this click the first drop-down and select "Add Account". The page will redirect you to log in with Microsoft and authorize the connection.

Authorize OneDrive account for Docparser integration via Microsoft login

Now you can select from an existing Excel file or create one. If the existing spreadsheet is empty you will be prompted to input column headers and add additional column headers. If no rules are showing up, please re-queue the documents to update. For prefilled spreadsheets, the first column will be read for each field automatically.

All you need to do is match each column to a parsing rule in Docparser, then hit "Save & Test". After a successful test, the system will notify you, and future documents will automatically process and add to your spreadsheet on OneDrive.


Matching Excel columns to Docparser rules in integration setup

Quick Guide

  • Head to the integrations page in your parser and select Microsoft Excel.
  • Add your account using the first drop-down
  • Match your columns with rules in Docparser
  • Save & Test
Was this article helpful?
0 out of 0 found this helpful

Still stuck?

Send us your parser name and a sample document.

Submit a request