Standards and practical decisions
Tool resources
Use cited guides and worked examples to check formats, accessibility rules, chemical reactions, and probability calculations.
Fix data imports and conversions
Start here when a table loses identifiers, a JSON number changes, or an import rejects a file.
- CSV and JSON workflow guideCheck headers, quoted cells, nested values, and identifiers before converting a table.
- Choose a conversion approachCompare browser tools, spreadsheets, and scripts for the shape and size of your data.
- Compare spreadsheet workflowsCheck how spreadsheet imports handle leading zeros, large numbers, and column types.
- Estimate workflow costAccount for conversion time, manual checks, and repeat work when choosing a process.
- Implement a checked conversionBuild a conversion process with fixed test cases and explicit checks for data loss.
- JSON numbers and duplicate keys: preserve the original digits and namesCheck large integers, decimal precision, duplicate names, member order, and CSV leading zeros against real tool behavior.
- Convert CSV and JSON Privately in Your BrowserConvert CSV and JSON privately in your browser. Learn safe parsing, type choices, UTF-8 handling, formula injection risks, validation, and file checks.
Identify an unfamiliar format
Separate encoding from encryption, identify a key container, or interpret bytes before applying a conversion.
- How to choose a cipher decoderChoose a cipher decoder from the available clues. Separate encoding, known-key decoding, and unknown-cipher analysis before changing your message.
- Read binary encodings: identify the boundaries before the valueRecognize byte encodings, then read varints, BCD, Base32, Base64, hex dumps, DER, and OIDs by hand.
- Key and certificate formats: identify the container before convertingDistinguish PEM, DER, PKCS#1, PKCS#8, SPKI, X.509, CSR, JWK, and OpenSSH formats with public test examples.
- Image File Formats Compared: JPEG, PNG, WebP, AVIF, and SVGCompare JPEG, PNG, WebP, AVIF, and SVG by quality, transparency, animation, metadata, and compatibility. Choose a format safely before converting files.
- Encoding, Hashing, and Encryption: What Each Method DoesLearn the differences between encoding, hashing, and encryption. Choose Base64, SHA-2, AES, or another method for data transport, integrity, or secrecy.
Check units, rules, and assumptions
Use these references when a calculation depends on time zones, physical states, probability rules, or ramp dimensions.
- ADA ramp rules: plan the landings before the slopeRead the 2010 ADA ramp requirements and a calculated segment plan. Check landings, width, handrails, and scope.
- Solubility rules and net ionic equations: decide what stays togetherApply solubility exceptions before cancelling ions. Follow precipitation, weak-acid, gas-forming, and no-reaction examples.
- How dice probability works: average is only the startCompare exact dice averages, spread, advantage, keep-highest rules, and one-time rerolls with reproducible expressions.
- Convert UNIX Timestamps and Handle Time Zones SafelyConvert UNIX timestamps and handle time zones safely. Learn seconds versus milliseconds, UTC offsets, DST rules, ISO 8601 output, and calendar pitfalls.