Talking Turkish Names

This is about the batch posting method I mentioned on WordPress community forums.

Here’s how the data looks on Excel:  
 

Excel formula used for the Code column:

=”<item><title>” & A2 & “</title><description>” & C2 & “</description><category>” & B2 & “</category></item>”

Here’s the resultant text file that WordPress will import as an RSS feed.

<item>
<title>CNN</title>
<description>
The last global channel. <a href=”http://www.cnn.com”>www.cnn.com</a>
</description>
<category>TV</category>
</item>

<item>
<title>The Times</title>
<description>
There are so many Times newspapers. This is THE one.
</description>
<category>Newspaper</category>
</item> 

Of course the neat thing is one can manipulate data in many ways using Excel’s functions. I keep my Talking Turkish Names database up to date and in a standard way using this method.