Export drupal 6 webform submitted data to excel

Thu, 09/29/2011 - 22:20 | by admin

There are instances where you need to export the webform data to excel or csv files.

SELECT t1.sid, t1.cid, t2.form_key, t1.data
FROM webform_submitted_data AS t1
INNER JOIN webform_component AS t2 ON ( t1.cid = t2.cid
AND t2.nid =<nid>)
WHERE t1.nid =<nid>

Replace <nid> with your actual webform node id.  You can export the results to csv or excel format.

Guarantees
Partners