In this article, we’ll explain how to easily format and prepare your database CSV file and have your links instantly ready for upload. <h2 class="PlaygroundEditorTheme__h2" dir="ltr" style="text-align: start;">Example Spreadsheet</h2> The simplest way to go about formatting your file is by following our&nbsp;<a href="https://docs.google.com/spreadsheets/d/1Y_b6wktFowP4zLzOsop1zS29acMYg-TAsvXwANqYurM" target="" rel="noreferrer" class="PlaygroundEditorTheme__link">Example Spreadsheet</a>, which you can easily&nbsp;download&nbsp;and fill in with your links and other data:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">The columns colored in green are&nbsp;required, and the upload will be unsuccessful if there is data missing or if something is formatted incorrectly. Tip: In our example spreadsheet, we have inserted comments for each of the columns, with a brief description of what you should insert in each column: Let’s go over the Required fields. IMPORTANT NOTE: if you have different taxonomy and naming structure, please check the&nbsp;Custom Fields article, create your preferred custom fields, add them to your CSV file and just then upload the file to Base.me Client&nbsp;- Insert the&nbsp;domain&nbsp;of your client's website&nbsp;without the https:// or www Provider ID - insert ID of the link vendor who provides (sells) this link Link&nbsp;- Place the&nbsp;full URL&nbsp;on which the link to your website is. Date&nbsp;- The date column should always be formatted&nbsp;YYYY-MM-DD. If you leave this field blank, today’s date will automatically be filled. Category -&nbsp;Must be filled with the category that&nbsp;already exists in Base (see your company settings). Tip: There can be&nbsp;one&nbsp;category selected per link. Type -&nbsp;In this column, you should define the link type. These are currently available: sponsorship/partnershipinfographic promotioncontent promotioneditorial linkslocal citationresource pagerepublishinglink insertscholarshipsubmissionguest postgiveawaybookmarkprofileforumpr Status -&nbsp;This column should be defined by one of these&nbsp;four&nbsp;categories: Opportunity&nbsp;or&nbsp;op&nbsp;- you just found an interesting, relevant website for your client and you want to claim it, so your other colleagues won’t consider it for the same client Requested&nbsp;or&nbsp;re&nbsp;- you contacted the owner of the website and are waiting for their response) Pending&nbsp;or&nbsp;pe&nbsp;- you arranged everything and are just waiting for the link to be published Confirmed&nbsp;or&nbsp;co&nbsp;- the link is live, and you’ve successfully created another link for yourself or your client User -&nbsp;This column is used for defining which user has built the link. If you leave it blank, your email will be automatically applied. If you’ve noticed that there is a certain parameter that you use in your own spreadsheet but isn’t defined in our example spreadsheet, you are able to add a new,&nbsp;Custom Field&nbsp;on the&nbsp;Settings&nbsp;page of your account:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Tip: Once you are adding your custom field, you are able to determine whether or not the field will be&nbsp;Required.&nbsp;If you opt that the field is required, please ensure that&nbsp;you do not leave any fields in that column blank, otherwise, the upload will be unsuccessful. You are able to check whether the upload was successful via the Reports &gt; Link imports tab.<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Once you click the file name, if there are any errors in the upload, you will see it under “Errors” and the column “Reason” will show you exactly why the link was skipped for import. If you have any questions or need any help with formatting - feel free to reach out to one of our team members via Live Chat in-app, we’re more than happy to help.

In this article, we’ll explain how to easily format and prepare your link database CSV file and easily upload your links to Base.

In this article, we’ll explain how to easily format and prepare your database CSV file and have your links instantly ready for upload.

## Example Spreadsheet

