How do you collate survey results in a spreadsheet, in order to make graphs afterwards?

How do you collate:
Open-ended questions
Close-ended questions
Multi-answer questions