Make a WP posts database form an excel spread sheet or text file?

CpaCash

Make Money Online
Joined
Jun 8, 2010
Messages
272
Reaction score
1
Points
0
Website
scrapeboxapi.com
Ok so i have a wordpress site for game downloads, i finally found a full list of games with the title and download link and copied them into an excel spread sheet. the list has over 700 dl links.

being that its such a big list i wanted to find a way to convert the list into an sql database to use as my post on the wp site, or take it a step further and add the full description.

also how can i add html code to mask the link before uploading so i dont have to do it one by one once the list is imported?

but i have no ideas how to do this, i looked around but still cant find out how to do this, any ideas? or should i just outsource this type of job?

thanks
 

NorCalRox

Make Money Online
Joined
Nov 23, 2010
Messages
54
Reaction score
0
Points
0
This is a good question. I'd like to know the answers to these questions, too.
 

wot

New Member
Joined
Feb 6, 2012
Messages
13
Reaction score
0
Points
0
Location
localhost
You are over complicating it by trying to load the excel file. Save it as csv and load the values into an array. Post the values from the array to the database.

That should be enough to get you going. If you have problems with that post here and I'll give you another shove in the right direction.

Wow...just realized the is over a year old. Damn tapatalk and its monochromatic theme.