Blog
Each article takes one problem people hit when a CSV, JSON file or screenshot reaches Excel, explains the cause, and gives the manual fix before the AnyToExcel one.
Excel puts a CSV in one column when the file's separator is not your system's list separator. The manual fix in Excel, and how to convert the file in one step.
Excel turns 00123 into 123 because it reads the column as a number. Which data this breaks, how to import the column as text, and how AnyToExcel keeps the zeros.
Excel reads CSV dates in your computer's date order: 03/04/2026 is 4 March in the US, 3 April in Europe. How to import them right, and what stays ambiguous.
How nested JSON objects become dot-path columns like customer.address.city, what happens to arrays and API wrappers, and which JSON shapes do not flatten into rows.
Which screenshots and photos of tables convert to Excel and which do not, how unreadable values are marked with ?, and where the image is sent to be read.