Anyone know what’s involved with importing data from an excel sheet directly into phpMyAdmin? Basically, I have a custom post type set up for a business directory. Each business has an address, phone, website url, etc. Normally I would enter all this through the WP interface, filling out each custom field. But this excel sheet I have lists around 350 businesses, so entering them manually makes me want to consider a career change. Is it possible to automate this somehow? Or import the excel sheet directly into MySQL somehow? Thanks in advance for any help.
- The topic ‘Import data from excel file to a custom post type’ is closed to new replies.