+ Reply to Thread
Results 1 to 20 of 20

Copy Data from Wordpress Tags Bar to Excel

  1. 01-19-2020, 06:08 AM #1
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Question Copy Data from Wordpress Tags Bar to Excel

    Hello,
    First of all sorry for post title confused about what to name it , I am copying some tags (text) from Wordpress Post Editor , when I copy the tags by selectings all tags text by using mouse ( See Pic 1) and paste it into excel it shows the following result (See Image 2) or this text

    Remove term: benefits for riders benefits for ridersRemove term: Bike ride with Bykea Bike ride with BykeaRemove term: bike rider karachi bike rider karachiRemove term: bykea bykeaRemove term: bykea app bykea appRemove term: bykea mobile phone snatching coverage bykea mobile phone snatching coverageRemove term: bykea rider requirements bykea rider requirementsRemove term: bykea riding partners requirements bykea riding partners requirementsRemove term: motorcycle riders motorcycle ridersRemove term: parcel delivery service parcel delivery serviceRemove term: requirements for Bike rider at bykea requirements for Bike rider at bykeaRemove term: riders accidental coverage riders accidental coverageRemove term: riding partners riding partnersRemove term: skills required for bykea rider skills required for bykea rider

    while the original output will be as below

    benefits for riders
    Bike ride with Bykea
    bike rider karachi
    bykea
    bykea app
    bykea mobile phone snatching coverage
    bykea rider requirements
    bykea riding partners requirements
    motorcycle riders
    parcel delivery service
    requirements for Bike rider at bykea
    riders accidental coverage
    riding partners
    skills required for bykea rider
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 01-19-2020, 06:11 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    Sorry, I don't understand. What is the problem?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 01-19-2020, 06:14 AM #3
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    When I copy the Tags(text) as shown in Image 1 (first from left side) and paste it into excel it get pasted as
    Remove term: benefits for riders benefits for ridersRemove term: Bike ride with Bykea Bike ride with BykeaRemove term: bike rider karachi bike rider karachiRemove term: bykea bykeaRemove term: bykea app bykea appRemove term: bykea mobile phone snatching coverage bykea mobile phone snatching coverageRemove term: bykea rider requirements bykea rider requirementsRemove term: bykea riding partners requirements bykea riding partners requirementsRemove term: motorcycle riders motorcycle ridersRemove term: parcel delivery service parcel delivery serviceRemove term: requirements for Bike rider at bykea requirements for Bike rider at bykeaRemove term: riders accidental coverage riders accidental coverageRemove term: riding partners riding partnersRemove term: skills required for bykea rider skills required for bykea rider

    While I want the paste output as shown in Image 2
    Last edited by AliGW; 01-19-2020 at 06:15 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 01-19-2020, 06:16 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    Do you mean it appears all in one cell?

    Which version of Excel are you using now?
    Reply With QuoteRegister To Reply
  5. 01-19-2020, 06:20 AM #5
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    I am using Office 2016 , if I select Paste Special and Text or unicode it get paste into different cells of a row,
    if I select HTML then it get pasted in a single cell
    Last edited by AliGW; 01-19-2020 at 06:21 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  6. 01-19-2020, 06:22 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    Please update your forum profile and please stop quoting posts - it's not necessary when you are responding to the one before yours.

    Please attach a workbook with the data as it appears if you use the Paste Special > Text option.
    Reply With QuoteRegister To Reply
  7. 01-19-2020, 06:32 AM #7
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    Workbook attached for your reference
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 01-19-2020, 06:35 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    Just out of interest, is there a reason why you are not using the refreshable web query option? As you have PowerQuery in Excel 2016, you might be able to make this automatic. Do you have a link to the data online?
    Reply With QuoteRegister To Reply
  9. 01-19-2020, 06:39 AM #9
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    Problem is that direct link is now showing any Tags, if I go to Source Code there is also no Tags
    Actually I am copy Tags from my one blog post to other blog due to some post revision versions I am doing it manually , if I run backup on my new blog it will not show any revision version of post..
    Reply With QuoteRegister To Reply
  10. 01-19-2020, 06:41 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    I didn't understand any of your last post. Could you please answer the questions I asked?
    Reply With QuoteRegister To Reply
  11. 01-19-2020, 06:45 AM #11
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    well tags can not be fetched via scrapy or Power Query i already tried it ...
    Reply With QuoteRegister To Reply
  12. 01-19-2020, 06:48 AM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    OK - thanks, that clarifies that.
    Reply With QuoteRegister To Reply
  13. 01-19-2020, 06:57 AM #13
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    As you have now marked this thread as solved, please share your solution.
    Reply With QuoteRegister To Reply
  14. 01-19-2020, 07:10 AM #14
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    Actually it is not resolved and I am not going to take my or others time on it , Still a better solution can be adviced , I have more ideas by some editing in my main blog and do some other stuff or finding solution
    Reply With QuoteRegister To Reply
  15. 01-19-2020, 07:11 AM #15
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    OK - I shall remove the SOLVED tag, then. This is a help forum, and others may have ideas to share with you.
    Reply With QuoteRegister To Reply
  16. 01-19-2020, 07:14 AM #16
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    Ok sure as you like
    Reply With QuoteRegister To Reply
  17. 01-19-2020, 07:37 AM #17
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    This solution uses PowerQuery to process the data from the HTML dump/paste in column A.

    M Code:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  18. 01-19-2020, 07:50 AM #18
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    OMG greatly done ... Thanks for better solution
    Reply With QuoteRegister To Reply
  19. 01-19-2020, 07:55 AM #19
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,774

    Re: Copy Data from Wordpress Tags Bar to Excel

    No problem.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  20. 01-19-2020, 07:57 AM #20
    vikas_newports
    vikas_newports is offline
    Forum Contributor
    Join Date
    05-26-2016
    Location
    India
    MS-Off Ver
    Microsoft 2021
    Posts
    324

    Re: Copy Data from Wordpress Tags Bar to Excel

    Thanks resolved and marked as RESOLVED
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel VBA macro enable to Wordpress USERS question
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2016, 04:13 PM
  2. Embed excel documents on wordpress
    By alfa_sixten in forum Excel General
    Replies: 0
    Last Post: 11-28-2014, 12:53 AM
  3. Extract Data between tags in Excel Cell and place in new columns
    By interwoven in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2013, 06:15 PM
  4. Excel Tables In Wordpress Blogs
    By TallahasseeC21 in forum Excel General
    Replies: 0
    Last Post: 05-17-2009, 09:27 AM
  5. www.verbatim.wordpress.com
    By verbartim in forum Excel General
    Replies: 0
    Last Post: 02-13-2006, 11:30 AM
  6. [SOLVED] www.verbatim.wordpress.com
    By skdkkks in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-12-2006, 07:30 AM
  7. [SOLVED] Excel to PDF w/ Data Tags
    By Dorian C. Chalom in forum Excel General
    Replies: 0
    Last Post: 10-18-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1