How to Use Parsec

Transform your data easily with natural language instructions

Parsec is an AI-powered data transformation tool that allows you to transform your data using simple English instructions. Follow these steps to transform your data:

Step 1: Upload Your Data

Click on the upload area or drag and drop your file to upload. Parsec supports:

CSV files
TSV (Tab-separated) files
TXT files with delimited data
Excel files (.xlsx, .xls)

If your file has headers in the first row, make sure the "File has headers" toggle is turned on. If not, turn it off, and Parsec will automatically generate column names.

Step 2: Describe Your Transformation

Write clear instructions for how you want your data transformed. Be specific about what changes you want to make to each column.

Example instructions:

"Convert dates in column 'Purchase Date' from MM/DD/YYYY to YYYY-MM-DD format, format all phone numbers in 'Phone' column as (XXX) XXX-XXXX, and create a new column 'Full Name' by combining 'First Name' and 'Last Name' columns."

The more specific your instructions, the better your results will be. You can specify format changes, data calculations, text transformations, and more.

Step 3: Preview Transformation

Click the "Preview Transformation" button to see a sample of how your data will be transformed. This will show the first few rows of your data with the transformations applied.

If the preview doesn't look right, you can adjust your transformation instructions and try again.

Step 4: Download Your Transformed Data

Once you're satisfied with the preview, download your fully transformed data file. Choose your preferred format:

CSV (Comma-separated values)
TSV (Tab-separated values)
JSON (JavaScript Object Notation)
Excel (.xlsx)

Example Transformations

Here are some examples of what you can do with Parsec:

Date format conversions (MM/DD/YYYY to YYYY-MM-DD)
Phone number formatting ((123) 456-7890)
Name capitalization or standardization
Currency formatting ($1,234.56)
Unit conversions (km to miles, Celsius to Fahrenheit)
Calculations between columns (price * quantity)
Text extraction (domain from email, first name from full name)
Data cleaning (removing special characters, fixing typos)

Data Privacy

Parsec is designed with privacy in mind. Your data is never stored on our servers beyond the temporary processing time needed for transformation. All transformations are performed securely using AI technology, and once complete, your data is not retained.

Read our Privacy Policy

Start Transforming Your Data