Editing Table Data Like a Spreadsheet

An easy approach to editing your data.
Arctype enables users to interact with tables in intuitive ways. One powerful feature Arctype provides is the ability to directly edit table data, just like a spreadsheet.

Finding your table

After opening Arctype and setting up your connection, use the left-hand navigation menu to find the Table tab. After selecting the Table tab, click on the table you’d like to work with. This will open your data in the Table view.
Table view

Viewing rows

By default, your data is displayed in a table form, with rows and columns. However, not all data is displayed on the screen at once. Instead, Arctype paginates data to keep the application fast and snappy. To view additional pages of data, you can use the pagination buttons along the bottom of the app window, or type in the page number you want to jump to. To increase the number of rows rendered on each page, right-click on the context menu in the upper right and modify the Rows per page value to whatever number you prefer. Then click Apply.
Changing pagination settings

Insert or remove a row

You can insert a row of data directly from the Table view. To do this, select the Insert Row button in the top right. You can also remove a row by selecting any cell in it and hitting the Backspace or Delete keys.
Confirming a deletion
Be sure you actually want to remove the row and its data before accepting the confirmation prompt.

Adding, removing, or editing a column

To add or remove a column, right-click on the context menu in the upper right corner of the application, as shown below. Then, select the Edit Table option.
Editing the table
This option will bring up the Edit table window. From this window, you can modify your data’s schema as you wish. Refer to the documentation on editing your schema for more information on this page.
To add a column, select the Add Column button in the top right. This will bring up a highlighted column configuration entry. Provide your column with a name, choose its type, and provide a default value. You can also configure any constraints, keys, and checks here.
Adding a new column
You can also modify existing column names here, or directly from the table view. For more information, refer to the schema documents.
When you’re satisfied with your changes, choose the Review button in the top right and verify that the changes fit your expectations. If everything looks good, accept the changes by clicking Apply.
Confirming your changes
To remove a column, simply return to the Edit table window and choose the X next to the column in question. Review the changes and choose Apply to complete the deletion.

Inspecting, copying, and pasting cell data

Arctype goes beyond spreadsheet tools like Excel and Sheets by providing you with a powerful cell inspection tool. To access the cell inspector, simply double-click on the cell. The cell inspector will appear on the right-hand side of the application.
The Cell Inspector
Double-clicking on a cell also allows you to edit it. You can type in the cell itself, or change the cell value in the Cell Inspector. If you edit the cell directly, pressing Enter or Return will save your changes. If you edit the cell in the Cell Inspector, choosing Update at the bottom of the window will save your changes. Cancel will discard them.
You can also copy a cell. Pressing Cmd+C or Cntrl+C while highlighting the cell will copy it to your clipboard. You can also copy the cell from the Cell Inspector by choosing the Copy Cell Content icon.
Copying a cell
To paste a cell’s contents, simply edit a cell and use your paste shortcut (Cmd+P or Cntrl+P).

Interacting with JSON data

The Cell Inspector described above is particularly useful for interacting with JSON data. It allows you to view a large number of characters (typical of JSON table cells) in a clean manner.
Inspecting JSON
JSON is automatically formatted in the Cell Inspector, allowing you to quickly diagnose problems, modify values, or study your data's structure.
Viewing JSON data
For more information about working with JSON in SQL databases, check out this Arctype blog article.

Resizing a column

Arctype allows you to resize columns for easy reading. Select the column you want to expand and double-click the right-most column boundary to expand the column to be the same width as its widest cell. You can also drag the column dividers to manually resize them.
Resizing a row
Resize your entire view Arctyp supports app-wide zoom levels. Press Cmnd + + or Cntrl + + to zoom in, and Cmnd + - or Cntrl + - to zoom out. Export to CSV or Excel Arctype allows you to export your data to either CSV or Excel format. Select your table and choose Export in the top right, then choose your target data format. Arctype will prompt you for a destination. Choose your destination and download your data.
If you want to import data, refer to the documentation on importing a CSV into Arctype.