ViewCSVCSV and Excel guides
Step-by-step answers for getting CSV data into Excel exactly as it was exported, each with a worked example, a sample file and the free browser tool for the job.
All guides
Keep long numbers and leading zeros intact when a CSV opens in Excel
Why IDs turn into 4.02177E+19 or lose their zeros, which fixes work, and what can't be repaired afterwards.
How to import a CSV file into Excel without breaking the data
Power Query and the legacy wizard step by step: delimiter, encoding, header row and Text columns for IDs.
