Exporting form to Excel? - InfoPath Dev
in

InfoPath Dev

Exporting form to Excel?

Last post 01-23-2014 02:07 PM by Kandee. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 09-14-2012 07:50 AM

    Exporting form to Excel?

    Is it possible to save an InfoPath form in Excel format?  I know a form saves as XML but I have a customer who needs the data from an InfoPath form in an Excel file.  Anyone know if or how this can be done?

     

    Thanks!

  • 09-14-2012 09:37 AM In reply to

    Re: Exporting form to Excel?

    One can save Infopath XML data forms as .XML file or export to Excel: 

     on ribbon File > Save & Send > Export to Excel (Export form data to an Excel Workbook )

    •  Export data from single or multiple forms
    • Use Excel to analyze data

    launches Export to Excel Wizard. 

    Vice versa, In Infopath Designer 2010, File > New > Convert Existing Form

    • Creates a new form template based on either a Word or
      Excel file. InfoPath creates the underlying data structure
      based on the layout of the original form, updating the data
      structure based on any changes you then make to the form
      layout.
       

    permits to import Excel workbook into Infopath form

    Gennady Vanin (Novosibirsk) --- Геннадий Ванин (Новосибирск)
  • 09-14-2012 10:47 AM In reply to

    Re: Exporting form to Excel?

    Thanks for your help.  It works!

  • 01-23-2014 02:07 PM In reply to

    • Kandee
    • Not Ranked
    • Joined on 01-23-2014
    • Posts 1

     I am currently  using Ms office 2010 in Windows 7 Professional. I tried to export a form on Info Path to Excel  I did the selections as follows.

    • Only form data in the current view except tables and lists

    When I click next, there is another list of things appeared with check against them and asked to select the fields to be exported. I selected all fields since I need all fields from the form to be exported to excel. When I click next there was an error message popped up saying that "Only 256 fields can be uploaded one time. Modify your selection to continue." Could you please help in exporting the form data at once without selecting field by field every time which is time consuming and hefty job.

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.