CSV Maker & Creator - Create CSV File Online

CSV Maker: Create a CSV File Online

This CSV maker lets you create a CSV file online without opening Excel or writing code. Choose how many rows and columns you need, type into a spreadsheet-style grid, and download a .csv file. Everything runs in your browser, so the data you type is not uploaded to a server.

It works as a CSV creator for new files and as a table to CSV converter for data you already have in Markdown, JSON, HTML, YAML, or Excel.

What Is a CSV File?

CSV (comma-separated values) is plain text: each line is one record, and fields are separated by commas. The common conventions are written down in RFC 4180:

• The first line can be a header row with column names
• A field that contains a comma, a double quote, or a line break is enclosed in double quotes
• A double quote inside a quoted field is escaped by doubling it ("")

Because it is plain text, a CSV file opens in Excel, Google Sheets, LibreOffice, most databases, and almost every programming language. Microsoft documents how Excel opens and imports CSV files in Import or export text (.txt or .csv) files.

What You Can Do Here

• Create a CSV file from scratch: generate an empty grid (up to 100 rows × 26 columns at a time), rename the headers, and fill in the cells
• Make a CSV from existing data: paste a Markdown, JSON, HTML, or YAML table, or upload .xlsx / .xls, and get CSV output
• View a CSV as a table: paste CSV text and check every row in the table editor before you download
• Clean up the data: sort, transpose, remove empty rows and columns, deduplicate rows, change case, and find & replace (regex supported)
• Match the app you import into: comma, semicolon, tab, or pipe delimiter; quote every field; optional UTF-8 BOM for Excel

Common Uses

• Import templates for CRMs, online stores, mailing tools, and other apps that ask for a CSV upload
• Small test datasets for scripts, data pipelines, and spreadsheet formulas
• Quick lists such as contacts, inventory, or translation strings that you need to share as a file

How to Create a CSV File Online

1. Click Generate Table above the input panel, enter the number of rows and columns (1–100 rows, 1–26 columns), and click Generate. An empty grid with headers Column 1, Column 2, … appears in the Table Editor.
2. In the Table Editor, click a header cell and rename it (for example name, email, price), then fill in the data cells. Use Add Row or Add Column when you need more space.
3. Keep the output format set to CSV. The output panel updates as you type.
4. Click Download to save table.csv, or Copy to paste the text somewhere else.

Make a CSV File from Data You Already Have

• Paste CSV, Markdown, JSON (array of objects or 2D array), an HTML <table>, or YAML into the input panel and pick the matching input format
• Or click Upload File (or drag and drop) to load .csv, .tsv, .json, .md, .html, .yaml, .txt, .xlsx, or .xls
• The first row is treated as the header row
• Edit the result in the Table Editor before downloading

CSV Output Options

Without Quote Wrap, the tool still quotes any field that contains the delimiter, a double quote, or a line break, and doubles inner quotes as described in RFC 4180. The Unicode Consortium explains what a BOM is in its UTF and BOM FAQ.

Tips for Clean CSV Files

• Keep exactly one header row with unique column names; many importers map columns by header
• Leave a cell empty instead of typing N/A if the target system expects blanks
• Values such as 00123 are saved as typed, but Excel may drop leading zeros when it opens the file directly. Use Data → From Text/CSV in Excel and set the column to Text if you need to keep them

FAQ

Q: How do I create a CSV file online for free?

Click Generate Table, choose the number of rows and columns, type your data into the Table Editor, and click Download. You get a table.csv file that opens in Excel, Google Sheets, or any text editor. There is no sign-up and no fee.

Q: Is my data uploaded when I use this CSV maker?

No. Parsing, editing, and CSV generation all run in your browser with JavaScript. The data you type or upload stays on your device.

Q: How do I make a CSV file that opens correctly in Excel?

Use the comma delimiter (or semicolon if your Excel regional settings expect it) and turn on UTF-8 BOM if your data contains non-English characters. If columns still end up merged, open the file with Data → From Text/CSV in Excel and choose the delimiter there, as described in Microsoft's guide to importing text and CSV files.

Q: Can I convert a table to CSV?

Yes. Paste a Markdown table, a JSON array, an HTML <table>, or YAML into the input panel and select its format, or upload an Excel file. The output panel shows the same data as CSV, ready to copy or download.

Q: How do I view a CSV file as a table?

Paste the CSV text (or upload the .csv file) with the input format set to CSV. The Table Editor shows it as a grid with rows and columns, where you can fix values, sort, or remove duplicates before exporting again.

Q: What is the difference between CSV and TSV?

Both store one record per line. CSV separates fields with commas; TSV uses tab characters, which avoids quoting when your data contains commas. Choose the Tab delimiter to download a .tsv file.

Q: How many rows and columns can I create?

The Generate Table dialog creates up to 100 rows and 26 columns at once. You can keep adding rows and columns in the Table Editor, and pasted or uploaded data has no fixed limit. Very large tables (thousands of rows) may make the page slower because everything runs in the browser.

Q: Why does a cell with a comma or quote look different in the output?

That is correct CSV. Fields containing the delimiter, a double quote, or a line break are wrapped in double quotes, and inner quotes are doubled ("Alice ""Al"" Smith"), following RFC 4180. Spreadsheet apps read these back as the original value.