Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.mac.apps > #21341 > unrolled thread

Numbers and Google

Back to article view | Back to comp.sys.mac.apps

Contents

  Numbers and Google John McWilliams <jpmcw@comcast.net> - 2014-03-04 21:52 -0800
    Re: Numbers and Google Michael Vilain <vilain@NOspamcop.net> - 2014-03-05 07:23 -0800

#21341 — Numbers and Google

I've recently agreed to try to help a non-profit group with their e-mail 
list, something under 500 entries. It was sent me last night and to my 
surprise it was a series of Google spread sheets. Can I use them to weed 
duplicates automatically or do I have to import into something else such 
as Pages.

-- 
John McWilliams

[toc] | [next] | [standalone]

#21350

In article <lf6e2i$f7k$1@dont-email.me>,
 John McWilliams <jpmcw@comcast.net> wrote:

> I've recently agreed to try to help a non-profit group with their e-mail 
> list, something under 500 entries. It was sent me last night and to my 
> surprise it was a series of Google spread sheets. Can I use them to weed 
> duplicates automatically or do I have to import into something else such 
> as Pages.

Spreadsheets should be converted to CSV then you can use cat+sort+uniq 
to create a merged list (assuming the naming and field order is 
consistent).  But you're probably not that lucky and those spreadsheets 
will have different names for the same thing or misspellings or a 
different column name or order.  You'll have to reduce this by hand.

-- 
DeeDee, don't press that button!  DeeDee!  NO!  Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]

[toc] | [prev] | [standalone]

Back to top | Article view | comp.sys.mac.apps

csiph-web