Troubleshooting
Fix a spreadsheet view with shifted CSV columns
A spreadsheet may guess the wrong delimiter or encoding and make a valid CSV look misaligned.
Inspect the source record
Keep the original download and inspect its header row with a text viewer before opening a working copy.
Build a focused report
Import the TaxPack CSV as UTF-8 comma-separated text with quoted fields; keep text IDs from being auto-converted.
Read the result
Commas inside a stored label are quoted CSV content and should stay within one column after a correct import.
A concrete example
A rate label such as GST, special can appear in one stored_label cell instead of splitting into two columns.
Avoid this mistaken conclusion
Do not rewrite the exported tax numbers to compensate for a spreadsheet import setting. Fix the import interpretation first.
Official references
These focused notes were drafted with AI assistance and checked against TaxPack behavior and the linked documentation.
These guides explain reporting workflows. TaxPack does not provide tax advice, calculate tax payable, or file returns.