Feedback from customers

[zico8]

Hi All,

I was thinking to post this topic into "excel questions" forum area, but when have seen BI area near to it and as I know, one of the mainly being said from the BI descriptions is Collecting data, I decided to write my question here.

I would like to send my customers some kind of feedback form and easy collect answers to spreadsheet (or another database from which possibly is to import these to excel).

So what can you propose for achieve it?
Can I embed xls file on the website (or write form on it by any differents like JavaScript) and import data to excel?

Sending directly by mail is good solution also but I do not want to make it in xls file in case that reveiver do not have installed any excel supported soft. Maybe interactive PDF file would be god?
How it is created? Do I need any comercial soft for doing it?

Thanks for your reply

 

[Rhodie72]

I believe the solution you want is an HTML FORM with JavaScript for cross-platform compatibility between multiple operating systems and multi-device capability. this could be emailed out as a redirected hyperlink to the website that then emails the form results to you in CSV format which Excel can then import into a table for analysis. This is probably the best and fastest solution for your needs.

 

[zico8]

Thanks a lot Rhodie72,

Saying about hyperlink redirecting to my website have you mean personalized link or excatly the same as other customers will receive from me?

In other words. The data I receive from CSV file created on my website will be only what invaited this way customer filled or also some data identyfying him by link I sent to specific email address?

If I know Excel with basics of VBA and also have someone who can create me web with form and js is it difficulte to merge this together?

Should I need to rent someone who will develop something like this?

BTW. In older Excel version was sth as I know like embeded xls files into website so people was able to fill any forms. Am I wrong?
What actually this was replaced by?

 

[Rhodie72]

The short version is: "I don't know." The link you send to customers would be in an email directing them to website. What you do with the form is up to you. Require them to input their email address to identify them.
You should be able to copy the CSV data into excel through VBA very easily as Excel can read text files.
Hire somebody? I can't answer that: I don't know.

I never used the web features of Excel so I don't know what replaced it. I think it was improved and moved.