Blog
Notas curtas e práticas para quem realmente trabalha com arquivos de tabela.
How to Create a CSV File (Without Breaking Excel)
A CSV is plain text: a header line, then one record per line. You can type it, export it, or fill a grid and download it. The mistakes are usually commas, quotes, and encoding.
Ler artigo →How to Import a Markdown Table into Excel
Excel does not open .md files as tables. Convert the pipe table to XLSX first, or you will paste a single blob of text into one cell.
Ler artigo →How to Convert Excel to CSV (and CSV Back to Excel)
Excel to CSV is for systems that want text. CSV to Excel is for people who will open a workbook. They are not the same click, and double-clicking a CSV is the step that usually fails.
Ler artigo →CSV Opens as Garbled Text in Excel: Encoding, BOM and Leading Zeros
If Chinese or accented characters turn into gibberish when you double-click a CSV in Excel, the file is usually fine — Excel guessed the wrong encoding. Here is how to tell which problem you have and how to fix each one.
Ler artigo →CSV vs Excel vs TSV: Which Format Should You Use?
CSV, Excel and TSV all store tables, but they break in different places. Pick the format based on who opens the file next — a person in Excel, a script, or another system.
Ler artigo →How to Convert Nested JSON to CSV Without Losing Fields
A flat JSON array becomes a clean CSV in one step. Nested objects and lists need a rule before you export — here are the patterns that usually work.
Ler artigo →How to Split a Large CSV File into Smaller Files
Excel caps out around one million rows, and many upload forms reject multi‑megabyte CSVs. Splitting by row count with a repeated header is usually enough.
Ler artigo →How to Merge Multiple CSV Files into One
Stacking CSVs is easy when every file has the same columns. When headers drift, you need a union of column names and empty cells for gaps.
Ler artigo →Import CSV Contacts to iPhone: CSV to vCard (VCF) Guide
iPhone does not open a raw contacts CSV. Convert the sheet to vCard (.vcf), AirDrop or email the file to the phone, then tap to import.
Ler artigo →Generate SQL INSERT Statements from a CSV File
For a few hundred rows, CSV → INSERT is a quick way to seed a table. For large loads, prefer COPY or LOAD DATA — and always escape quotes.
Ler artigo →Copy an HTML Table to CSV or Excel
Browser “Copy” often pastes a table as TSV into Excel. When that fails — merged cells, messy markup — convert the HTML table to CSV instead.
Ler artigo →What Is a TSV File? How to Open and Convert It
A .tsv file is a plain-text table that uses tabs between columns instead of commas. Open it in Excel via import, or convert it to CSV when a tool only accepts commas.
Ler artigo →