power query m code generate csv type conversion analyze

Power Query Code Generator

Paste CSV to auto-detect column types and generate Power Query M code for type conversion. Row count, null rate, and duplicate stats are also shown. All processing runs in your browser.

Paste CSV here (first row is the header)

USAGE

3 simple steps

1Paste your CSV and click the Analyze button
2Review the inferred type for each column and correct any errors
3Click Generate Code to get the Power Query type conversion code

FAQ

Frequently Asked Questions

Q. Is data sent to a server?

A. No. All processing is done in your browser with JavaScript. Your CSV content is never sent anywhere.

Q. Can I paste data copied from Excel?

A. Yes. Data copied from Excel is tab-separated and is automatically detected and processed.

Q. How many rows can be processed?

A. Processing runs in browser memory, so tens of thousands of rows work without issues.

Q. What if the auto-detected type is wrong?

A. In Step 2's column analysis view, change the type from the dropdown. Click Generate Code after making changes.