I was wondering if it's possible to compile data submitted in infopath forms into one central area. I have a sharepoint form library where the forms get submitted. Can I take the data in each form and somehow publish it to one document such as an Excel spreadsheet? Ultimately I'd like to be able to do this without having to go into each form. Thanks.
Hi, have you publish all the field you want to display on your excel speadsheet ?
Have you try to just export your document library using Sharepoint -->Action-->Export to speadsheet ?
I haven't published anything but and I was trying to find a way that I could publish the data from each form into one document, not each form into a different document.
Yes sure try to publish all infopath field on SharePoint column and after that export your library on speadsheet. It will centralized your forms information in one excel document.
I think it's the easiest way to do that.
Thanks Potemkine. That worked just fine. I thought that you had to go into each document in order to export. I didn't know the export would work from the default view of the library. Thanks.