Title: Links
Last modified: September 1, 2016

---

# Links

 *  Resolved [Josh Fisher](https://wordpress.org/support/users/mrjoshfisher/)
 * (@mrjoshfisher)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/links-95/)
 * Hello again,
 * Questions when importing xlsx files into the site, all the titles in my excel
   sheet are links but they aren’t getting imported when I click the link is there
   a reason for this, can it be aloud to import links ?
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/links-95/#post-7528122)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Unfortunately, I’ll have to disappoint you here. TablePress can not directly 
   import links from an Excel file, as those use a different technical structure.
   TablePress however requires links to be HTML code :-/
    Making those clickable
   would have to be done in Excel, e.g. by using a macro to convert them to HTML
   code there. A user has shared his solution at [http://wordpress.org/support/topic/hyperlinks-in-cells?replies=6#post-4710730](http://wordpress.org/support/topic/hyperlinks-in-cells?replies=6#post-4710730)
   Maybe that’s helpful here as well.
 * Regards,
    Tobias
 *  Thread Starter [Josh Fisher](https://wordpress.org/support/users/mrjoshfisher/)
 * (@mrjoshfisher)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/links-95/#post-7528164)
 * Cheers was a big help, I altered the macro to take a link from column A, the 
   title from column B, and produce html code in column C
 * [ColumnB](https://wordpress.org/support/topic/links-95/ColumnA?output_format=md)
 * Sub links()
    LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For I =
   2 To LastRow Cells(I, 2).Value = “” & Cells(I, 3).Value & ““ Next I End Sub
 * Hope this helps anyone else
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/links-95/#post-7528188)
 * Hi,
 * awesome! Good to hear that this helped! Thanks for sharing your solution!
 * Best wishes,
    Tobias
 *  Thread Starter [Josh Fisher](https://wordpress.org/support/users/mrjoshfisher/)
 * (@mrjoshfisher)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/links-95/#post-7528199)
 * sorry didnt display correctly
 *     ```
       Sub links()
       LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
       For I = 2 To LastRow
           Cells(I, 2).Value = "<a href=" & Chr(34) & "" & Cells(I, 1).Value & Chr(34) & ">" & Cells(I, 3).Value & "</a>"
       Next I
       End Sub
       ```
   
 * cheers no problem
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/links-95/#post-7528202)
 * Hi,
 * ah, yes, now the formatting is better.
 * Best wishes,
    Tobias

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

The topic ‘Links’ 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/)

 * 5 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/links-95/#post-7528202)
 * Status: resolved