Title: CSV Upload Strategy
Last modified: November 4, 2017

---

# CSV Upload Strategy

 *  Resolved [wolfenr](https://wordpress.org/support/users/wolfenr/)
 * (@wolfenr)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/csv-upload-strategy/)
 * Hi just asking for some clarification of the CSV Upload process.
 * I recently had to edit the records in my database because I wanted all the hyperlinks
   in the database to open up in a new tab i.e. add target=”_blank” to every hyperlink.
 * I thought about doing this by downloading the CSV file, editing it in Excel and
   then re-uploading the CSV file. However, when I read your article on uploading
   a CSV file, I thought that this would add records to the database rather than
   replace them and I would end up in a muddle because half my records would have
   the amendment and the other half not.
 * Could you clarify please on uploading a CSV file when you already have records
   in the database.
    My thanks, Rog
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcsv-upload-strategy%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/csv-upload-strategy/#post-9651103)
 * When you upload a CSV to your site, you can choose to update existing records,
   you just need to make sure you have included the ID of the records in the export
   so that it can match the record and update it when you upload.
 * However, that won’t allow you to put a target=”_blank” in the links, because 
   only the URL and the link text is stored, not the full HTML of the link.
 * To do this, you can use a custom template or a filter. The use of a filter is
   described in this article…you’ll need to alter it somewhat as it is for a slightly
   different purpose.
 * [Make External Links Open in a New Tab or Window](https://xnau.com/make-external-links-open-in-a-new-tab-or-window/)
 *  Thread Starter [wolfenr](https://wordpress.org/support/users/wolfenr/)
 * (@wolfenr)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/csv-upload-strategy/#post-9651932)
 * Thank you [@xnau](https://wordpress.org/support/users/xnau/). Excellent support
   as ever.

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

The topic ‘CSV Upload Strategy’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [upload](https://wordpress.org/support/topic-tag/upload/)

 * 2 replies
 * 2 participants
 * Last reply from: [wolfenr](https://wordpress.org/support/users/wolfenr/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/csv-upload-strategy/#post-9651932)
 * Status: resolved