Setting up the import

Setting Up Data Import for City Statistics

Data Preparation

I've downloaded the data and made a few initial modifications:

1. Removed the zip code and metro area columns due to blank values.
2. Created a list mapping state abbreviations to full state names.
3. Used a VLOOKUP function to add the full state name to our dataset.

WordPress Setup

I've set up WordPress with the following:

• Custom Post Type UI plugin
• Created a 'Cities' custom post type with default settings
• Added categories and tags to the 'Cities' post type

Import Process

We'll use WP All Import to bring our data into WordPress:

1. Go...