compare_arrows
Loading...
Loading...
Extract specific columns from CSV or Excel files. Select, rearrange, and download just the data you need.
Select one column or many with a single click. Each column shows a sample value and detected data type (email, URL, number, date) so you always know what you are extracting.
Our tool automatically identifies column types: emails, URLs, dates, numbers, and currencies. Each column chip displays an icon showing its type, making it easy to find the data you need.
Export your extracted columns as delimited text, aligned tables, Markdown, JSON arrays, or SQL insert statements. One click to get the format that works for your workflow.
Apply filters to include only the rows you want. Filter by "Contains", "Equals", "Starts With", "Ends With", or check for empty values. Extract exactly what you need, nothing more.
Your data never leaves your device. All processing happens in your browser, no uploads, no servers, no cloud storage. Perfect for confidential business data or personal information.
Trim whitespace, convert to uppercase or lowercase, or merge multiple columns into one. Apply transformations as you extract to save time on post processing.
Have a large contact list but only need the email column? Select just the email field and extract it instantly. Works with any CSV exported from Excel or Google Sheets.
Extract first name and email columns to create a personalized email list. Merge them together with the merge feature to get "Name <email>" format ready for mail merge.
When you only need SKUs or product IDs from a large catalog, select that column and export as a simple list. No need to manually delete other columns.
Need only active customers? Enable row filtering to include only rows where "Status" equals "Active". Then extract only the columns you need from those filtered rows.
Select your columns and export as JSON array format. Perfect for importing into databases, APIs, or development environments without manual formatting.
Need to insert data into a database? Select your columns and choose SQL output format. Get ready to use INSERT statements with properly escaped values.
Our tool gives you powerful options to extract, filter, and transform your data. Here's how each feature helps you get exactly what you need.
Each column is analyzed to detect its data type. Emails, URLs, dates, numbers, currencies, and booleans are all identified automatically. Look for the icon on each column chip to see its type.
Switch to the "Row Filters" tab to filter your data before extracting. Choose a column, pick an operator (Contains, Equals, Starts With), and enter a value. Only matching rows are included.
Enable "Merge Columns" to combine multiple selected columns into one. Choose a separator (like space or comma) to join the values. Great for creating full names or complete addresses.
Apply transformations to extracted data: trim extra whitespace, convert to UPPERCASE, or convert to lowercase. Changes are applied automatically before output.
Export as JSON arrays or SQL INSERT statements with one click. Values are properly escaped and formatted, ready to copy directly into code or database tools.
Choose between raw delimited text, aligned pretty tables, Markdown tables, JSON arrays, or SQL inserts. Each format is optimized for its specific use case.
Paste your CSV into the input box and the tool will detect all columns. Click on the column chips you want to extract, and the output will update instantly. No signup required.
The tool detects emails, URLs, dates, numbers, currencies, and booleans automatically. Each column chip shows an icon indicating its type, making it easy to identify the data you need.
No, everything runs locally in your browser. Your data never leaves your device, making this tool completely safe for confidential business data or personal information.
Yes, switch to the "Row Filters" tab and enable filtering. Select a column, choose an operator like "Contains" or "Equals", and enter a value. Only rows matching your filter will be extracted.
You can export as raw delimited text (CSV), aligned pretty tables, Markdown tables, JSON arrays, or SQL INSERT statements. Select your format from the dropdown menu.
Yes, enable "Merge Columns" in the Transformations section. Select multiple columns and choose a separator character. The values will be joined together in the output.
Yes, the interface is fully responsive and works on smartphones and tablets. Select columns and extract data anywhere, anytime.