Both Google and Microsoft offer low tech ways to collect data in a structured format.
If you use Google applications, you're going to look at Google Forms. Google Forms acts as the door, it's how data gets in. Every Google Form gets connected to a live Google Sheet.
You're going to build first in Google Forms and then modify your Google Sheet after.
If you use Microsoft applications, this guide will focus on Microsoft Forms connected to a live Excel workbook. You're going to build first in Microsoft Forms and then modify your Excel workbook after.
Microsoft Lists is another option that allows you to build a more interactive database with formula columns, lookup columns, people columns, and more. However, this guide will not go in depth on Microsoft Lists. It is better suited to people who like to figure things out and are familiar with Power Automate.
Every step, every guide, with new guides added frequently.