NB CSV Editor - plugin detail

Graphical editor for CSV files

NetBeans Plugin - NB CSV Editor
Plugin owner: draganknin
Website: https://bitbucket.org/draganbjedov/nb-csv-editor
Added: 2013-04-10
License: GPL v3
Category: Editing
Downloaded: 4,427 times
Rating:
 4.47, by 9 users

Plugin Log Show log

Versions available

Download plugin   Download size: 0.52 MB   Last Update: 2016-11-01

This plugin is also available on the NetBeans Plugin Portal Update Center. Use 'Tools > Plugins' action from the NetBeans IDE main menu for convenient installation of this plugin


What's new in this version

Version 3.0.1

  • Support for NetBeans 8.2

Version 3.0.0

Added

  • Show/hide columns
  • Filter rows (Right-click on column header)
  • Sort rows
  • Tab char as separator

Fixed

  • Using pipe as separator
  • Fixed some minor bugs

Version 2.2.1

Added

  • Reordering rows via Drag and Drop
  • Template description

Improved

  • Row number rendering

Version 2.1.1

  • Fixed some minor bugs

Version 2.1

Added

  • Quoting support
  • Possibility to choose quote/escape charachter

Version 2.0

Added: Possibility to choose separator Set default separator Add additional separators Settings in Tools/Options/Miscellaneous/CSV Editor

Version 1.8.1

  • Plugin is signed

Version 1.8

Added:
  • Move column to the begining
  • Move column left
  • Move column right
  • Move column to the end
  • All actions from toolbar are added to table toolbar
  • Rename column (Double click on column header)
Improved:
  • Calculating column's width


Verifications for NetBeans versions

8.2 verification PASSED See verification details
Download plugin   Download size: 0.52 MB   Last Update: 2015-11-14

This plugin is also available on the NetBeans Plugin Portal Update Center. Use 'Tools > Plugins' action from the NetBeans IDE main menu for convenient installation of this plugin


What's new in this version

Version 3.0.0

Added

  • Show/hide columns
  • Filter rows (Right-click on column header)
  • Sort rows
  • Tab char as separator

Fixed

  • Using pipe as separator
  • Fixed some minor bugs

Version 2.2.1

Added

  • Reordering rows via Drag and Drop
  • Template description

Improved

  • Row number rendering

Version 2.1.1

  • Fixed some minor bugs

Version 2.1

Added

  • Quoting support
  • Possibility to choose quote/escape charachter

Version 2.0

Added: Possibility to choose separator Set default separator Add additional separators Settings in Tools/Options/Miscellaneous/CSV Editor

Version 1.8.1

  • Plugin is signed

Version 1.8

Added:
  • Move column to the begining
  • Move column left
  • Move column right
  • Move column to the end
  • All actions from toolbar are added to table toolbar
  • Rename column (Double click on column header)
Improved:
  • Calculating column's width


Verifications for NetBeans versions

8.1 verification PASSED See verification details
Download plugin   Download size: 0.07 MB   Last Update: 2014-03-05

This plugin is also available on the NetBeans Plugin Portal Update Center. Use 'Tools > Plugins' action from the NetBeans IDE main menu for convenient installation of this plugin


What's new in this version

Version 2.2.1

Added

  • Reordering rows via Drag and Drop
  • Template description

Improved

  • Row number rendering

Version 2.1.1

  • Fixed some minor bugs

Version 2.1

Added

  • Quoting support
  • Possibility to choose quote/escape charachter

Version 2.0

Added: Possibility to choose separator Set default separator Add additional separators Settings in Tools/Options/Miscellaneous/CSV Editor

Version 1.8.1

  • Plugin is signed

Version 1.8

Added:
  • Move column to the begining
  • Move column left
  • Move column right
  • Move column to the end
  • All actions from toolbar are added to table toolbar
  • Rename column (Double click on column header)
Improved:
  • Calculating column's width


Verifications for NetBeans versions

8.0 verification PASSED See verification details
Download plugin   Download size: 0.07 MB   Last Update: 2014-03-05

This plugin is also available on the NetBeans Plugin Portal Update Center. Use 'Tools > Plugins' action from the NetBeans IDE main menu for convenient installation of this plugin


What's new in this version

Version 2.2.1

Added

  • Reordering rows via Drag and Drop
  • Template description

Improved

  • Row number rendering

Version 2.1.1

  • Fixed some minor bugs

Version 2.1

Added

  • Quoting support
  • Possibility to choose quote/escape charachter

Version 2.0

Added: Possibility to choose separator Set default separator Add additional separators Settings in Tools/Options/Miscellaneous/CSV Editor

Version 1.8.1

  • Plugin is signed

