List of Indian Pincodes

Table Columns

Use this generator to create an SQL dump of a list of Pincodes, Cities and States in India. To create a quick dump, click the generate button below. It'll create a table structure identical to one displayed in the preview on the left.

To customize your table structure, you can edit the column names, add or edit columns and reorder them by dragging the preview itself.

For detailed description of what each input does, hover over the information icon next to it.

Note: If you are using phpmyadmin to import the file, scroll down to "Format-Specific Options" and uncheck "Do not use AUTO_INCREMENT for zero values"