How do I get "table view" working for CSV data in PyCharm?

Question

I used to able to rely on the ability to edit CSV data in PyCharm (and other JetBrains IDEs) in a fully functional tabular view:

however I can't find this functionality anywhere in my current version (5.0.x).

How do I get this functionality back?

---

Note that it appears that I can right click on the selected text of the CSV and choose something called (incorrectly and misleadingly) "Edit as Table..."; but this can't be intended as a replacement for the missing functionality!

Solution 1

According to the PyCharm Docs:

For the table editor and associated features to be available:

• You should be using the Professional Edition of PyCharm. (The corresponding functionality is not available in the Community Edition.)
• The Database Tools and SQL plugin must be enabled. (This plugin is bundled with the IDE and enabled by default.)
• The file name extension must be associated with the text file type. See e.g. File Types.

I use Professional Edition, so im my case, the issues was in missing association of file type. I fix it next:

1. Go to `File | Settings | Editor | File Types
2. Find Text file type
3. Add *.csv to the Text file type.
4. Save end exit

Solution 2

Please vote for DBE-1845 to be notified on any progress. As a temporary workaround you can try assigning a keyboard shortcut to "Edit as Table..." action as suggested in https://youtrack.jetbrains.com/issue/DBE-1845#comment=27-1193834

Comments

[orome]

Yes, As indicated I know about "Edit as Table..." That can't be the intended solution, can it? That leads to a useless and dysfunctional UI. I guess this means JetBrains really did remove this feature and that until it's restored one must just use an external third-party CSV editor. (That's an answer I'd accept.)

[hamx0r]

As this question is about PyCharm, the link to PHPStorm may not be the best fit. Here's the same bug for PyCharm to vote on: youtrack.jetbrains.com/issue/PY-11840

[lena]

The link is to DBE, not PHPStorm. DBE is a host project for database support, and youtrack.jetbrains.com/issue/DBE-1845 is the correct ticket. The PyCharm bug mentioned by you was fixed as far back as in PyCharm 133.* and is now obsolete. And it has absolutely no relation to current issue

[lena]

BTW, was it you who downvoted my answer? What's the reason for that?

[hamx0r]

Your answer had a -1 score when i found this SO page. I did not downvote it. Viewing a CSV file is not the same as a database table, so the link you shared still doesn't seem to be a perfect fit (while it may be the best fit available). The issue i linked to, while obsolete, does represent a PyCharm-specific issue, and an additional link to the incorrect documentation which should be updated: jetbrains.com/pycharm/help/editing-csv-files.html#d60551e451

[Jerry101]

The relevant PyCharm 2017.3 help page has the same prerequisites but it seems to work even without adding to the Text file type. It'd be really nice to not have to invoke the "Edit as Table..." manually each time you open a file.