SharePoint Document Issues

How to Store URLs Longer Than 256 Characters in Microsoft Lists

Adam Davis Oct 21, 2026 868 views

Question details

The user needs to save long URLs that exceed 256 characters into a Microsoft Lists or SharePoint list.

How to Store URLs Longer Than 256 Characters in Microsoft Lists

Product: Microsoft Lists and SharePoint
Device & OS: not provided
Scenario: Adding or updating list items containing lengthy web links, such as tracking URLs or complex system links.
Observed behavior: The default Hyperlink column restricts the URL length to approximately 255-256 characters, causing longer links to be rejected or truncated upon saving.

Before you start

Ensure you have the necessary 'Edit' or 'Full Control' permissions to modify list columns and change list settings in your SharePoint or Microsoft Lists environment.

Solution 1Recommended

Use a Multiple Lines of Text Column with Enhanced Rich Text

Bypass the restrictive Hyperlink column by creating a Multiple lines of text column that supports rich text formatting, allowing you to embed URLs of virtually any length.

The standard Hyperlink column in SharePoint and Microsoft Lists has a hardcoded legacy limit of 255 characters. By switching to a 'Multiple lines of text' column and enabling enhanced rich text, you can leverage the formatting toolbar to insert long, clickable hyperlinks without hitting the character constraint.

Add a new column

Navigate to your target Microsoft List or SharePoint list. Click on '+ Add column' at the top of your list view and select 'Multiple lines of text' from the dropdown menu.

Configure column options

Enter a name for your new column (e.g., 'Long Link'). In the column creation pane on the right side, click on 'More options' to expand the advanced settings.

Enable enhanced rich text

Locate the toggle for 'Use enhanced rich text (Rich text with pictures, tables, and hyperlinks)' and set it to 'Yes', then click 'Save' to create the column.

Insert the long URL

Create a new list item or edit an existing one. In your new text column, type a display name for your link, highlight the text, click the hyperlink icon in the text formatting toolbar, and paste your long URL into the address field.

Use a Multiple Lines of Text Column with Enhanced Rich Text

Submit Feedback to Microsoft: Microsoft is actively monitoring this limitation. If standard Hyperlink columns are essential for your workflow, submit your feedback through the official SharePoint feedback portal to request expanded character limits.

Free Microsoft Office alternative

Manage Data and Long Hyperlinks Easily with WPS Spreadsheet

If you find Microsoft Lists limiting for data tracking, consider managing your tables and hyperlinks using WPS Spreadsheet. It offers robust data management without the 256-character hyperlink constraints, providing a highly compatible and lightweight alternative for all your office needs.

Fully compatible with Microsoft Excel (.xlsx) formats, making list migration simple.No restrictive 256-character limits for inserting long hyperlinks into spreadsheet cells.Lightweight, fast-loading, and completely free to use for personal document management.Familiar user interface minimizes the learning curve when switching from other Office suites.

microsoft office alternative - wps office

Frequently Asked Questions

Why is there a 256-character limit on SharePoint Hyperlink columns?

This is a legacy architectural limitation in SharePoint's database schema. The standard URL field type was originally capped at 255 characters to optimize storage and indexing performance in older versions of SharePoint.

Will the URLs in the Multiple lines of text column still be clickable?

Yes, as long as you enable 'Enhanced rich text' in the column settings. This allows you to format text as a clickable hyperlink using the standard formatting toolbar, just like in a Word document.

Can I convert an existing Hyperlink column to a Multiple lines of text column?

SharePoint does not allow direct conversion from a Hyperlink column to a Multiple lines of text column. You must create the new text column first, manually migrate your existing links over, and then delete the old Hyperlink column.

Is there a limit to how long URLs can be in the Multiple lines of text column?

A Multiple lines of text column in SharePoint can store up to 63,999 characters (or up to 2 GB if appended changes are enabled), which is more than enough to accommodate exceptionally long URLs or tracking links.

Document & File Issues