0

I've created a form in Excel which has been filled out by many people. Now I have ten files containing this form which have been filled in and I'd like to compile all the results into one Excel file. How can I do this?

2
  • 2
    Welcome to Super User! This question is really broad and unlikely to get useful answers as is. Could you please provide a sample of what the form data looks like and what kind of output format you would like?
    – Excellll
    Jul 13, 2014 at 23:30
  • Hello @Excelll, My form was created using the form tools in excel. It has radio buttons, checkboxes, listboxes and text fields. I'd like to pull the data from multiple filled in forms into a database structure.
    – Samantha
    Jul 16, 2014 at 22:27

1 Answer 1

0

I would use the Power Query Add-In for this. You can start a Query by importing all the files in a Folder. As long as they have a consistent format you will get a single stream of data with all the rows from each file appended.

http://www.excelguru.ca/blog/2013/11/26/from-txt-files-to-bi-solution/

You can send the output from a Query to an Excel Table.

Power Query has lots of other functionality to transform and combine data along the way, if you need to.

Not the answer you're looking for? Browse other questions tagged .