How to Remove Duplicate Rows in Google Spreadsheets

This video shows how to remove duplicate data (single column or multiple columns i.e. combined uniqueness) Use the “unique” function, then Copy & “Paste Special >> Values Only” to freeze the data (convert it from a calculation to raw data) To import this data into SwiftCloud (i.e. for Contacts, CRM deals, accounting data, etc.) simple Read More…

Import to Contacts / CRM / SwiftCloud

Import to SwiftCloud Note: the same process applies for importing CRM Data. In this video we import CSV (Comma Separated Values), however, we encourage you to use TSV (Tab Separated Values) as it is more reliable (because addresses sometimes contain commas in the street address or comments, which then affects the column-order).