Type Inference for Messy Web DataWeb tables don't have schemas. Every cell is a string. But when you export to SQL, JSON, or load into Pandas, types matter. A column of integers should be INTEGER, not TEXT. A column of "Yes"/"No" valJun 26 · 7 min readgauchogrid.hashnode.dev
The Table Extraction Edge Cases That Took Weeks to SolveWhen I started building HTML Table Exporter, I thought table extraction would be straightforward. Iterate through rows, grab cell text, done. Then I encountered real-world tables. Wikipedia tables thaJun 19 · 8 min readgauchogrid.hashnode.dev
Designing Export Profiles for Different Data WorkflowsA CSV is a CSV, right? Not when your user is a data analyst in Germany opening the file in Excel. Or a Python developer loading it into Pandas. Or a data engineer piping it into BigQuery. Each workfloJun 12 · 5 min readgauchogrid.hashnode.dev
Why I Chose Vanilla JavaScript for a Chrome Extension (No Framework)When I started building HTML Table Exporter, the default choice would have been React or Vue. Maybe TypeScript for safety. I went with vanilla JavaScript instead. No framework. No build step for the cJun 5 · 5 min readgauchogrid.hashnode.dev
Lessons from Users Who Use My Tool Differently Than I ExpectedI built HTML Table Exporter for data analysts who need to pull tables from websites into spreadsheets. That's still the core use case. But users have shown me angles I never anticipated. The Use CasesMay 29 · 4 min readgauchogrid.hashnode.dev