Guides

Why your data breaks in Excel, and how to fix it

Each guide 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.

• Why Excel Puts Your Whole CSV in One Column

  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.

• Why Excel Deletes the Zeros From Your Product Codes

  Excel turns 00123 into 123 and cuts numbers past 15 digits when it opens a CSV. Which values can be recovered, why saving makes it permanent, and how to import the columns as text.

• Why 03/04 Became 4 March in Your Spreadsheet

  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.

• Turning Nested JSON Into Spreadsheet Columns

  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.

• Getting a Table Out of a Screenshot

  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.