@Tricia Dinkel at it's simplest you can just copy a column from a spreadsheet, then paste that all into a single card in the web or desktop app interfaces. This will give you the option to "Create X Cards", one per line.
This doesn't allow you to automatically add in other columns as, for example, custom fields or description elements. If you only have do this once, you could potentially get your spreadsheet as a CSV file, copy and paste it in, then you'd at least have all column data in Trello and could split the card titles up as required.
Alternatively, the Trello import instructions list Import2 as an option for importing from CSV:
Otherwise this is something you could use the API for. Trellinator is a Google Apps Script API library I created that would allow you to pretty easily access data in sheets and import it either on a regular basis or as the result of some trigger event:
If you had to thrive a new habit during a lockdown, what would it be? Trello
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event