CSV to Excel
Convert a CSV file into a formatted .xlsx workbook with bold headers and auto-sized columns.
By Operelio team
On this page8
What it does
Takes a CSV file and produces a formatted Excel workbook (.xlsx). The output has bold headers in the first row and columns sized to fit the data. It is not a raw paste; it looks like a proper spreadsheet you could hand to a colleague.
When to use it
Use this when you have cleaned data in CSV and need to share it as an Excel file. Common situations: handing a report to a manager who expects .xlsx, sending data to a client, or converting output from another Operelio tool into a formatted spreadsheet. The auto-sized columns and bold headers save you the manual formatting step.
How to use it
Upload your CSV
Drag a .csv file into the upload area.
Run
No additional configuration needed. Click Run.
How formatting works
The first row is formatted as bold headers. Column widths are auto-sized by sampling the header and the first 100 rows of data to find the widest value in each column. Widths are capped at 50 characters to keep the spreadsheet readable. If your data has very long cell values, the column stops at 50 characters wide and Excel wraps the text.
The output is always a single-sheet .xlsx file. The sheet is named after your CSV filename by default (for example, pipeline.csv becomes a sheet named pipeline). If the filename contains characters Excel forbids (\ / * ? : [ ]) they are replaced with underscores, and names longer than 31 characters are truncated.
What to know
Every value in your CSV comes through exactly as-is in the Excel cell. Leading zeros on IDs are preserved, and no silent conversion to scientific notation occurs on long numeric strings.
Excel still coerces clean numeric columns for SUM and sort when you open the file, and ISO-formatted dates (YYYY-MM-DD) display and sort in the right order as text.
Every row and column in your CSV is written to the workbook as-is, including blank cells and blank rows. If you want those trimmed, clean the CSV before uploading or run Deduplicate afterwards on the downloaded file.
If the CSV is empty (no headers, no rows), the job fails with an error. Add at least a header row to your file and try again.
Row limits apply to every job: 50,000 on Pro, 75,000 on Team, 150,000 on Agency. If your file is larger, Operelio processes the first N rows up to your plan's limit and shows a banner on the results page with your file's total row count, the limit that was applied, and the number of rows processed.
File size limits are 25 MB on Pro, 35 MB on Team, and 100 MB on Agency. Uploads larger than the cap are rejected at upload with an error, before the job runs.
How your data is handled
Every cell in your CSV is written to the Excel workbook as text, with an Excel General number format. That means the workbook looks and behaves like a hand-typed spreadsheet: Excel coerces clean numeric columns for SUM and sort, text stays text, and nothing is silently converted to a different type.
| CSV input | Excel output | Why it matters |
|---|---|---|
| 01234 | 01234 | Leading zeros preserved on ZIPs, SKUs, and account codes. Excel won't silently strip the 0 down to 1234. |
| 07123456789 | 07123456789 | UK mobiles and long numeric IDs stay intact. No scientific notation like 7.12E+09 creeping in from Excel's autodetection. |
| 45000 | 45000 | Numeric values come through as the exact string you uploaded. Excel still sums them with =SUM() and sorts numerically when the column is clean. |
| 2026-01-15 | 2026-01-15 | ISO dates display and sort lexicographically in the right order. Excel won't reformat text cells to '15-Jan-26' or similar. |
| TRUE | TRUE | Boolean-looking values stay as literal text. Excel won't convert them to a checkbox or a 1/0 numeric. |
| café, über-friendly | café, über-friendly | UTF-8 preserves accents and non-Latin scripts. Commas inside cell values are auto-handled by the CSV parser. |
If you want Excel to store dates as real date cells (rather than text that happens to look like dates), convert the column after opening the workbook: select the column, Format Cells > Date. Operelio preserves the exact string you uploaded so your original data is never re-interpreted on the way in.
What the results show
After the job finishes you land on a results page that walks through the output. Expect to see:
Plain-language summary
A one-line sentence describing what was converted. For example: Converted your CSV into a formatted Excel workbook with 847 rows and 14 columns.
Stat cards
Total rows and total columns in the output workbook.
Sheet name
The name Excel uses for the tab inside the workbook. Derived from your CSV filename by default.
File size
A rough byte count of the Excel workbook you'll download (e.g. 12.4 KB). Useful reassurance that the output file isn't bloated.
Preview
The first 25 rows of the CSV data so you can spot-check the output before downloading.
Download or hand off
Download the workbook, or pass the source CSV to another Operelio tool such as Clean Headers, Deduplicate, or CRM Formatter first.
Frequently asked questions
What plan do I need?
CSV to Excel requires the Pro plan or higher. Free plan output is CSV only. Free users can still use the reverse tool (Excel to CSV) at no cost.
Can I customize the formatting?
Not currently. The output always has bold headers and auto-sized columns. If you need custom formatting, download the .xlsx and adjust it in Excel.
Does my Excel output have merged cells?
No. Every cell in the CSV becomes an individual cell in Excel. Merged cells are an Excel-only concept; the conversion is one-in, one-out per cell. If you need to merge cells in the output, do it in Excel after downloading.
What happens to blank rows and columns?
Every row and column in your CSV is written to the workbook as-is, including blank cells and blank rows. If you want those trimmed, clean the CSV before uploading or run Deduplicate afterwards on the downloaded file.
How long is my data kept on your servers?
Uploaded files and outputs are retained for 24 hours on Free, 30 days on Pro, 30 days on Team, and 90 days on Agency. After that, they are permanently deleted from storage. You can delete any file manually at any time on any plan.
Can I automate CSV to Excel via an API?
Yes, on the Team and Agency plans. You get API access to upload files, trigger jobs, and download results programmatically. Team includes 1,000 API calls per month and Agency 5,000, at 60 requests per minute. Free and Pro use the web tool only.
Ready to get started?
Upload a file and run your first transformation. Free, no credit card required.