Blog
Short guides around the tools we build.
Formatting Data for Accounting System Imports
Format CSV data for accounting system imports. Clean blank rows and duplicates, fix dates and numbers, and split large files to fit row limits.
Read more
5 min readHow to Export Data From Google Sheets to CSV
Export data from Google Sheets to CSV. Download one sheet, export a range, or publish a CSV link. Then check the file and convert it to XLSX if needed.
5 min read5 Ways to Open a CSV File on Your Phone Without Installing an App
Open a CSV file on your Android or iPhone without installing an app. Use your browser, built-in previews, email, Google Sheets, or Excel for the web.
4 min readHow to Reorder Pages in a PDF
Reorder pages in a PDF with Preview on Mac, Acrobat, code, or a no-upload browser method that combines PDF Split and PDF Merge.
5 min readWhy You Can't Copy Text From a Scanned PDF (and How to Fix It)
Why can't you copy text from a scanned PDF? The pages are images. Learn how to check, convert them to text with OCR, and clean up the result.
3 min readHow to Reduce PDF File Size Without Losing Quality
Reduce PDF file size without losing quality. Compress the PDF structure in your browser, then try other steps when your PDF is full of images.
4 min readHow to Remove Duplicate Rows From a CSV File
Remove duplicate rows from a CSV file online in your browser, or with Excel, Google Sheets, and Python. Learn how duplicates are detected and what to check afterward.
3 min readWhat Is JSON, and How to Convert It to CSV
A plain explanation of the JSON format, how it differs from CSV, and how to turn JSON data into a CSV table you can open in Excel.
5 min readHow to Fix a CSV File That Opens in One Column in Excel
Fix a CSV file that opens in one column in Excel. Check the separator, use Text to Columns, or import with the right delimiter. Plus a way to preview the file first.
3 min readWhy Numbers Change After Opening a CSV in Excel
Why zip codes, phone numbers, and other values reshape themselves when a CSV file opens in Excel, and how to stop it from happening.