Prepare a large Excel spreadsheet
Select only the fields you need from thousands of spreadsheet records, edit values where necessary, and prepare a focused dataset.
Data Preparation Tool
Prepare Excel, CSV & JSON Data
Work with spreadsheet and structured data by selecting columns, editing cells, filtering records, sorting rows, calculating values, and preparing clean datasets for export.
Upload Excel, CSV or JSON data
Drop your data file here, or browse your device
Excel · CSV · JSON · up to 100 MB
Files are processed locally in your browser whenever supported.
Customize & Prepare Your Data
Prepare the exact dataset you need without working through unnecessary rows and columns.
Clean and organize student data
Select student information, filter by class or attendance, sort records, calculate values, and prepare a focused gradebook.
Prepare outstanding payment records
Keep customer, invoice, amount, and due-date fields, then filter and sort the dataset to prepare the records you need.
Organize inventory data
Filter products by stock level, category, or supplier and prepare a focused inventory dataset for further work.
Edit and Organize Spreadsheet Data
Select the columns you need, edit individual cells, remove unwanted rows, and organize the dataset before you export it.
Live example · Student Results
2,500 records · 5 fields — try selecting columns and filtering below.
Select columns
Filter: Marks < 40 (failing)
1,000of 2,500 records match your filter
| Student Name | Class | Marks | Attendance | Result |
|---|---|---|---|---|
| Fatima Ali | 7A | 16 | 87 | Fail |
| Liam Hassan | 7A | 4 | 89 | Fail |
| Priya Wong | 6A | 12 | 95 | Fail |
| Chen Hassan | 6B | 19 | 61 | Fail |
| Noor Ibrahim | 6A | 31 | 80 | Fail |
Showing first 5 of 1,000 matching rows.
Upload, Edit, Filter & Calculate Your Data
Work with large datasets, organize records, group related values, and calculate summaries from the data currently included in your view.
Select & Edit
Choose specific columns and edit individual cells directly in the dataset.
Filter & Sort
Filter records using conditions and sort the current dataset by one or more columns.
Group & Calculate
Group records and calculate counts, sums, averages, minimums, and maximums.
How Data Preparation Works
Move from an original dataset to a focused, organized dataset in a few steps.
Upload
Upload an Excel, CSV, or JSON file.
Analyze
DocBit identifies headers, columns, data types, and data quality.
Select & Edit
Choose the columns you need and edit individual data values.
Filter & Sort
Filter rows, sort records, group data, and calculate values.
Prepare & Export
Review the prepared dataset and export it as Excel, CSV, or JSON.
Spreadsheet and Dataset Tools
Practical tools for preparing Excel, CSV, and JSON data for the next stage of your workflow.
Work directly with your dataset
Select columns, edit cells, filter records, sort rows, group data, and calculate values from the dataset you are working with.
Keep your original data separate
Your preparation settings work as a separate view, allowing you to change the working dataset without overwriting the original uploaded data.
Browser-based data processing
Supported processing is performed locally in your browser whenever the selected operation allows it.
Excel, CSV & JSON Data Preparation FAQ
Common questions about preparing spreadsheet and structured data. For a full walkthrough, see the Documentation.
What file types can I prepare?
DocBit currently supports Excel workbooks (.xlsx and .xls), CSV files, and JSON files.
What can I do with an uploaded dataset?
You can select columns, edit cells, remove rows from the working dataset, filter records, sort data, group records, calculate values, and export the prepared dataset.
Can I edit an Excel file?
Yes. DocBit lets you work with supported Excel data by selecting columns, editing individual cells, filtering rows, sorting records, calculating values, and preparing the resulting dataset for export.
Can I edit CSV data?
Yes. CSV files can be opened, reviewed, edited, filtered, sorted, calculated, and prepared for export.
Can I edit JSON data?
Yes. Supported JSON datasets can be analyzed and prepared using the available column, editing, filtering, sorting, grouping, and calculation tools.
Does DocBit process data in the browser?
Supported processing is performed locally in your browser whenever the selected operation allows it. This allows supported data preparation operations to run without sending the dataset to a remote processing service.
Can I undo a data edit?
Yes. Live cell edits can be undone and redone, and the dataset can be reset to its original uploaded state.
Which formats can I export?
The current workflow supports Excel, CSV, and JSON exports.
Can I filter data before calculating values?
Yes. Calculations run against the current filtered dataset, so totals, averages, counts, minimums, and maximums reflect the records currently included in the working dataset.