7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

I've got 40,000 Offline Leads - Best Way To Sort Them?

by Steve Peters Benn
6 replies
Ok, so I'm sat at the Mac with 40,000 leads in a spreadsheet, ideally I would like to organise them by the various columns etc.

Thing is, no spreadsheet seems to like doing this - they go really slow.

Anyone know of a way to break it down easily. Currently, I've tried Excel and Numbers.

I'm hoping that this isn't a case where I need to use a database to do this?

Anyone got any ideas
#leads #sort
  • Profile picture of the author Tashi Mortier
    A database will only help if you want to run specific operations or searches on it. Also it would be just as slow to show you all the entries. 40,000 sets of data may eat up a lot of RAM. I think the problem is just computing power, maybe you can try OpenOffice but I doubt that it is any faster.

    I suggest you split the file up in multiple other files, just copy and paste the entries. If you need to search all the entries at once, then I recommend a database.
    Signature

    Want to read my personal blog? Tashi Mortier

    {{ DiscussionBoard.errors[3591407].message }}
  • Profile picture of the author Steve Peters Benn
    Hi Tashi,

    Thanks for the advice - I do need to run a lot of searches on this list to produce qualified leads.
    {{ DiscussionBoard.errors[3591415].message }}
    • Profile picture of the author Tashi Mortier
      Originally Posted by Steve Peters Benn View Post

      Hi Tashi,

      Thanks for the advice - I do need to run a lot of searches on this list to produce qualified leads.
      Then I'd definitely recommend that you import them into Access. I hope this is done the same way with the Mac version of Office as it is described here: Import Excel data to an Access database - Excel - Microsoft Office

      Then you can run all sorts of queries on this database. If I remember this correctly, then Access gives you a comfortable interface and you don't have to mess around with SQL Syntax.
      Signature

      Want to read my personal blog? Tashi Mortier

      {{ DiscussionBoard.errors[3591521].message }}
      • Profile picture of the author Steve Peters Benn
        Originally Posted by Tashi Mortier View Post

        Then I'd definitely recommend that you import them into Access. I hope this is done the same way with the Mac version of Office as it is described here: Import Excel data to an Access database - Excel - Microsoft Office

        Then you can run all sorts of queries on this database. If I remember this correctly, then Access gives you a comfortable interface and you don't have to mess around with SQL Syntax.
        They are clients of a client of mine. I'm running an offline campaign for them (b2b).

        I tried Bento today - didn't work at all - looks like access is what I need to use for this.

        Thanks again.
        {{ DiscussionBoard.errors[3592054].message }}
        • Profile picture of the author Tashi Mortier
          I've been working with it at school for some time, so I may be able to help you with some smaller problems, just send me a PM if you need my help.
          Signature

          Want to read my personal blog? Tashi Mortier

          {{ DiscussionBoard.errors[3596419].message }}
  • Profile picture of the author daddykool
    Do the leads need to be sorted for targeting on or offline?

    We have a master sheet, with sub sheets for *various offers* *tasks* *blahdy blah* then save, once researched, contacted, optin hit, into mysql database in its simplest form, them extract / delete from the tables anyone who should be on a dif sheet or list...

    Works well, no macros, no gadgets, no CRM... oh and no cost other than time :-)

    We have far more than 40k and never had a problem as long as you keep it simple!
    Signature
    LAUNCHING VERY SOON > PRE-REGISTER NOW FOR A WSO THAT EVERY WARRIOR NEW & OLD CAN MAKE $$$ FROM! LIMITED PRE-LAUNCH SPACES - PM or email: JVSuperstars@gmx.com TO RESERVE A PLACE & LOCK IN A SUPER LOW LIFETIME PRICE! *** NEVER TO BE REPEATED PRICE ONLY AVAILABLE ON THE WARRIOR FORUM & OUR VERIFIED JV AFFILIATE PROVIDERS! ***
    {{ DiscussionBoard.errors[3596476].message }}

Trending Topics