The simplest way to go about formatting your file is by following our[Example Spreadsheet](https://docs.google.com/spreadsheets/d/1Y_b6wktFowP4zLzOsop1zS29acMYg-TAsvXwANqYurM), which you can easily**download**and fill in with your links and other data:

![](https://html.onlineviewer.net/)

The columns colored in green are*****required*****, and the upload will be unsuccessful if there is data missing or if something is formatted incorrectly.

**Tip: In our example spreadsheet, we have inserted comments for each of the columns, with a brief description of what you should insert in each column:**

Let’s go over the Required fields.

****IMPORTANT NOTE: if you have different taxonomy and naming structure, please check the Custom Fields article, create your preferred custom fields, add them to your CSV file and just then upload the file to Base.me****

****Client****- Insert the****domain****of your client's website****without the https:// or www****

****Provider ID****\- insert ID of the link vendor who provides (sells) this link

****Link****- Place the****full URL****on which the link to your website is.

****Date****- The date column should always be formatted****YYYY-MM-DD****. If you leave this field blank, today’s date will automatically be filled.

****Category -****Must be filled with the category that****already exists in Base****(see your company settings).

**Tip: There can be** *****one***** **category selected per link.**

****Type -****In this column, you should define the link type.

These are currently available:

sponsorship/partnership

infographic promotion

content promotion

editorial links

local citation

resource page

republishing

link insert

scholarship

submission

guest post

giveaway

bookmark

profile

forum

pr

****Status -****This column should be defined by one of these****four****categories:

****Opportunity****or****op****- you just found an interesting, relevant website for your client and you want to claim it, so your other colleagues won’t consider it for the same client

****Requested****or****re****- you contacted the owner of the website and are waiting for their response)

****Pending****or****pe****- you arranged everything and are just waiting for the link to be published

****Confirmed****or****co****- the link is live, and you’ve successfully created another link for yourself or your client

****User -****This column is used for defining which user has built the link. If you leave it blank, your email will be automatically applied.

If you’ve noticed that there is a certain parameter that you use in your own spreadsheet but isn’t defined in our example spreadsheet, you are able to add a new,****Custom Field****on the****Settings****page of your account:

![](https://html.onlineviewer.net/)

Tip: Once you are adding your custom field, you are able to determine whether or not the field will be****Required****.If you opt that the field is required, please ensure that****you do not leave any fields in that column blank****, otherwise, the upload will be unsuccessful.

You are able to check whether the upload was successful via the Reports > Link imports tab.

![](https://html.onlineviewer.net/)

Once you click the file name, if there are any errors in the upload, you will see it under “Errors” and the column “Reason” will show you exactly why the link was skipped for import.

If you have any questions or need any help with formatting - feel free to reach out to one of our team members via Live Chat in-app, we’re more than happy to help.

In this article, we’ll explain how to easily format and prepare your database CSV file and have your links instantly ready for upload. <h2 class="PlaygroundEditorTheme__h2" dir="ltr" style="text-align: start;">Example Spreadsheet</h2> The simplest way to go about formatting your file is by following our&nbsp;<a href="https://docs.google.com/spreadsheets/d/1wvKzb-licpvTO2XCAgUTN-0CPmpYTXFfCZBTHA_2hx4/edit#gid=0" target="" rel="noreferrer" class="PlaygroundEditorTheme__link">Example Spreadsheet</a>, which you can easily&nbsp;download&nbsp;and fill in with your links and other data:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">The columns colored in green are&nbsp;required, and the upload will be unsuccessful if there is data missing or if something is formatted incorrectly. Tip: In our example spreadsheet, we have inserted comments for each of the columns, with a brief description of what you should insert in each column: Let’s go over the Required fields. IMPORTANT NOTE: if you have different taxonomy and naming structure, please check the&nbsp;Custom Fields article, create your preferred custom fields, add them to your CSV file and just then upload the file to Base.me Client&nbsp;- Insert the&nbsp;domain&nbsp;of your client's website&nbsp;without the https:// or www Link&nbsp;- Place the&nbsp;full URL&nbsp;on which the link to your website is. Date&nbsp;- The date column should always be formatted&nbsp;YYYY-MM-DD. If you leave this field blank, today’s date will automatically be filled. Category -&nbsp;Must be filled with the category that&nbsp;already exists in Base (see your company settings). Tip: There can be&nbsp;one&nbsp;category selected per link. Type -&nbsp;In this column, you should define the link type. These are currently available: sponsorship/partnershipinfographic promotioncontent promotioneditorial linkslocal citationresource pagerepublishinglink insertscholarshipsubmissionguest postgiveawaybookmarkprofileforumpr Status -&nbsp;This column should be defined by one of these&nbsp;four&nbsp;categories: Opportunity&nbsp;or&nbsp;op&nbsp;- you just found an interesting, relevant website for your client and you want to claim it, so your other colleagues won’t consider it for the same client Requested&nbsp;or&nbsp;re&nbsp;- you contacted the owner of the website and are waiting for their response) Pending&nbsp;or&nbsp;pe&nbsp;- you arranged everything and are just waiting for the link to be published Confirmed&nbsp;or&nbsp;co&nbsp;- the link is live, and you’ve successfully created another link for yourself or your client User -&nbsp;This column is used for defining which user has built the link. If you leave it blank, your email will be automatically applied. If you’ve noticed that there is a certain parameter that you use in your own spreadsheet but isn’t defined in our example spreadsheet, you are able to add a new,&nbsp;Custom Field&nbsp;on the&nbsp;Settings&nbsp;page of your account:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Tip: Once you are adding your custom field, you are able to determine whether or not the field will be&nbsp;Required.&nbsp;If you opt that the field is required, please ensure that&nbsp;you do not leave any fields in that column blank, otherwise, the upload will be unsuccessful. You are able to check whether the upload was successful via the Reports &gt; Link imports tab.<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Once you click the file name, if there are any errors in the upload, you will see it under “Errors” and the column “Reason” will show you exactly why the link was skipped for import. If you have any questions or need any help with formatting - feel free to reach out to one of our team members via Live Chat in-app, we’re more than happy to help.

How to: Prepare Your Link Database for CSV Import

In this article, we’ll explain how to easily format and prepare your database CSV file and have your links instantly ready for upload. <h2 class="PlaygroundEditorTheme__h2" dir="ltr" style="text-align: start;">Example Spreadsheet</h2> The simplest way to go about formatting your file is by following our&nbsp;<a href="https://docs.google.com/spreadsheets/d/1wvKzb-licpvTO2XCAgUTN-0CPmpYTXFfCZBTHA_2hx4/edit#gid=0" target="" rel="noreferrer" class="PlaygroundEditorTheme__link">Example Spreadsheet</a>, which you can easily&nbsp;download&nbsp;and fill in with your links and other data:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">The columns colored in green are&nbsp;required, and the upload will be unsuccessful if there is data missing or if something is formatted incorrectly. Tip: In our example spreadsheet, we have inserted comments for each of the columns, with a brief description of what you should insert in each column: Let’s go over the Required fields. IMPORTANT NOTE: if you have different taxonomy and naming structure, please check the&nbsp;Custom Fields article, create your preferred custom fields, add them to your CSV file and just then upload the file to Base.me Client&nbsp;- Insert the&nbsp;domain&nbsp;of your client's website&nbsp;without the https:// or www Link&nbsp;- Place the&nbsp;full URL&nbsp;on which the link to your website is. Date&nbsp;- The date column should always be formatted&nbsp;YYYY-MM-DD. If you leave this field blank, today’s date will automatically be filled. Category -&nbsp;Must be filled with the category that&nbsp;already exists in Base (see your company settings). Tip: There can be&nbsp;one&nbsp;category selected per link. Type -&nbsp;In this column, you should define the link type. These are currently available: sponsorship/partnershipinfographic promotioncontent promotioneditorial linkslocal citationresource pagerepublishinglink insertscholarshipsubmissionguest postgiveawaybookmarkprofileforumpr Status -&nbsp;This column should be defined by one of these&nbsp;four&nbsp;categories: Opportunity&nbsp;or&nbsp;op&nbsp;- you just found an interesting, relevant website for your client and you want to claim it, so your other colleagues won’t consider it for the same client Requested&nbsp;or&nbsp;re&nbsp;- you contacted the owner of the website and are waiting for their response) Pending&nbsp;or&nbsp;pe&nbsp;- you arranged everything and are just waiting for the link to be published Confirmed&nbsp;or&nbsp;co&nbsp;- the link is live, and you’ve successfully created another link for yourself or your client User -&nbsp;This column is used for defining which user has built the link. If you leave it blank, your email will be automatically applied. If you’ve noticed that there is a certain parameter that you use in your own spreadsheet but isn’t defined in our example spreadsheet, you are able to add a new,&nbsp;Custom Field&nbsp;on the&nbsp;Settings&nbsp;page of your account:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Tip: Once you are adding your custom field, you are able to determine whether or not the field will be&nbsp;Required.&nbsp;If you opt that the field is required, please ensure that&nbsp;you do not leave any fields in that column blank, otherwise, the upload will be unsuccessful. You are able to check whether the upload was successful via the Reports &gt; Link imports tab.<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Once you click the file name, if there are any errors in the upload, you will see it under “Errors” and the column “Reason” will show you exactly why the link was skipped for import. If you have any questions or need any help with formatting - feel free to reach out to one of our team members via Live Chat in-app, we’re more than happy to help.

Prepare Your Link Database for CSV Import - How to

In this article, we’ll explain how to easily format and prepare your database CSV file and have your links instantly ready for upload. <h2 class="PlaygroundEditorTheme__h2" dir="ltr" style="text-align: start;">Example Spreadsheet</h2> The simplest way to go about formatting your file is by following our&nbsp;<a href="https://docs.google.com/spreadsheets/d/1Y_b6wktFowP4zLzOsop1zS29acMYg-TAsvXwANqYurM" target="" rel="noreferrer" class="PlaygroundEditorTheme__link">Example Spreadsheet</a>, which you can easily&nbsp;download&nbsp;and fill in with your links and other data:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">The columns colored in green are&nbsp;required, and the upload will be unsuccessful if there is data missing or if something is formatted incorrectly. Tip: In our example spreadsheet, we have inserted comments for each of the columns, with a brief description of what you should insert in each column: Let’s go over the Required fields. IMPORTANT NOTE: if you have different taxonomy and naming structure, please check the&nbsp;Custom Fields article, create your preferred custom fields, add them to your CSV file and just then upload the file to Base.me Client&nbsp;- Insert the&nbsp;domain&nbsp;of your client's website&nbsp;without the https:// or www Provider ID - insert ID of the link vendor who provides (sells) this link Link&nbsp;- Place the&nbsp;full URL&nbsp;on which the link to your website is. Date&nbsp;- The date column should always be formatted&nbsp;YYYY-MM-DD. If you leave this field blank, today’s date will automatically be filled. Category -&nbsp;Must be filled with the category that&nbsp;already exists in Base (see your company settings). Tip: There can be&nbsp;one&nbsp;category selected per link. Type -&nbsp;In this column, you should define the link type. These are currently available: sponsorship/partnershipinfographic promotioncontent promotioneditorial linkslocal citationresource pagerepublishinglink insertscholarshipsubmissionguest postgiveawaybookmarkprofileforumpr Status -&nbsp;This column should be defined by one of these&nbsp;four&nbsp;categories: Opportunity&nbsp;or&nbsp;op&nbsp;- you just found an interesting, relevant website for your client and you want to claim it, so your other colleagues won’t consider it for the same client Requested&nbsp;or&nbsp;re&nbsp;- you contacted the owner of the website and are waiting for their response) Pending&nbsp;or&nbsp;pe&nbsp;- you arranged everything and are just waiting for the link to be published Confirmed&nbsp;or&nbsp;co&nbsp;- the link is live, and you’ve successfully created another link for yourself or your client User -&nbsp;This column is used for defining which user has built the link. If you leave it blank, your email will be automatically applied. If you’ve noticed that there is a certain parameter that you use in your own spreadsheet but isn’t defined in our example spreadsheet, you are able to add a new,&nbsp;Custom Field&nbsp;on the&nbsp;Settings&nbsp;page of your account:<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Tip: Once you are adding your custom field, you are able to determine whether or not the field will be&nbsp;Required.&nbsp;If you opt that the field is required, please ensure that&nbsp;you do not leave any fields in that column blank, otherwise, the upload will be unsuccessful. You are able to check whether the upload was successful via the Reports &gt; Link imports tab.<img src="https://html.onlineviewer.net/" alt="" width="inherit" height="inherit">Once you click the file name, if there are any errors in the upload, you will see it under “Errors” and the column “Reason” will show you exactly why the link was skipped for import. If you have any questions or need any help with formatting - feel free to reach out to one of our team members via Live Chat in-app, we’re more than happy to help.