How do you export product URL's?

[jokkah]

Hmm, I am not sure if I grasp what you have suggested. Do you mean putting all this together from the database tables themselves?

I can easily just append the server name to a combination of data in other columns, but what about the URL's that use subcategories? An example would be servername:///index.php?main_page=product_info&cPath=312_322&products_id=611 (ones with underscore to separate category to subcategory)

I was thinking of just using an Excel formula to build all the product URL's, (servername + category + products_id) but ran into a snag when I realized a lot of the products are in subcategories such as the example above