Version 1.8

Added:
  • Move column to the begining
  • Move column left
  • Move column right
  • Move column to the end
  • All actions from toolbar are added to table toolbar
  • Rename column (Double click on column header)
Improved:
  • Calculating column's width


Verifications for NetBeans versions

7.4 verification PASSED See verification details
Download plugin   Download size: 0.07 MB   Last Update: 2014-03-05

This plugin is also available on the NetBeans Plugin Portal Update Center. Use 'Tools > Plugins' action from the NetBeans IDE main menu for convenient installation of this plugin


What's new in this version

Version 2.2.1

Added

  • Reordering rows via Drag and Drop
  • Template description

Improved

  • Row number rendering

Version 2.1.1

  • Fixed some minor bugs

Version 2.1

Added

  • Quoting support
  • Possibility to choose quote/escape charachter

Version 2.0

Added: Possibility to choose separator Set default separator Add additional separators Settings in Tools/Options/Miscellaneous/CSV Editor

Version 1.8.1

  • Plugin is signed

Version 1.8

Added:
  • Move column to the begining
  • Move column left
  • Move column right
  • Move column to the end
  • All actions from toolbar are added to table toolbar
  • Rename column (Double click on column header)
Improved:
  • Calculating column's width


Verifications for NetBeans versions

7.3 verification PASSED See verification details
Download plugin   Download size: 0.06 MB   Last Update: 2014-03-05

What's new in this version

Version 2.2.1

Added

  • Reordering rows via Drag and Drop
  • Template description

Improved

  • Row number rendering

Version 2.1.1

  • Fixed some minor bugs

Version 2.1

Added

  • Quoting support
  • Possibility to choose quote/escape charachter

Version 2.0

Added: Possibility to choose separator Set default separator Add additional separators Settings in Tools/Options/Miscellaneous/CSV Editor

Version 1.8.1

  • Plugin is signed

Version 1.8

Added:
  • Move column to the begining
  • Move column left
  • Move column right
  • Move column to the end
  • All actions from toolbar are added to table toolbar
  • Rename column (Double click on column header)
Improved:
  • Calculating column's width


Verifications for NetBeans versions

Plugin is not subject to any verification



Introduction

Graphical editor for CSV files. Graphical view is table. Avalible operations are:
  • Add/Remove rows/columns
  • Copy rows
  • Cut rows
  • Paste rows
  • Move up rows
  • Move down rows
  • Move rows to the top
  • Move rows to the bottom
  • Undo/Redo
  • Move columns to the beginning
  • Move columns left
  • Move columns right
  • Move columns to the end
  • Choose separator
  • Quoting support
  • Show/hide columns
  • Filter rows (Right-click on column header)
  • Sort rows

[ You have to be logged in to be able to comment. ]

User Comments

  

Re: Little Feature Proposal

Hi Luigi,
Proposed feature can be done. It will be in next revision.
Next revision will appear during this month.

Best regards,
Dragan
Posted by draganknin on Sep 08, 2015
  

Little Feature Proposal

Hi, very very good job with this plugin.
Just one thing: many user use OpenCSV or other lib that manage CSV also by colunm number starting from 0 and I didn't find column index nowhere in the plugin screen.
Is possible for you add this little feature (I suggest before column name like: [0]col0_name | [1]col1_name...)?
Thanks in advance.

Luigi
Posted by kungfutaras on Sep 08, 2015
  

Can't use pipe or tab as a separator

When I add the pipe symbol | as a separator and use that in pipe delimited file, the plugin creates one column for each character. It seems the pipe is ignored and the lines are split after each character

Additionally there is no way to define a tab character (\t) as the delimiter.
Posted by tkellerer on Aug 29, 2014
  

