Automating Production Page Creation

I have a unique question and looking for guidance on where to start looking. I'm new to Rails and Ruby.

I'm looking to take a spreadsheet of information, in this example, it's going to be a list of locations, like cities across the US. And then take that spreadsheet of information and have my rails application create pages for each one of the cities.

My current setup is much like a blog, so I have Posts has a model. Your basic Rails scaffold of posts. Directionally speaking, how would I start looking into methods to write and run a script in production that would automate the creation of Posts based on the spreadsheet list of cities?