{
    "info": {
        "author": "Shahzeb Qureshi",
        "author_email": "shahzeb_iam@outlook.com",
        "bugtrack_url": null,
        "classifiers": [
            "Environment :: Console",
            "Intended Audience :: Developers",
            "Topic :: Software Development"
        ],
        "description": "# Excel to Sitemap (xl2sitemap)\n\n[![PyPI version](https://badge.fury.io/py/xl2sitemap.svg)](https://badge.fury.io/py/xl2sitemap)\n\n**Xl2sitemap** is a command line tool to generate sitemaps using data in an excel sheet. Xl2sitemap reads data from an excel sheet and converts the data into **SEO friendly** sitemaps that can be submitted to search engines directly after uploading.\n\n  - Generates a .xml file\n  - Generates a .xml.gz file (compressed)\n  - Gives you flexibility with the number of urls in a single file\n\n# New Features!\n\n  - Ability to create multiple sitemaps based on classifiers. Classifiers are nothing but different groups for which it is ideal to create different sitemaps. This makes it easier for **indexation problem debugging** as mentioned on the blog [XML Sitemaps] by Moz\n\nYou can also:\n  - Add attributes such as priority, changefreq, lastmod to your urlsets\n\n### Requirements\n\nDillinger uses a number of open source projects to work properly:\n\n* [Python 3] - Python 3 and above\n* A well structured excel file with appropriate column names as mentioned below\n\n#### Structuring your excel sheet\n![Excel sheet format](https://i.imgur.com/JocoeEb.png)\n* The column **_url_** is a **compulsory column** in your excel sheet. This contains the urls of your website\n* The **_classifier_** column is an optional column. This contains the classifier based on which the sitemap file will be split into multiple files. If you are including this column in your excel sheet, make sure you use the ```-c``` flag\n* The **_lastmod_** column is an optional column. This contains the last modified date of the corresponding url in DD/MM/YYYY format. If you are including this column in your excel sheet, make sure you use the ```-l``` flag\n* The **_changefreq_** column is an optional column. This contains the last change frequency of the corresponding url. If you are including this column in your excel sheet, make sure you use the ```-f``` flag\n* The **_priority_** column is an optional column. This contains the priority of the corresponding url. If you are including this column in your excel sheet, make sure you use the ```-p``` flag\n\n\n### Installation\n\nInstallation of xl2sitemap requires running the following command form your command line utility\n\n```\npip install xl2sitemap\n```\n\n### Running from command line\n\nRunning xl2sitemap with the basic default configuration requires running the following command\n\n```\nxl2sitemap example-input.xlsx\n```\nThe ```example-input.xlsx``` can be any excel sheet with the appropriate columns in it\n\nOther options that can be enabled are\n\n| Flag | Usage |\n| ------ | ------ |\n| ```-f``` | Will add ```<changefreq>``` tag in your sitemap |\n| ```-p``` | Will add ```<priority>``` tag in your sitemap |\n| ```-l``` | Will add ```<lastmod>``` tag in your sitemap |\n| ```-c``` | Will split sitemap into multiple files based on the classifier column |\n| ```-m 50000``` | Will add a maximum of 50,000 urls only in a single sitemap. If urls are greater than 50,000 then multiple files will be generated|\n\nExample\n```\nxl2sitemap example-input.xlsx -m 40000 -p -f -l\n```\nThis will generate sitemaps with 40,000 urls in each file with ```<changefreq>```, ```<priority>```, ```<lastmod>``` attributes for each ```<urlset>```.\n\n### Development\n\nWant to contribute? Great!\nOpen your favorite Terminal and run these commands.\n```\ngit clone https://github.com/antiproblemist/excel-to-sitemap.git\n```\n\n\nLicense\n----\n\nBSD 3-Clause\n\nAuthor\n----\nFollow the author on [Linkedin]\n\n**Free Software, Hell Yeah!**\n\n\n   [XML Sitemaps]: <https://moz.com/blog/xml-sitemaps>\n   [Python 3]: <https://www.python.org/downloads/>\n   [Linkedin]: <https://www.linkedin.com/in/shahzebq>\n\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/antiproblemist/excel-to-sitemap",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "xl2sitemap",
        "package_url": "https://pypi.org/project/xl2sitemap/",
        "platform": "",
        "project_url": "https://pypi.org/project/xl2sitemap/",
        "project_urls": {
            "Homepage": "https://github.com/antiproblemist/excel-to-sitemap"
        },
        "release_url": "https://pypi.org/project/xl2sitemap/0.1.3/",
        "requires_dist": [
            "pandas (>=0.24.2)",
            "tqdm (>=4.32.1)",
            "numpy (>=1.16.3)",
            "xlrd (>=1.2.0)"
        ],
        "requires_python": "",
        "summary": "Generate heavy sitemap files using excel sheets",
        "version": "0.1.3"
    },
    "last_serial": 5284708,
    "releases": {
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "59f883d7fb22891dc27a3b17402658ca",
                    "sha256": "93e6399155cb54f878ce85f99f3faa1c43e7878f462d5ee648d9be0fd798f7a8"
                },
                "downloads": -1,
                "filename": "xl2sitemap-0.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "59f883d7fb22891dc27a3b17402658ca",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5207,
                "upload_time": "2019-05-16T09:39:29",
                "url": "https://files.pythonhosted.org/packages/f8/de/6120c3efa23b25fb73623119977c20483034d106c48eddd771e5617207cb/xl2sitemap-0.1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a9211ba2196422369af3a5bfd09ed9ce",
                    "sha256": "f141243e00fcf1fd3d0fb292b2d0a41ec9009001a821ca9be729be58deddeae6"
                },
                "downloads": -1,
                "filename": "xl2sitemap-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "a9211ba2196422369af3a5bfd09ed9ce",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3144,
                "upload_time": "2019-05-16T09:39:31",
                "url": "https://files.pythonhosted.org/packages/e9/6b/3d3410e9ab902c6686ba5899c46b6997629acbc5f5216b3681b03241078c/xl2sitemap-0.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3cd2313a51541faceb0f0fbaa0fe6b07",
                    "sha256": "3589e04daea6b7f1de90671a22931428c6415c01c0d76a9363e7e9abd896a3bc"
                },
                "downloads": -1,
                "filename": "xl2sitemap-0.1.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "3cd2313a51541faceb0f0fbaa0fe6b07",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 6581,
                "upload_time": "2019-05-17T05:08:15",
                "url": "https://files.pythonhosted.org/packages/eb/5f/777d0607514910b95cbb4dc1520374b39ba608f8750fab609573352bbae5/xl2sitemap-0.1.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "0117635f104f1d4816581030802fd460",
                    "sha256": "7793e58037846634d4a67cf38f1e521d1408e20035cb4caacac78c978cfa0804"
                },
                "downloads": -1,
                "filename": "xl2sitemap-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "0117635f104f1d4816581030802fd460",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4935,
                "upload_time": "2019-05-17T05:08:17",
                "url": "https://files.pythonhosted.org/packages/2e/0b/a1b31f3d6b62a75b26809ff673b999996bc9451515cf92e7619d903428b7/xl2sitemap-0.1.2.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "cb021981e4687c9b976371e29d87c79f",
                    "sha256": "52f040a913c496366666fe4f3c7667eab5ef64b06482087d4a49ff746dbaa774"
                },
                "downloads": -1,
                "filename": "xl2sitemap-0.1.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "cb021981e4687c9b976371e29d87c79f",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 6577,
                "upload_time": "2019-05-18T03:50:05",
                "url": "https://files.pythonhosted.org/packages/34/06/8169ef6144f3357782b3414a937f99867cbe0f13a4ff0955e7f33bc6e9ed/xl2sitemap-0.1.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "65f3143fa30179db70cc387012f88a22",
                    "sha256": "7e719784fa69f6a1d4d9bb9dfc44f5689a3da1ffdd8a06ac470dd6ff4dc3078c"
                },
                "downloads": -1,
                "filename": "xl2sitemap-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "65f3143fa30179db70cc387012f88a22",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4927,
                "upload_time": "2019-05-18T03:50:06",
                "url": "https://files.pythonhosted.org/packages/11/4c/b21e49f333d94e929a3c1fdbbb703a4cc531c2d48d0c2cc592b3bdcb1af9/xl2sitemap-0.1.3.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "cb021981e4687c9b976371e29d87c79f",
                "sha256": "52f040a913c496366666fe4f3c7667eab5ef64b06482087d4a49ff746dbaa774"
            },
            "downloads": -1,
            "filename": "xl2sitemap-0.1.3-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "cb021981e4687c9b976371e29d87c79f",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 6577,
            "upload_time": "2019-05-18T03:50:05",
            "url": "https://files.pythonhosted.org/packages/34/06/8169ef6144f3357782b3414a937f99867cbe0f13a4ff0955e7f33bc6e9ed/xl2sitemap-0.1.3-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "65f3143fa30179db70cc387012f88a22",
                "sha256": "7e719784fa69f6a1d4d9bb9dfc44f5689a3da1ffdd8a06ac470dd6ff4dc3078c"
            },
            "downloads": -1,
            "filename": "xl2sitemap-0.1.3.tar.gz",
            "has_sig": false,
            "md5_digest": "65f3143fa30179db70cc387012f88a22",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4927,
            "upload_time": "2019-05-18T03:50:06",
            "url": "https://files.pythonhosted.org/packages/11/4c/b21e49f333d94e929a3c1fdbbb703a4cc531c2d48d0c2cc592b3bdcb1af9/xl2sitemap-0.1.3.tar.gz"
        }
    ]
}