for some threads everyone knows a little bit
Avoid database programs like the plague.
I think Martin's first post was good, except each field should be separated by a comma and ensure no commas elsewhere. This can produce a CSV (comma separated values) file that excel and many other programs will input. (do they have CR/LF at the end of a section?)
Martin's google stuff offers one way of capturing data, others may prefer Notepad, others Access. Doesn't matter provided they can all output a CSV.
The CSVs can be merged.
Spelling errors don't matter becasue spell checkers can clear it up ( a feature not often available in a fancy database).
If the data is simple and standard it can then be post processed and presented in many different ways.
Data may not be perfect and articles missed but it's not a safety critical system - so don't fuss.
Programmers can offer different programs for searching over time to improve capturing similar words and spelling or import it into the database of their choice.
Dates are probably the thing that will end up with most different formats, but they can be processed into a standard.
Data entry - snow bound, ill, disabled, bored, retired, lots of us have an hour to fill. So what if there are dupications if it tells you twice it won't hurt and eventually the data can be cleaned.