The Basics of RegExSheet

Edit, organize, and format spreadsheet data using regular expressions.

Simply copy-and-paste text from a spreadsheet or a CSV file to get started.



Steps
  1. Launch RegExSheet
  2. Import Data
  3. Select Columns to Highlight (actions only apply to highlighted columns)
  4. Enter Regular Expression
  5. Match, Split, Replace, Copy or Cut Fields
  6. Export Transformed Data
Select the fields that you want to apply the transformation and enter regular expression and optionally, replacement text.

Launch RegExSheet



Features

Make changes to a spreadsheet or csv data using regular expressions.

Actions

These actions are used to apply a Regular Expression to your selected spreadsheet columns.
For a syntax refresher or introduction see the Regular Expression Quick Start

Match
Splits and keeps only the matching text

Split
Splits and discards the matching text

Replace
Replaces the matching text with the replacement text
including regex notation $1, $2, etc for grouped expressions.

Cut
Only removes the matching text

Copy
Duplicates the matching text



Examples

Break Full Name into First and Last Name

Original

Full Name
Marco Vincent Cabeza de La Vaca

Result

FirstMiddleLast
MarcoVincentCabeza de la Vaca


Separate Address

Original

Address
1212 Elm St San Diego CA 92104

Result

StreetCityStateZip
1212 Elm StSan DiegoCA92104


Format Phone Numbers

Original

Phone
619-555-1010
(619) 5554321
6195552222

Result

Phone
(619) 555-1010
(619) 555-4321
(619) 555-2222




RegExSheet created by Jeremy Taylor copyright 2015 version 0.15820