Re: limited to 1MB file size :-(

Hi wegus,
Warning which you is standarad NetBeans IDE warning. I was used plugin with files much larger for example 5 MB with no problems, so you can ignore warning and procced with openning your file. If have problems please post it here.

Best regards,
Dragan
Posted by draganknin on Aug 28, 2014
  

limited to 1MB file size :-(

as i have to deal daily with generating CSV Exchange-Files i was happy to read of this plugin. Unfortunatley my files are 1 to 2MB of size and the plugin refuses/warns to load them.

I would love to see a version that can handle larger files, without risking IDE stability!
Posted by wegus on Aug 27, 2014
  

Separator input

Hi,
thanks for the nice module. I am also interested in adding the possibility to configure the tab as a separator.

I have written some code to import csv in my platform app and for them I have implemented an option panel with a combobox to select the default delimiter. This component also shows some none printable delimiters by corresponding names e.g. "". The unprintable delimiters can not removed from or added to the list, they are hardcoded in the list. In the gui panel I can add only printable delimiters. Maybe you can implement something similar.

best regards
Oliver
Posted by oliverrettig on Jun 12, 2014
  

Re: Separator input?

I will check that. Maybe there is problem with tab.
Posted by draganknin on Mar 28, 2014
  

Separator input?

Hello! This editor looks nice and useful.

However, we couldn't use it outside of testing yet, because of an issue with separators.

Tab (HT, 0x05) as separator is not part of the default settings. The Options/CSV Editor/Separator pane allows to enter separator characters; but so far, we didn't succeed in entering a tab here.

So - How to select tab as field separator?

regards
Posted by metabit on Mar 28, 2014
  

Reported issue on NB 8.0 Beta

Hi there,

I was doing the plugin verification and got an exception. You can get all the details in the reported ticket here:
http://statistics.netbeans.org/analytics/exception.do?id=713830

Carlos
Posted by carlosqt on Feb 22, 2014
  

Re: Re: add row/column buttons disabled after adding 1 row/column

This is fixed now. Download new plugin version. It should be available soon in Update Center.
Posted by draganknin on Dec 26, 2013
  

Re: add row/column buttons disabled after adding 1 row/column

I will check that.
Posted by draganknin on Nov 17, 2013
  

add row/column buttons disabled after adding 1 row/column

hi there,

I'm not sure if this is only happening to me or in OS X environment NB7.4, but once you click the first time on the Add Row or Add Column buttons, it add the row/column but the buttons get disabled and they are not enabled anymore, I have to do it in text mode.

regards

Carlos
Posted by carlosqt on Nov 17, 2013
  

Re: Quoting support

I'm currently work on Quoting support. It will be added soon as possible.
Posted by draganknin on Nov 08, 2013
  

Quoting support

Also, looks like quoted values are not supported. I noticed this because quotes were included in the table cells. I then added a comma inside a quoted value using the Text view. When I switched back, the data was shifted to the right after the comma occurrence.
Posted by XedinUnknown on Nov 06, 2013
  

Error opening non UTF-8 files

Hi! Just installed the plugin and restarted the IDE. When opening a CSV file, I get the "cannot be safely opened with encoding UTF-8" error. I understand that it is purely informative, and I imagine that I am supposed to be able to choose to continue.

Also, all the chars that I can see are UTF-8, because I can easily open it as text, without the plugin installed.

UPDATE: it is possible to work around the issue by closing the error window, switching to Text view (the dialog will pop up asking if OK to open non UTF-8 file), answering Yes, then switching to table mode.
Posted by XedinUnknown on Nov 06, 2013
  

Re: Incorect parsing or csv row

I did not take care of escape symbols.
It's a good suggestion. When I got some time I'll add it, with ability
to choose default in settings.
Posted by draganknin on Oct 29, 2013
  

Incorect parsing or csv row

i have row like follow
test2,Test 2,1,10,12,8,"streetname,building,apartment,comment",Test method 2,

and plugin parse , in "" as field separator.
i thin it will be good add more settings for parser such as enclosure and escape symbols

PS: useful plugin.thanks for it
Posted by AlxLy on Oct 29, 2013
  

Good job

Very nice. Thank you for adding separator, now I've got one less reason to leave my IDE :-)

I do also have a suggestion on further improvement: Cut, copy and paste cell (with shortcuts ctrl+x/c/v).
Posted by tommy_bo on Sep 17, 2013
  

Thank you.

Great job!
Thanks a lot now is perfect for me. I voted it 5 stars.
Suggestion: A possible improvement for a future version could be line sorting basing on the selected column. Actually I don't need this function for my work but could be nice to add it if you plan to further improve this plugin, it's just a suggestion.
Posted by -Silver- on Sep 16, 2013
  

Re:Semicolon separated values

Added possibility to choose separator
Posted by draganknin on Sep 14, 2013
  

Semicolon separated values

This seems promising, but as -Silver- stated, it should be possible to separate by semicolon.
Posted by tommy_bo on Aug 27, 2013
  

Great Idea!!

Dealing with Excel is always worst experience when dealing with csv.
Especially when you are dealing with numbers with 0 prefixes.

I haven't this plug-in yet but I'm sure our worries are lessened.

Posted by jeykeu on Aug 20, 2013
  

Re: I can't choose the separator

It will be added in new version
Posted by draganknin on Jul 01, 2013
  

I can't choose the separator

Could be useful for me but..
is it not possible to change the separator character? For example my csv file have all ";" as separator instead "," so it is currently useless for me.
Posted by -Silver- on Jun 30, 2013
  

Looks great

:)
Posted by tomzi on Apr 18, 2013
By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo