Title: Unique Import request
Last modified: January 28, 2017

---

# Unique Import request

 *  Resolved [snangle](https://wordpress.org/support/users/snangle/)
 * (@snangle)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/unique-import-request/)
 * Here is a unique requirement that I can’t figure out a good solution. I have 
   a list of 100 values and for each value I have a URL that matches that value.
   In excel I was able to do a CONCATENATE function for hyperlink where I get a 
   single cell that contains the value and the corresponding URL for that value.
   When I bring this into TablePress via the import process it looses its hyperlink
   and it’s just the value only.
    Is there a way in TablePress (or any other way)
   to bring in 2 columns (50 per column) into a table in WordPress while retaining
   it’s unique hyperlink?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/unique-import-request/#post-8709888)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * The problem here is that the internal formats in Excel and TablePress (which 
   is HTML) differ, and that the current experimental Excel import does not yet 
   support importing links.
 * Some ideas are:
    – If your links are just URLs (i.e. the URL is also the link
   text), you could use the TablePress Extension from [http://tablepress.org/extensions/automatic-url-conversion/](http://tablepress.org/extensions/automatic-url-conversion/)–
   Or, if you have some real link text, you might try to use an Excel macro to automatically
   create the HTML code, see [http://wordpress.org/support/topic/hyperlinks-in-cells?replies=6#post-4710730](http://wordpress.org/support/topic/hyperlinks-in-cells?replies=6#post-4710730)
 * Regards,
    Tobias
 *  Thread Starter [snangle](https://wordpress.org/support/users/snangle/)
 * (@snangle)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/unique-import-request/#post-8713112)
 * Hi.
    Thanks for the assistance. I will keep trying to make it work.
 * Thanks,
    Sean
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/unique-import-request/#post-8713279)
 * Hi,
 * no problem! I hope that you can find a solution using those ideas.
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Unique Import request’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/unique-import-request/#post-8713279)
 * Status: resolved