limited text

This is due to badly formatted csv not because of plugin. Ensure that your csv is well formatted and saved as UTF–8. This can solve your issue.

yes solved thanks.
Anyway of getting this same result but with categories rather than pages?

Can you explain in detail? The given info is not sufficient.

Yes with this plugin it does exactly what i want on one site, i.e creates mass pages with description.
But could it or do you know of a plugin to use on another site where i want to mass create categories and give descriptions, same as this but with categories not pages

Yes, you should go for the pro version. You can create bulk nested categories, Taxonomy, tags and users.

ah ok thanks will look at that then

Any help let me know. You can go for a live demo here.