Google Sheets CSV Import Checklist
A clean CSV import is easier to trust than a fast one. Before putting marketplace, ecommerce, CRM, payment, inventory, or support data into Google Sheets, run a short checklist so delimiter, headers, blanks, and risky text do not create confusing results.
Pre-import checklist
| Check | Why it matters |
|---|---|
| Delimiter detected correctly | Wrong delimiters can put every row into one column. |
| Headers are unique | Unique headers make filters, formulas, and pivot tables easier. |
| Blank rows removed | Blank rows can break ranges and charts. |
| Blank columns removed | Empty columns make imports harder to scan. |
| Dates normalized | Consistent date formats reduce sorting mistakes. |
| Money normalized | Numeric totals are easier to calculate. |
| Formula-safe export on | User-entered text stays text instead of becoming a formula. |
Suggested workflow
- Load the CSV, TSV, TXT, or first worksheet of XLSX into Universal CSV Cleaner.
- Review the status message for delimiter detection.
- Review the preview table and stats.
- Download the cleaned CSV.
- Import into Google Sheets and compare first rows, last rows, and totals.
After import
Check that row count matches the cleaned preview, important ID columns stayed as expected, dates sorted correctly, and money columns calculate. If something looks wrong, return to the original export and clean a smaller sample first.
This checklist is for spreadsheet preparation only. It does not replace tax, accounting, legal, or financial advice.
For recurring reports, save the import steps you used and repeat the same checks each time. A consistent cleanup process makes it easier to spot when a source export format changes without warning.
If multiple people touch the same sheet, document which cleaned CSV file was imported and when. That small note can save time when a filter, pivot table, or connected report later looks different.
Clean CSV before Google Sheets