{"id":24411,"library":"pytablereader","title":"pytablereader","description":"pytablereader is a Python library to load structured table data from files, strings, or URLs supporting multiple formats: CSV, Excel, Google Sheets, HTML, JSON, LDJSON, LTSV, Markdown, SQLite, TSV. Currently at v0.31.4, with a monthly/bimonthly release cadence and active maintenance.","status":"active","version":"0.31.4","language":"python","source_language":"en","source_url":"https://github.com/thombashi/pytablereader","tags":["table","csv","excel","google-sheets","html","json","sqlite","markdown","data-loading"],"install":[{"cmd":"pip install pytablereader","lang":"bash","label":"Install core library"},{"cmd":"pip install pytablereader[excel]","lang":"bash","label":"Install with Excel support (openpyxl)"},{"cmd":"pip install pytablereader[html]","lang":"bash","label":"Install with HTML support (lxml)"},{"cmd":"pip install pytablereader[gs]","lang":"bash","label":"Install with Google Sheets support (gspread)"}],"dependencies":[{"reason":"Database loading support","package":"SimpleSQLite","optional":false},{"reason":"Path validation","package":"pathvalidate","optional":false},{"reason":"Excel file reading","package":"openpyxl","optional":true},{"reason":"HTML/XML parsing","package":"lxml","optional":true},{"reason":"Google Sheets access","package":"gspread","optional":true}],"imports":[{"wrong":"from pytablereader import load_tables","symbol":"load_tables","correct":"from pytablereader import load_tables"}],"quickstart":{"code":"from pytablereader import load_tables\n\n# Load CSV from URL\ntables = load_tables('https://raw.githubusercontent.com/thombashi/pytablereader/master/example.csv')\nfor table in tables:\n    print(table)\n\n# Load from file\nwith open('data.csv') as f:\n    tables = load_tables(f)\n    for table in tables:\n        print(table)","lang":"python","description":"Basic usage: load table data from a file path, URL, or file-like object. The function returns a generator of TableData objects."},"warnings":[{"fix":"Use Python 3.7+ and update any Python 2 specific code.","message":"Dropped Python 2 support in v0.28.0. Code using Python 2 idioms will break.","severity":"breaking","affected_versions":">=0.28.0"},{"fix":"Pass type_hints=True to load_tables or loader classes to enable type detection.","message":"The old type detection for CSV was disabled by default in v0.31.0. Use type_hints argument explicitly if you need automatic type detection.","severity":"deprecated","affected_versions":">=0.31.0"},{"fix":"Set up gspread authentication (service account or OAuth) before calling load_tables with a Google Sheets URL.","message":"When using Google Sheets, the library requires authentication via gspread. If oauth2 credentials are not set, loading will fail with auth errors.","severity":"gotcha","affected_versions":"all"},{"fix":"Ensure file paths are valid for the platform; use raw strings or os.path functions.","message":"File paths with special characters may cause path validation errors on some platforms. The library uses pathvalidate for validation.","severity":"gotcha","affected_versions":"all"}],"env_vars":null,"search_vec":"'activ':40 'cadenc':38 'csv':20,43 'current':31 'data':11,53 'data-load':52 'excel':21,44 'file':13 'format':19 'googl':22,46 'google-sheet':45 'html':24,48 'json':25,49 'ldjson':26 'librari':6 'load':8,54 'ltsv':27 'mainten':41 'markdown':28,51 'monthly/bimonthly':36 'multipl':18 'pytableread':1,2 'python':5 'releas':37 'sheet':23,47 'sqlite':29,50 'string':14 'structur':9 'support':17 'tabl':10,42 'tsv':30 'url':16 'v0.31.4':33","created_at":"2026-05-01T08:12:56.547071+00:00","updated_at":"2026-05-01T08:12:56.547071+00:00","problems":{"verify_error":"Traceback (most recent call last):\n  File \"<string>\", line 1, in <module>\nImportError: cannot import name 'load_tables' from 'pytablereader' (/tmp/tmpiywg1kqr/venv/lib/python3.12/site-packages/pytablereader/__init__.py)"},"ecosystem":"pypi","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":"0.31.4","cli_name":"","cli_version":null,"type":"library","homepage":null,"github":"https://github.com/thombashi/pytablereader","docs":"https://pytablereader.rtfd.io/","changelog":null,"pypi":"https://pypi.org/project/pytablereader/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["data","serialization"],"base_url":null,"auth_type":null,"provenance":{"verified_status":"import_fail","verified_at":"2026-07-03","last_verified":"2026-07-03","next_check":"2026-07-10","install_tag":null}}