JSONToTable
Loading Excel Column Picker...
Please wait a moment

How to Pick Columns from an Excel File — Step by Step

Remove unwanted columns from any Excel file and export only the columns you need — without installing Excel or uploading your data anywhere.

Step 1

Upload Your Excel File

Drag your file onto the upload zone or click to browse. All file parsing uses the SheetJS library running locally — no data is sent to any server. Supports .xlsx, .xls, and .csv:

•
Drag and drop: Drop any Excel file directly onto the upload zone
•
Browse files: Click the Upload button in the toolbar or click inside the upload zone
•
Try sample data: Click "Sample" to load a built-in 8-column employee table and explore the column picker immediately
Step 2

Select Columns to Keep

Click the "Columns" button in the toolbar to open the column selector panel. All columns are selected by default — uncheck any column to remove it from the preview and export:

Example: Selecting 3 of 5 columns

Original table (5 columns):

NameAgeCityOccupationSalary
Lisa Martinez28New YorkSoftware Engineer75000

After keeping Name, City, Salary:

NameCitySalary
Lisa MartinezNew York75000

Age and Occupation columns removed.

Step 3

Export the Trimmed Excel File

Click the "Excel" button to download a new .xlsx file containing only the selected columns across all rows. Column order in the export matches the original order from the source file:

•
All rows included: Every data row is included in the export — only columns are trimmed, not rows
•
Column order preserved: The exported columns appear in the same order they were in the original file
•
Further filter rows: Need to filter rows too? Use Excel Row Filter to extract specific rows by column value

What is an Excel Column Picker?

An Excel column picker lets you select a subset of columns from a spreadsheet and export a trimmed version without opening Microsoft Excel or writing any code. Spreadsheet exports from ERPs, CRMs, and data warehouses often contain dozens of columns — many of which are internal IDs, audit fields, or system metadata that are irrelevant for the intended audience.

This tool reads your Office Open XML (.xlsx) file using the SheetJS library — entirely in your browser. You select which columns to keep, preview the result live, then download a clean ECMA-376 compliant .xlsx file. No data leaves your machine — the tool works fully offline after the page loads.

Column picking is also a key step in data minimisation — a requirement under regulations like GDPR that organisations should only share the personal data that is strictly necessary for a given purpose. Removing email addresses, phone numbers, and other personally identifiable information (PII) before sharing a spreadsheet is a straightforward compliance measure this tool supports.

The output file is compatible with Google Sheets, LibreOffice Calc, and Excel 2007 or later. Need to filter rows as well? Use Excel Row Filter alongside this tool.

Common Use Cases

Data Privacy & GDPR
Remove PII columns like email address, phone number, date of birth, or national ID before sharing a spreadsheet with external teams, contractors, or vendors.
Report Trimming
A finance or HR export has 30+ columns but a report only needs 5. Pick exactly the columns required and download a focused, readable file.
API Payload Reduction
Strip unnecessary columns before converting to JSON or CSV to reduce payload size for REST API integrations or webhook payloads.
Database Import Preparation
Remove columns that do not exist in your target database schema before bulk-importing the file via CSV into PostgreSQL, MySQL, or SQLite.
Stakeholder-Specific Sharing
Create department-specific views of the same master spreadsheet — finance sees cost columns, operations sees logistics columns — without duplicating the source file manually.
ERP and CRM Export Cleanup
Remove auto-generated internal IDs, audit timestamps, and system metadata columns that appear in raw exports from Salesforce, SAP, or similar platforms.

Frequently Asked Questions

Is my data private?
Yes. The entire tool runs in your browser using SheetJS. No file is uploaded to any server. You can verify by disconnecting from the internet before uploading — the tool will still work.
Can I select only one column?
The tool requires at least one column to be selected at all times. You cannot deselect all columns, but you can reduce the selection to a single column.
Does it work with multi-sheet Excel files?
Yes. Use the sheet tabs in the toolbar to switch sheets. The column picker resets for each sheet based on its own header row.
Is the original file modified?
No. The original file is never changed. The tool reads it in memory and generates a new .xlsx file only when you click Export.
What format is the exported file?
The exported file is .xlsx (Office Open XML / ECMA-376), compatible with Microsoft Excel 2007 and later, Google Sheets, LibreOffice Calc, and most modern spreadsheet applications.
What happens to rows when I remove columns?
All rows are preserved in full — only the deselected columns are removed. The row count in the export matches the original sheet exactly.

Related Tools

XLSX to Table

Upload an Excel file and view it as an interactive searchable table with multi-sheet support

Excel to Table

Upload an Excel (.xlsx, .xls) or CSV file and view it as a searchable, filterable HTML table instantly

Excel to JSON

Convert an Excel (.xlsx, .xls) or CSV file to JSON — array of objects or array of arrays

Excel to CSV

Upload an Excel file and convert any worksheet to CSV — copy or download the output

Excel Row Filter

Filter Excel rows by column conditions (contains, equals, starts with) and export only matching rows

JSON to C

Convert JSON data to C structs with parsing functions and memory management