Need help with scrapped users

Instagram Marketing
#1

ok here is the issue,i scrapped +50kusers , and i have them on googlesheet now,issue is that i dont know how to split that list into 200users and getting space between them .

if someone know how or know a tool can do it would be helpful

#2

Are you using Jarvee? Just enable don’t follow same people and then you don’t need to do that

#3

no this is just for something else just need to know if someone can do it

1 Like
#4

Sorry don’t know a trick to do that fast

#5

If you mean you want to insert a row after every 200 users, you can do it in Excel:

  1. Download the google sheets file as excel file
  2. Open it in excel
  3. File > More > options > Customize ribbon
  4. In the Main tab, check “Developer”
  5. Once the Developer tab appears, click on it > visual basic
  6. Select your sheet, then click on View > Code.
  7. Paste this script:
    Option ExplicitSub Macro1() 'Written by Trebor76 'Visit my website - Pastebin.com
  8. Run it.
3 Likes
#6

thanks but they say page not foud when clicking the pastebin link

also is there similar solution for google spreadsheet?

#7

I’ve updated the pastebin link, if it doesn’t work, you can download the script here:

there may be a way to do that in google sheets, but with a different script

#8

ok thanks , do you know the process to do it on sheet?

#9

Hey Can i get your reply on PM? thanks a lot!

#10

Sorry, I’m not sure what you mean, you should select the sheet which contains the data in step 6.

#11

Just replied to your PM, sorry for late response. I rarely check PM.

#12

If you export them as a csv file you can edit that file with Notepad++. Notepad++ has a record en play function. You can use that to record actions, and use play to repeat the recorded actions an x number of times.

It is useful to have and understand. I think Notepad++ is my most used piece of software.