CSV, JSON, and Excel in Python

From the Pandas cheat sheet ยท Import and Export ยท verified Aug 2026

CSV, JSON, and Excel

Load and save common text and spreadsheet formats.

python
df = pd.read_csv("input.csv")
df.to_csv("output.csv", index=False)
๐Ÿ“Œ Select columns and dtypes during ingestion
๐Ÿ’ก Parse dates while reading when practical
๐Ÿ” Excel support requires an engine package
โš ๏ธ JSON orientation must match the consumer
csvjsonexcelio

Continue with Pandas

Save the full cheat sheet or work through every related task.

More Python tasks

Back to the full Pandas cheat sheet