Export to NODE XL
Home › Forums › Advanced usage › Export to NODE XL
- This topic has 9 replies, 3 voices, and was last updated 4 years, 4 months ago by Rafael.
March 3, 2016 at 7:25 pm #661
you can export the result to NodeXL?
jbMarch 3, 2016 at 8:37 pm #662
Hi – old recipe here https://mashe.hawksey.info/2011/10/using-google-spreadsheet-to-feed-nodexl/March 3, 2016 at 9:13 pm #663
I see it very difficult for me.
Thank you so much.
BarriApril 11, 2016 at 2:33 pm #700
I have tested the formulas and do not work in this version.
1º. DELETE FILE A
=EXPAND(ArrayFormula(IF(LEFT(E2:E,1)=”@”,MID(E2:E,2,FIND(” “,E2:E)-2),))) ERROR
I can not find the right formula
I do not get it to work 🙁 🙁 🙁
can you help me?
barriApril 12, 2016 at 8:51 am #701
hmm there is probably a better way to do this:
Method 1: check out the formula in this NodeXLFormatted Sheet (see cells A2, B2, and C2)
Methods 2: Use TAGSExplorer and export an edge list by adding &output=true to the url (you may need to enable pupups) e.g.
@reply only – http://hawksey.info/tagsexplorer/?key=1EvPNJqLfNrlBN6ljIk-i8LHImeghBt0DrkAfdS_izuY&sheet=Archive&output=true
@reply and @mention only – http://hawksey.info/tagsexplorer/?key=1EvPNJqLfNrlBN6ljIk-i8LHImeghBt0DrkAfdS_izuY&sheet=Archive&mentions=true&output=true
@reply, @mention and RT only – http://hawksey.info/tagsexplorer/?key=1EvPNJqLfNrlBN6ljIk-i8LHImeghBt0DrkAfdS_izuY&sheet=Archive&mentions=true&retweets=true&output=true
April 12, 2016 at 5:07 pm #705
- This reply was modified 6 years, 11 months ago by mhawksey.
the first option is PERFECT!!!
BarriApril 14, 2016 at 8:59 pm #710
Because I do not take the cell B (vertex 2) RT?
Some and not others
BarriJune 6, 2016 at 6:55 pm #734
la solución es:
jbJune 6, 2016 at 9:47 pm #735
Thanks – updated in the shared link 🙂November 6, 2018 at 2:05 pm #1299RafaelParticipant
Thank you very much for the help. It works perfectly. However, the table I have is too big and I can not edit it in the google spreadsheets. Is it possible that you indicate how the same formulas are written but in Excel?
- You must be logged in to reply to this topic.